Supress DIV/0

  • Thread starter Thread starter Colin Hayes
  • Start date Start date
C

Colin Hayes

HI

My formula in F3 is

=IF(B3="W",(SUM(C3/E3)*D3),C3*-1)

How can I amend this to suppress the DIV/0 error when I put "W" in B3?

I've seen various formulae which suggest they can do this , but can't
see how to merge them into the existing formula.


Grateful for any help.



Best Wishes
 
Hi Colin,

Am Tue, 8 Oct 2013 19:21:38 +0100 schrieb Colin Hayes:
=IF(B3="W",(SUM(C3/E3)*D3),C3*-1)

How can I amend this to suppress the DIV/0 error when I put "W" in B3?
Click to expand...

for versions 2007 or later:
=IFERROR(IF(B3="W",C3/E3*D3,-C3),"")

Other versions:
=IF(E3=0,"",IF(B3="W",C3/E3*D3,-C3))


Regards
Claus B.
 
Claus Busch said:
Hi Colin,

Am Tue, 8 Oct 2013 19:21:38 +0100 schrieb Colin Hayes:


for versions 2007 or later:
=IFERROR(IF(B3="W",C3/E3*D3,-C3),"")

Other versions:
=IF(E3=0,"",IF(B3="W",C3/E3*D3,-C3))


Regards
Claus B.
Click to expand...

Hi

Perfect solutions. Thank you.



Best Wishes
 
Back
Top