Supress DIV/0

[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

 

[Claus Busch]

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?

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.

 

[Colin Hayes]

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.

Hi

Perfect solutions. Thank you.



Best Wishes