Representing numbers as characters

ajl_ahmed 

For the record, I would use the solution recommended by SergeiBaklan --a table with LOOKUP gives maximum flexibility. You could add in nuances like A-, B+, etc. by extending the table to recognize variations within those ranges of ten.

But just to demonstrate the versatility of Excel, here's another formula....assuming the numeric grade is in cell D3. This formula will also deliver those desired results.

=CHOOSE(INT(D3/10),"F","F","F","F","E","D","C","B","A","A")