Supress DIV/0
 

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

Supress DIV/0
 

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Supress DIV/0
 

Colin Hayes wrote:

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.

Add another if that explicitly checks E3=0:

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

Change the "" to whatever you want to happen when you would normally get
div/0 error.

--
That's an ugly monkey.

Supress DIV/0
 

In article , Claus Busch
writes
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.

Hi

Perfect solutions. Thank you.



Best Wishes