Forum Discussion

ajl_ahmed's avatar
ajl_ahmed
Iron Contributor
Jul 28, 2022
Solved

Representing numbers as characters

Representing numbers as characters

I have students' marks for 14 subjects (D1-Q1), what is the best method, and how can represent these marks as characters such that if the degree:

A 90-100

B 80-89

C 70-79

D 60-69

E 50-59

F <50

Thanks

excel
Formulas and Functions
office 365
  • mathetes's avatar
    mathetes
    Silver Contributor
    Jul 28, 2022

    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")

Resources