IF condition Nesting limit error

[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.

 

[VBA Noob]

Try this website


http://www.j-walk.com/ss/excel/usertips/tip080.htm

You could use & option or prohaps a vlookup

VBA noob

 

[Guest]

=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

 

[vandenberg p]

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.