The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format.

=IF(F5=AR5," ",IF(F5=AS5,AT5,IF(F5=AW5,AX5,IF(F5=BA5,BB5,IF(F5=BE5,BF5,IF(F5=BI5,BJ5,IF(F5=BM5,BN5,IF(F5=BQ5,BR5))))))))

Trying to add to the formula but getting the nesting message.
regsampAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

pls try
=IF(F5=AR5," ",IF(F5=AS5,AT5,"")&IF(F5=AW5,AX5,"")&IF(F5=BA5,BB5,"")&IF(F5=BE5,BF5,"")&IF(F5=BI5,BJ5,"")&IF(F5=BM5,BN5,"")&IF(F5=BQ5,BR5,""))

Open in new window

Regards
0
 
regsampAuthor Commented:
I will try right now and post back.
0
 
Santosh GuptaConnect With a Mentor Commented:
Hi,

excel 2010 supports 64 level of nesting.

http://msdn.microsoft.com/en-us/library/ff700514%28v=office.14%29.aspx
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
barry houdiniCommented:
This appears to be a duplicate

It would help if you give some more information:

What sort of value is in F5 (is it a number)
Can F5 match more than one value in the row?
What's in the intermediate cells like AU5 and AV5?

regards, barry
0
 
regsampAuthor Commented:
The breaking up of the formula worked. I apologize for the duplicate. I did not put the nesting error and I should have.
0
 
blaize paraynoCommented:
hi can someone help me how to convert this formula in MS excel?
=IF(H9>=96,1,IF(H9>=91,1.25,IF(H9>=86,1.5,IF(H9>=81,1.75,IF(H9>=75,2,IF(H9>=69,2.25,IF(H9>=63,2.5,IF(H9>=57,2.75,IF(H9>=50,3,5)))))))))

thanks....
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.