EXCEL CELL CONVERSION PROBLEM 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Thanks you so much! It worked beautifully and now I can see the logic behind
the formula. Many thanks to Mike and Toppers. I've no doubt I'll be back
with other problems!
 
Back
Top