| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement help
my if statement is =IF(C29-C26=0,0,) However, how do I put in the actual
amount in this cell if C29-C26< 0? Not sure how to do this? thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement help
=IF(C29-C26=0,0,C29-C26)
-- JNW "help!" wrote: my if statement is =IF(C29-C26=0,0,) However, how do I put in the actual amount in this cell if C29-C26< 0? Not sure how to do this? thanks in advance! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If statement help
=IF(C29-C26=0,0,C29-C26) or merely =MIN(C29-C26,0)
-- David Biddulph "help!" wrote in message ... my if statement is =IF(C29-C26=0,0,) However, how do I put in the actual amount in this cell if C29-C26< 0? Not sure how to do this? thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| IF statement(?) | Excel Discussion (Misc queries) | |||
| If statement and Isblank statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
