If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Variance Report - Need to reflect 0%
Hello! I need my variance number to show 0% even when the formula's answer
is #DIV/0! |
#2
|
|||
|
|||
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! |
Thread Tools | |
Display Modes | |
|
|