| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF/AND/OR statments
What would be the format of the IF/AND/OR nested statement to return the
following: If R1 contains a 9 and S1 contains a 36 I want a 4 in T1 If R1 contains a 7 and S1 contains a 36 I want a 5 in T1 If R1 contains a 6 and S1 contains a 30 I want a 5 in T1 If R1 contains a 5 and S1 contains a 25 I want a 5 in T1 If R1 contains a 6.25 and S1 contains a 25 I want a 4 in T1 If R1 contains a 5 and S1 contains a 20 I want a 4 in T1 If R1 contains a 4 and S1 contains a 20 I want a 5 in T1 Many thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If then Statments | Excel Worksheet Functions | |||
| If Statments | Excel Discussion (Misc queries) | |||
| AND OR IF Statments | Excel Worksheet Functions | |||
| Multiple Vlookups & IF statments | Excel Worksheet Functions | |||
| IF statments for multiple listings. | Excel Worksheet Functions | |||
Threaded Mode
