| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Restraints on an "if" statement
Hi there,
I have a simple "if" statement and am trying to add a constraint. Essentially, the statement is: If(AB, C, D) However, I wan to say if "A" is a negative number, then it should be 0 (can't have a negative number). Anyone have any advice? Thanks |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Restraints on an "if" statement
if(a<0,0,if(ab,c,d)) should do it
Marion "jmac2006" wrote: Hi there, I have a simple "if" statement and am trying to add a constraint. Essentially, the statement is: If(AB, C, D) However, I wan to say if "A" is a negative number, then it should be 0 (can't have a negative number). Anyone have any advice? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Restraints on an "if" statement | New Users to Excel | |||
| "IF" Statement Problem | Excel Worksheet Functions | |||
| "IF" Statement Problem | Excel Worksheet Functions | |||
| Need help with and "IF" statement - ASAP | Excel Discussion (Misc queries) | |||
| Can I use "In" in an "If" statement? | Excel Discussion (Misc queries) | |||
Linear Mode
