Greater than, smaller than formula
Alexander
=LOOKUP(A1,{0,21,26,31,36},{"fail","3c","3b","3a", "star"})
Adjust to suit more ranges if desired.
Gord Dibben Excel MVP
On Wed, 21 Dec 2005 11:50:49 -0600, alexander_geoff
<alexander_geoff.20eitn_1135187737.0985@excelfor um-nospam.com 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.
|