IF condition Nesting limit error
 

=LOOKUP(AA10,{0,30,35,40,45,50,55,60,65,70,75,80,9 0},{"F","E","D-","D","C-","C","C+","B-","B","B+","A-","A","A+"})

Vaya con Dios,
Chuck, CABGx3



"PKadam" wrote:

Hi All,

I am trying to use the formula to calculate the grades, but i am getting an
error for exceeding the Nested limits.

My formula looks like this

=IF(AA1089,"A+", IF(AA1079,"A", IF(AA1074,"A-", IF(AA1069,"B+",
IF(AA1064,"B", IF(AA1059,"B-", IF(AA1054,"C+", IF(AA1049,"C",
IF(AA1044,"C-", IF(AA1039,"D", IF(AA1034,"D-", IF(AA1029,"E",F))))))))))))

Any suggestions ?

Thanks in advance.