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?

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?

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?

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?

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?