IF condition Nesting limit error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(AA10>89,"A+", IF(AA10>79,"A", IF(AA10>74,"A-", IF(AA10>69,"B+",
IF(AA10>64,"B", IF(AA10>59,"B-", IF(AA10>54,"C+", IF(AA10>49,"C",
IF(AA10>44,"C-", IF(AA10>39,"D", IF(AA10>34,"D-", IF(AA10>29,"E",F))))))))))))

Any suggestions ?

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

Vaya con Dios,
Chuck, CABGx3
 
Hello:

Here is an alternative to the lookup function:

=CHOOSE((AA10>29)+(AA10>34)+(AA10>39)+(AA10>44)+(AA10>49)+(AA10>54)+
(AA10>59)+(AA10>64)+(AA10>=69)+(AA10>=74)+(AA10>79)+(AA10>89)+1,
"F","E","D-","D","C-","C","C+","B-","B","B+","A-","A","A+")

BTW, What happen to D+?


Pieter Vandenberg


: 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(AA10>89,"A+", IF(AA10>79,"A", IF(AA10>74,"A-", IF(AA10>69,"B+",
: IF(AA10>64,"B", IF(AA10>59,"B-", IF(AA10>54,"C+", IF(AA10>49,"C",
: IF(AA10>44,"C-", IF(AA10>39,"D", IF(AA10>34,"D-", IF(AA10>29,"E",F))))))))))))

: Any suggestions ?

: Thanks in advance.
 
Back
Top