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

Vaya con Dios,
Chuck, CABGx3



"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