View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default 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.