Link to home
Start Free TrialLog in
Avatar of regsamp
regsamp

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of regsamp
regsamp

ASKER

I will try right now and post back.
SOLUTION
Avatar of Santosh Gupta
Santosh Gupta
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
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
Avatar of regsamp
regsamp

ASKER

The breaking up of the formula worked. I apologize for the duplicate. I did not put the nesting error and I should have.
Avatar of blaize parayno
blaize parayno
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....