IF condition Nesting limit error
 

Hello:

Here is an alternative to the lookup function:

=CHOOSE((AA1029)+(AA1034)+(AA1039)+(AA1044)+(A A1049)+(AA1054)+
(AA1059)+(AA1064)+(AA10=69)+(AA10=74)+(AA1079 )+(AA1089)+1,
"F","E","D-","D","C-","C","C+","B-","B","B+","A-","A","A+")

BTW, What happen to D+?


Pieter Vandenberg


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.