Jul 28 2022 10:03 AM
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
Jul 28 2022 10:38 AM
SolutionJul 28 2022 12:05 PM
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")
Jul 28 2022 10:38 AM
SolutionThat could be
=IFNA( LOOKUP(D3, $U$1:$U$6, $V$1:$V$6 ), "" )
if