I don’t know about you, but I hate seeing #DIV/0! in any spreadsheet. For those of us struggling with OCD, we always use the IfError() function. And for those of us who have been using Excel for years, we paired IsErr() with an IF statement.
Quantrix has us covered for dealing with results where the denominator is zero. It’s the ClearError function, and it’s very easy to use, as I explain in the video below:
As always, as a G3VIP member, let me know if you want the underlying file.
