I typed this out before I learned there is a max of 7 nested If statements.
Can some one provide some guidance how to work around this?
Many thanks in advance.
=IF(Z3>=X3,B3,IF(AA3>=X3,C3, IF(AB3>=X3, D3, IF(AC3>=X3, E3, IF(AD3>=X3, F3, if(ae3>=X3, G3, if(af3>=X3, H3, if(ag3>=X3, I3, if(ah3>=x3, J3, if(ai3>=x3, K3, if(aj3>=x3, l3, if(ak3>=x3,M3, if(al3>=x3, n3, if(am3>=x3, 03, if(an3>=x3, p3, if(ao3>=x3, q3, if(ap3>=x3, r3, if(aq3>=x3, s3, if(ar3>=X3, t3, if(as3>=x3, u3 ))))))))))))))))))))
Last edited by hanhj; 08-21-2011 at 12:37 PM.
The limit applies to pre-2007 versions of Excel, your profile states 2007.
Doyou need this to work with 2003 and earlier?
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
Thanks for the response.
You are correct, believe Excel 2007 allows for 64.
I am using Excel 2007, however it warned that I the nested IF statement was too long.
I have attached a workbook for reference.
I know you can use that many in Excel 2007, but how on earth would you work with 64 Nested Ifs, or even need that many.
Where is this formula in the example?
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
It begins in cell V3.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks