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
|