Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Supress rows | Excel Discussion (Misc queries) | |||
supress message | Excel Programming | |||
Supress #Ref! error | Excel Worksheet Functions | |||
#div/0! how do i supress? | Excel Worksheet Functions | |||
Supress error message | Excel Discussion (Misc queries) |