| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
avoid embedded if statements
Hello,
Is there a quick way to do multiple if statements rather than using an embedded if statement? I have the following: If A1 = 1 then write carpet, If A1 = 2 then write couch, If A1 = 3 then write table and so on. Is there an easier way? Ellen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I avoid getting this: © in spreadsheet when I want this (c | Excel Discussion (Misc queries) | |||
| IF Statements (Mutliple Statements) | Excel Worksheet Functions | |||
| How to avoid #DIV/0 from appearing | Excel Discussion (Misc queries) | |||
| reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) | |||
| what is this, how do I avoid it? | Excel Discussion (Misc queries) | |||
Threaded Mode
