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!
|