Variance Report - Need to reflect 0%
If your data is the range A1:A100, you could use this:
=IF(ISERROR(VAR(A1:A100)),0,VAR(A1:A100))
To show the % sign just change the cell format.
--
Adilson Soledade
"JDM" wrote:
Hello! I need my variance number to show 0% even when the formula's answer
is #DIV/0!
|