USES MORE LEVELS OF NESTING THAN ARE ALLOWED IN THE CURRENT FILE FORMAT

[jffryjsphbyn]

Hi,

I have a problem I am trying to execute this function but unfortunately, it doesn't work. it shows the error "USES MORE LEVELS OF NESTING THAN ARE ALLOWED IN THE CURRENT FILE FORMAT" I will use more than 15 nested IF's statements. Is it possible? Here is my partial codes/function.




=if(l2="","",if(and(F2="CR",AH2<=1,"Within SLA",if(and(F2="Reorganization",AH2<=5,"Within SLA",if(and(f2="LET",AH2<=1,"Within SLA",if(and(f2="NOT",AH2<=1,"Within SLA",if(and(al2="MMR High",ah2<=5,"Within SLA",if(and(al2="MMR Low",ah2<=2,"Within SLA")))))))))))))



Please help!

[Admin]

Hi

Try; untested.


=IF(L2="","",IF(OR(AND(AH2<=1,OR(F2={"CR","LET","NOT"})),AND(OR(F2="Reorganization",AL2="MMR High"),AH2<=5),AND(AL2="MMR Low",AH2<=2)),"Within SLA"))