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