Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical Testing
How many times can I use the IF AND combination ina formula, is there a
maximum? thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical Testing
In Excel 2003 you're limited to 7 levels of nesting of functions (whether IF
or other functions). In Excel 2007 this goes up from 7 to 64. -- David Biddulph "Afsha" wrote in message ... How many times can I use the IF AND combination ina formula, is there a maximum? thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical Testing
On Jun 26, 10:33 am, Afsha wrote:
How many times can I use the IF AND combination ina formula, is there a maximum? thanks! Why did you post this twice? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical Testing
because I could not see the first post for some reason - I thought the
subject might have filtered the question out??? can you see the first? "Tim Shnell" wrote: On Jun 26, 10:33 am, Afsha wrote: How many times can I use the IF AND combination ina formula, is there a maximum? thanks! Why did you post this twice? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical Testing
OK this makes sense - I am in 2003 version and have more than 7 levels of
nesting!!! many thanks Afsha "David Biddulph" wrote: In Excel 2003 you're limited to 7 levels of nesting of functions (whether IF or other functions). In Excel 2007 this goes up from 7 to 64. -- David Biddulph "Afsha" wrote in message ... How many times can I use the IF AND combination ina formula, is there a maximum? thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Testing | Excel Discussion (Misc queries) | |||
Ignore - Just testing... | Excel Discussion (Misc queries) | |||
testing | New Users to Excel | |||
Testing | Excel Discussion (Misc queries) | |||
testing | Excel Worksheet Functions |