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.
You can do this ...
In Columns A and B, you can enter the following:
Cell A1 : 21 Cell B1: 3a
Cell A2 : 26 Cell B2: 3b
Cell A3: 31 Cell B3: 3c
|