| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to combine and's with or's in a if statement
If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error: If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2) -- Rick Rack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine if(and statement | Excel Worksheet Functions | |||
| Nesting IF's and AND's - a bit of help please... | Excel Worksheet Functions | |||
| IF's & AND's | Excel Discussion (Misc queries) | |||
| SUMPRODUCT with AND's and OR's? | Excel Worksheet Functions | |||
| long IF statement with lots of OR's | Excel Programming | |||
Threaded Mode
