How do I get around the maximum nesting functions in Excel 365?

Hi George and welcome to the forum,

Nested Ifs are normally resolved by using a VLookup() with a True as the 4th argument. The data needs to be sorted from small to large to have it work correctly. I'm not sure I understand your table but let me look for an example. Watch the second example of https://www.bing.com/videos/search?q...CA00&FORM=VIRE

have you thought about setting up a couple tables and using a vlookup and true statement?
something like =IF(AND(E5>=30,E5<=50),IFERROR(VLOOKUP(G5,L2:M12,2,TRUE),IFERROR(VLOOKUP(G5,O2:P25,2,TRUE),">10%")),"")
So in L2:M12 I put in your limits for the <5% and in O2:P25 I put in your upper limits for the 5-10% though I would think even these value ranges could be pared down too. A sample might be helpful with what you expect if values are outside of the ranges.
Just a thought.

I would suggest that, instead of uploading a PDF detailing the MUST system, you upload a sample excel workbook, showing what you have - and what you expect.

Hey Dave,

I agree the workbook would be fun, I'd like to try to find the formula for those curves in his PDF chart. That would remind me of my old college days. If we had formulas for all the lines we could tell which color it was in using formulas instead of some artists sweeping colors across a huge chart. I do think I'd flip his chart to make smaller numbers at the top. That way VLookup() True would work better.

Perhaps this will help.
The formula is related to a table in DR5:DU25
The formula, as modeled in DL5:DL8, is:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.