I am still getting a Value after changing formula to instead of #DIV/0!
=IF(c13=0,0,(c12:c16)/c13

"Peo Sjoblom" wrote:

=IF(E34=0,0,(E34-D34)/E34)

--


Regards,


Peo Sjoblom



"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%