| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine or if
I need to check for three (or more conditions) and need a different value
returned for each criteria. For example: DATA Wanted result: 1 Single 2 Dual 4 Quad My mistake lies in formatting of the formula: If(A1=1, "Single")or if(A1=2, "Dual") or if (A1=4, "Quad") -aimes |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine........ | Excel Discussion (Misc queries) | |||
| How Can i combine | Excel Discussion (Misc queries) | |||
| Combine into one please | Excel Worksheet Functions | |||
| How do I combine IF and OR? | Excel Worksheet Functions | |||
| Combine into one please. | Excel Worksheet Functions | |||
Threaded Mode
