View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane Jane is offline
external usenet poster
 
Posts: 202
Default EXCEL CELL CONVERSION PROBLEM 2

Thanks Mike, almost there!

To convert numbers into GCSE grades I need to use a formula that will read
down a column and if the cell content is

between 1-7 to insert the letter U,
between 8-11 to insert the letter G,
between 12-15 to insert the letter F,
between 16-19 to insert the letter E
between 20-23 to insert the letter D
between 24-27 to insert the letter C
between 28-31 to insert the letter B
between 32-35 to insert the letter A
between 36-40 to insert the letter A*

Hope you can help. And many thanks in advance. I know you can do it!