J JDM May 8, 2008 #1 Hello! I need my variance number to show 0% even when the formula's answer is #DIV/0!
A Adilson Soledade May 9, 2008 #2 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.
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.
