Although your formula works and is more sound logically the OR is not needed
since excel see a blank as zero so =0 is enough to test both for blanks and
zeros

--
Regards,

Peo Sjoblom

(No private emails please)


"bigwheel" wrote in message
...
The error showing in D5 shows that you attempted to divide by zero (or
blank
which amounts to the same in this case) You could test for this condition
(i.e. B5 = 0 or blank) by amending your formula to
=IF(OR(B5="",B5=0),"",(E5/B5)*100) which will result in D5 showing blank
unless B5 is something other than 0 or ""


"bluenoser1946" wrote:


I have this formula in Column "D"

=(E5/B5)*100

E5 is 0.00 and B5 is Blank.

D5 displays #DIV/0!

What have I done wrong?

old dog learning new tricks


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile:
http://www.excelforum.com/member.php...o&userid=26006
View this thread:
http://www.excelforum.com/showthread...hreadid=393688