Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2014-04-10
6
Medium Priority
?
2,454 Views
Last Modified: 2016-09-01
=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
Comment
Question by:regsamp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 1600 total points
ID: 39992322
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
 

Author Comment

by:regsamp
ID: 39992336
I will try right now and post back.
0
 
LVL 13

Assisted Solution

by:Santosh Gupta
Santosh Gupta earned 400 total points
ID: 39992350
Hi,

excel 2010 supports 64 level of nesting.

http://msdn.microsoft.com/en-us/library/ff700514%28v=office.14%29.aspx
0
Build and deliver software with DevOps

A digital transformation requires faster time to market, shorter software development lifecycles, and the ability to adapt rapidly to changing customer demands. DevOps provides the solution.

 
LVL 50

Expert Comment

by:barry houdini
ID: 39992377
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
 

Author Comment

by:regsamp
ID: 39992391
The breaking up of the formula worked. I apologize for the duplicate. I did not put the nesting error and I should have.
0
 

Expert Comment

by:blaize parayno
ID: 41779514
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

The top UI technologies you need to be aware of

An important part of the job as a front-end developer is to stay up to date and in contact with new tools, trends and workflows. That’s why you cannot miss this upcoming webinar to explore the latest trends in UI technologies!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question