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