The specified formula can not be entered because it uses more than 64 levels of nesting.

[Islam Mamdouh Ali]

Dears Group Members,

I have very long excel (IF) Formula with 292 criteria, a message appear tells me that:

(" The specified formula can not be entered because it uses more than 64 levels of nesting").

I ask for your prompt advice/reply in order to overcome the above mentioned error message.

Thanks for your kind cooperation.

 

[Joe4]

Depending on exactly what your criteria are, you may be able to create a LOOKUP table and use a VLOOKUP formula instead.
See: https://www.techonthenet.com/excel/formulas/vlookup.php