How many times can I use the IF AND combination ina formula, is there a maximum? thanks!
A Afsha Jun 26, 2007 #1 How many times can I use the IF AND combination ina formula, is there a maximum? thanks!
D David Biddulph Jun 26, 2007 #2 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.
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.
T Tim Shnell Jun 26, 2007 #3 How many times can I use the IF AND combination ina formula, is there a maximum? thanks! Click to expand... Why did you post this twice?
How many times can I use the IF AND combination ina formula, is there a maximum? thanks! Click to expand... Why did you post this twice?
A Afsha Jun 26, 2007 #4 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?
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?
A Afsha Jun 26, 2007 #5 OK this makes sense - I am in 2003 version and have more than 7 levels of nesting!!! many thanks Afsha
OK this makes sense - I am in 2003 version and have more than 7 levels of nesting!!! many thanks Afsha