SOLVED

Representing numbers as characters

Iron Contributor

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

4 Replies
best response confirmed by mathetes (Silver Contributor)
Solution

@ajl_ahmed 

That could be

=IFNA( LOOKUP(D3, $U$1:$U$6, $V$1:$V$6 ), "" )

if

image.png 

@ajl_ahmed 

For the record, I would use the solution recommended by @Sergei Baklan --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")

Many thanks ...

Many thanks ...@Sergei Baklan 

1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution

@ajl_ahmed 

That could be

=IFNA( LOOKUP(D3, $U$1:$U$6, $V$1:$V$6 ), "" )

if

image.png 

View solution in original post