Nested IF Has Me Nested!!!!

[Amandia]

I have to do a nested IF that regards grades. If it's between 100-90 = A, 89-80 = B, etc. and I have tried every way under the sun to make it happen and each and every time it doesn't work. Can someone please help me???


Amandia [/i]

 

[Andrew Poulsom]

It would be easier to use a lookup table. Check out VLOOKUP in Excel Help.

 

[Scott Huish]

Hi, welcome to the board!

=LOOKUP(A1,{0,"F";60,"D";70,"C";80,"B";90,"A"})

 

[gaynard_nelson]

I have to do a nested IF that regards grades. If it's between 100-90 = A, 89-80 = B, etc. and I have tried every way under the sun to make it happen and each and every time it doesn't work. Can someone please help me???


Amandia [/i]

This would work

=IF(H19>89,"A",IF(H19>79,"B",IF(H19>69,"C",IF(H19>59,"D","F"))))

 

[Amandia]

Thank you so very much!!! It worked perfectly!

Amandia