Getting #DIV/0!, how to get 0%?
Try it like this:
=IF(E34=0,0,(E34-D34)/E34)
--
Biff
Microsoft Excel MVP
"pgarcia" wrote in message
...
I'm getting #DIV/0! with the following formula, the cell is format as a
percent. Thanks
=(E34-D34)/E34
E34 = 0
D34 = 0
Result should be 0%
|