Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have tried to figure out how to write this formula so it will produce
either the correct result or show nothing. Here is an example 2009 2008 % -/+ 50.00 100.00 -0.5% 100 0 0% 0 100.00 -100% I can write =if(sum(cell 1 - cell 2)/cell 2 = "", "", sum(cell 1 - cell 2)/cell 2)) The second row will display #DIV/0! I would like the second row to display 0 ... Can someone tell me how to write that formula? Thanks much! Annette |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Tables - Variance and Variance % | Excel Discussion (Misc queries) | |||
Percent Variance Formula | Excel Discussion (Misc queries) | |||
Formula for calculating Variance | Excel Discussion (Misc queries) | |||
Excel % Variance Formula........ | Excel Worksheet Functions | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |