| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trying to avoid nested IFs
Glad to be of help.
Pete On Sep 24, 5:43*pm, Alonso wrote: thanks Pete probably that will work split in 2 in columns and get the max between those?? after all the formula gets only 1 value "Pete_UK" wrote: Excel 2003 and earlier versions will not recognise IFERROR, so you will probably have a #NAME error if you try to load the file on those versions. With regard to the nesting problem, I suggest you split your formula into smaller chunks over a few columns and then combine them using these intermediate columns. Hope this helps. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| avoid nested IFs with another function | Excel Worksheet Functions | |||
| IF isna to avoid #N/A | Excel Discussion (Misc queries) | |||
| nested if based on nested if in seperate sheet. how? | Excel Worksheet Functions | |||
| How to avoid name ref in formula? | Excel Discussion (Misc queries) | |||
| what is this, how do I avoid it? | Excel Discussion (Misc queries) | |||
Hybrid Mode
