| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF STATEMENT HELP
=IF(AND(O18="L TO R",Q18="Right hand"),"5500-402-02",IF(AND(O18="R TO
L",Q18="right hand"),"5500-401-02")) -- HTH Kassie Replace xxx with hotmail "dendh" wrote: I am trying to write if statement and havent been able to get all to work, ex: =IF(and(O18="L TO R",q18=Right hand")),"5500-402-02",IF(and(O18="R TO L",q18="right hand")),"5500-401-02" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| 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 and Isblank statement | Excel Worksheet Functions | |||
Hybrid Mode
