Nothing wrong, you can't divide by zero so that is what it is telling you,
you can add this

=IF(B5=0,"",(E5/B5)*100)

will be blank if B5 is blank or zero, replace "" with 0 if you want zero as
an answer

--
Regards,

Peo Sjoblom

(No private emails please)


"bluenoser1946"
wrote in message
news:bluenoser1946.1teomj_1123437929.3228@excelfor um-nospam.com...

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