Hi David,
I have the same problem as above, but my formula is slightly different:
=(J37-C37)/ABS(C37). I compare two values and want to get the percentage of
increase or decrease between the two. Sometimes one of the values (or both)
is zero, and then it gives an error. I Tried the advice given above but I
must do something wrong as it still gives an error. Thanks for helping me.
Kaimarja

"David Biddulph" wrote:

=IF(E34-D34=0,0,IF(E34=0,"infinite % difference",(E34-D34)/E34))

Note that with the formulae which some other contributors have suggested,
you would get the same answer for an input of D34=99 and E34=0 as you would
get for D34 and E34 both 99. Is that what you want?
--
David Biddulph

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