| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
trying to add to a if statement
I have this statement in B3;
=IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3) I need to add; if C3 0 then B3 = C3 can this be done along with the first "if" Thanks in advance...David D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to add to a if statement
=IF(C30,C3,IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3))
-- David Biddulph "David" wrote in message ... I have this statement in B3; =IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3) I need to add; if C3 0 then B3 = C3 can this be done along with the first "if" Thanks in advance...David D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to add to a if statement
=IF(January!C30,January!C3,IF(OR(January!B3 = 0,January!B3 =""),0,
January!B3-January!E3)) -- __________________________________ HTH Bob "David" wrote in message ... I have this statement in B3; =IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3) I need to add; if C3 0 then B3 = C3 can this be done along with the first "if" Thanks in advance...David D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
trying to add to a if statement
if
I need to add; if C3 0 then B3 = C3 can this be done along with the first "if" maybe =IF(and(January!B3 = 0,January!C3 =0),0,(January!C3 =0)*(January!B3<0)*(January!B3-January!E3)+(January!B3 =0)*(January!C30)*(January!C3-January!E3)) "David" wrote: I have this statement in B3; =IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3) I need to add; if C3 0 then B3 = C3 can this be done along with the first "if" Thanks in advance...David D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum if statement with a left statement | Excel Discussion (Misc queries) | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
