forming an IF statement function

Writing a single nested IF statement function to calculate the grades of the students the following rules:

If the student grade is His/her letter grade is
Greater or equal to 90: A
Greater or equal to 80 and less then 90: B
Greater or equal to 70 and less then 80: C
Greater or equal to 60 and less then 70: D
Any other grade: F

thanks

Rather than use embedded Ifs you will be better off using a LOOKUP, eg

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

Where A1 holds grade.

Maybe

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

VBA Noob

If we're adding safety clauses with given LOOKUP better to check value is both numeric and > 0, no ?

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

If using XL07 you could just use

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

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save