| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting of more than 7 in an IF formula
Thanks for feeding back, Rachael.
Note that my formula will return a zero if A1 does not contain one of the listed names. Also, the IFs themselves are not nested, so you do not suffer from the limit. Pete On May 16, 9:33*am, Rachael F wrote: Thanks very much for all the replies. I have used Pete's formula. Best wishes. Rachael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you help nesting a formula? | Excel Worksheet Functions | |||
| NESTING FORMULA | Excel Worksheet Functions | |||
| Nesting Formula | Excel Discussion (Misc queries) | |||
| Formula nesting | Excel Worksheet Functions | |||
| nesting another formula | Excel Worksheet Functions | |||
Threaded Mode
