| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Variance Report - Need to reflect 0%
=IF(A2=0,0,B2/A2)
adapt to fit -- Regards, Peo Sjoblom "JDM" wrote in message ... Hello! I need my variance number to show 0% even when the formula's answer is #DIV/0! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I reflect a (-) outcome as 0 | Excel Worksheet Functions | |||
| one cell does not reflect a sum | 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) | |||
Linear Mode
