| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Restraints on an "if" statement
Something like this in say, C1:
=IF(A1="","",IF(MAX(A1,0)B1,"C","D")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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 | |||
| Nested "IF" Statement | 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) | |||
| "If" statement using "And" | Excel Discussion (Misc queries) | |||
Linear Mode
