Greater than, smaller than formula
alexander_geoff wrote...
When grading children's test scores I want to apply letters and numerals
to particular ranges eg between 21 and 25=3c 26and 30=3b. Please help
with a formula.
Use the LOOKUP or VLOOKUP formula and a table, perhaps the following in
A1:B10
0 7
6 6
11 5
16 4
21 3c
26 3b
31 3a
36 2
41 1
46 0
Then with a score in cell X99, the grade would be
=LOOKUP(X99,$A$1:$B$10)
or
=VLOOKUP(X99,$A$1:$B$10,2)
|