New Display Problem

B

bluenoser1946

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 :confused:
 
B

bigwheel

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 ""
 
P

Peo Sjoblom

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" <[email protected]>
wrote in message
news:[email protected]...
 
P

Peo Sjoblom

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)
 
Top