Using nesting in the 64 IF function in Excel 2007
 

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?

Using nesting in the 64 IF function in Excel 2007
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Garry R" <garryr*yahoo.com wrote in message
...
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?

Using nesting in the 64 IF function in Excel 2007
 

Is that workbook saved in 2003; and opened in 2007. Try re-saving that in
2007 format .xlsx and reopen...
--
If this post helps click Yes
---------------
Jacob Skaria


"Garry R" wrote:

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?

Using nesting in the 64 IF function in Excel 2007
 

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.

"Garry R" <garryr*yahoo.com wrote in message
...
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?

Using nesting in the 64 IF function in Excel 2007
 

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.

"Garry R" wrote:

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?