students marks to grades (using if and logical operation)

[lezawang]

Hi
What is the best way to convert numbers to grades. For example

0 to 50 is F
50 - 60 is C
60 - 70 is B
70 - 80 is A
80 - 100 is A+

What is the best way or formula to do so. I was thinking of If() with logical operations like AND, OR etc

Any idea would be very much appreciated. Thanks

 

[Rick Rothstein]

What is the best way to convert numbers to grades. For example

0 to 50 is F
50 - 60 is C
60 - 70 is B
70 - 80 is A
80 - 100 is A+

Can you clarify which grades 50, 60, 70 and 80 belong to (you have them listed for two grades each)?

 

[lezawang]

Thanks for you reply. Yes I think I should not include them in 2 different ranges. thank you.

0 to 49 is F
50 - 59 is C
60 - 69 is B
70 - 79 is A
80 - 100 is A+

 

[Scott T]

Where A1 has the number

=VLOOKUP(A1,{0,"F";50,"C";60,"B";70,"A";80,"A+"},2)

 

[Rick Rothstein]

Here is another formula you can try...

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