| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding two if Statements together
If I have two if statement, how do I make it one. For example, I want
to add: =IF(AND(W2="Open",OR(AE2="CMRA",AE2="MRC-PARTS",AE2="IN- DIRECT",AE2="DOA",AE2="MRC-PARTS/LABOUR",AE2="REPAIR"),(TODAY()- D2)=8),"yes","no") and =IF(AND(W2="Open",OR(AE2="DIRECT",AE2="IN-DIRECT CONFIG",AE2="DIRECT TOUCH",AE2="HOSTED"),(TODAY()-D2)=22),"yes","no") together. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| if statements | Excel Worksheet Functions | |||
| Adding to IF statements | Excel Discussion (Misc queries) | |||
| Excel adding to IF statements together | Excel Discussion (Misc queries) | |||
| adding color to the results of IF statements | Excel Worksheet Functions | |||
Threaded Mode
