You are using a range divided by a number and you should change that to a
single cell

=IF(C13=0,0,C12/C13)


or something


and the only way you can get a value error is if C13 itself has a DIV error
in it.


Maybe you should explain what you are trying to do instead?

--


Regards,


Peo Sjoblom


"kevin" wrote in message
...
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%