SOLVED

Contributor

# 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

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

# Re: Representing numbers as characters

That could be

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

if

# Re: Representing numbers as characters

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 ...

# Re: Representing numbers as characters

Many thanks ...@Sergei Baklan