I am in the process of a pretty ugly formula right now that requires me to show 11 different "IF" scenarios but I cannot seem to go over 8. I get the following error message:
"The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format"
Anything I can do to work around this?
Hi,
Usually when you find yourself nesting anything more than half a dozen IF statements you should consider other options. Often a VLOOKUP table will work or failing that a well structured macro.
Post your workbook with details of what you want to achieve if you want more specific advice.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
So essentialy the rates that I need referenced are on the worksheet "Age Bands" and I need those rates to pull into the "census data" according to each indivdual person's appropriate age category in column "I"
Thanks in advance for your help!
Hi
1st, change the table on sheet1 so that it starts at 0, 25, 30 etc (the lower end of the scale), and ends in 100
and then use this, copied down in sheet2 I2 (I used K2 so I could compare)...
=VLOOKUP(H2,'Age Bands'!$A$2:$B$12,2,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Something like this:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi,
See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks