If you have the subscription version of Excel you can create your own functions. One that you may want to create avoids the #DIV/0! error. In the DAX function language in Power Pivot and Power BI there is a DIVIDE function that avoids divide by zero errors. You can now mimic that function in Excel. … Continue reading Avoid the #DIV/0! Error in Excel