Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CherylR CherylR is offline
external usenet poster
 
Posts: 2
Default Formula Help

I am trying to convert a number within a range to a grade and I would be
grateful for some help as I'm not sure what formula to use:

<50 = U
50-59 = D
60-69 = C
70-79 = B
80-89 = A
90-100 = A*

Many thanks,

Cheryl