G
Garry R
I'm trying to have 20 arguments in the IF function and it will only let me do
7. I thought excel 207 allowed 64. What am I doing wrong?
7. I thought excel 207 allowed 64. What am I doing wrong?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
By any chance is your file an .xlS instead of 2007 format. If so, save save
as .xlsx >close>reopen.
as .xlsx >close>reopen.
J
Jacob Skaria
Is that workbook saved in 2003; and opened in 2007. Try re-saving that in
2007 format .xlsx and reopen...
2007 format .xlsx and reopen...
F
Fred Smith
What you are doing wrong is nesting more than 7 conditions in an If
statement. You will find that this level of nesting makes the formula
virtually unmaintainable. There's always a better way, the most common
solution being Vlookup.
Regards,
Fred.
statement. You will find that this level of nesting makes the formula
virtually unmaintainable. There's always a better way, the most common
solution being Vlookup.
Regards,
Fred.
G
GINN
If I have understood your query correctly for an IF Function to have maximum
nesting , please try this:
=IF(criteria1= something ,desired value1," ")&IF(criteria 2=
something,desired value2," ").............. &IF(criteria 19= something
,desired value 19,desired value 20)
Pl try the maximum you can reach and let us know.
nesting , please try this:
=IF(criteria1= something ,desired value1," ")&IF(criteria 2=
something,desired value2," ").............. &IF(criteria 19= something
,desired value 19,desired value 20)
Pl try the maximum you can reach and let us know.