| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel If function alternative
hello
In my spreadsheet, I've been using a nested if function, but now I need to expand it to 12 if statements and since there is a max of 8, basically my formula is this If a1=1, z1, if a1=2, z2, if a1=3, z3 and so on. What other function can I use to do this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
| Is there a Timestamp function that does not update in Excel? | Excel Worksheet Functions | |||
| Return value with using Excel function | New Users to Excel | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
