Minimum 64 levels of nesting are exceeded in Excel file

ALI12345 

IF function – nested formulas and avoiding pitfalls

Instead of nesting, you could use the VLOOKUP () formula

or.. add to complete E.g. If (...) + If (...) + If (...) etc. ( have not tried it, but it should also work)

or... make a custom function out of it.

Additional Information:

Use nested functions in a formula

Video: Nested IF functions

Hope I was able to help you with this info.

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.