| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function with multiple return values
I currently have the following for a formula:
=IF(AN9<7,AM16,IF(AN9<10,AM17,IF(AN9<13,AM18,IF(AN 9<15,AM19,IF(AN914,"Manager Appr"))))) I have seen and used a less intense one where all of the IFs are in the first set of brackets and all of the results are in the second set. I cannot find the same formula and cannot make it work on my own. =IF(7,10,13,15,???) (results set) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return multiple same values | Excel Discussion (Misc queries) | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Multiple conditions and multiple return values | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| How to look up and return multiple values | Excel Worksheet Functions | |||
Threaded Mode
