| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variance Report - Need to reflect 0% | Excel Discussion (Misc queries) | |||
| how do I reflect a (-) outcome as 0 | Excel Worksheet Functions | |||
| Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
| Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
| Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) | |||
Threaded Mode
