View Single Post
  #1   Report Post  
bluenoser1946
 
Posts: n/a
Default New Display Problem


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