Representing numbers as characters

[ahmadjumaa80]

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

[ranman256]

why would you use them as strings? they are numbers and can be used in math.

youd have a table like you showed:
grade, LowEnd, HiEnd
A, 90, 100
B, 80, 89
...etc

then run the score against the table to get the grade.

[oeldere]

With VLookup

D12=VLookup(D3,$C$21:$D$26,2,1) and drag across.

See the attached file.

[ahmadjumaa80]

Thanks for your reply
What "1" means in the formula? I know should be true or false?
=VLOOKUP(D3,$C$21:$D$26,2,1)

[oeldere]

0=True
1=False

[HansDouwe]

It's the other way around
0 = FALSE (exact match)
1 = TRUE (approximate match)

[ahmadjumaa80]

Many thanks all.