View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stressed School Teacher Stressed School Teacher is offline
external usenet poster
 
Posts: 1
Default school grades in a spreadsheet.

Hi i'm wondering if someone could help me out or tell me that what i'm asking
is impossible.

I want to type a number in one cell and have a corresponding letter appear
simultaneously in another cell. For example if I type in "89"in one cell I
would want the letter "B"to appear in another cell. There are different
ranges for each letter so from 0-60 would be "E", 61-70 would be "D", 71-80
would be "C", 81-90 would be "B" and 91-100 would be "A".

I really don't know where to start with this one so any help would be
greatly appreciated.

Thanks in advance.

Adrian