• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2601
  • Last Modified:

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.
0
regsamp
Asked:
regsamp
2 Solutions
 
Rgonzo1971Commented:
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 GuptaCommented:
Hi,

excel 2010 supports 64 level of nesting.

http://msdn.microsoft.com/en-us/library/ff700514%28v=office.14%29.aspx
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now