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