Using nesting in the 64 IF function in Excel 2007

[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?

 

[Don Guillett]

By any chance is your file an .xlS instead of 2007 format. If so, save save
as .xlsx >close>reopen.

 

[Jacob Skaria]

Is that workbook saved in 2003; and opened in 2007. Try re-saving that in
2007 format .xlsx and reopen...

 

[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.

 

[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.