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


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=393688

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


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile:
http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=393688

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


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=393688

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


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile:
http://www.excelforum.com/member.php...o&userid=26006
View this thread: http://www.excelforum.com/showthread...hreadid=393688

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)


"bigwheel" wrote in message
...
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 :confused:


--
bluenoser1946
------------------------------------------------------------------------
bluenoser1946's Profile:
http://www.excelforum.com/member.php...o&userid=26006
View this thread:
http://www.excelforum.com/showthread...hreadid=393688