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!

Try:

=LOOKUP(A1,{1,8,12,16,20,24,28,32,36},{"U","G","F" ,"E","D","C","B","A","A*"})

"Jane" wrote:

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!

"Toppers" wrote:

Try:

=LOOKUP(A1,{1,8,12,16,20,24,28,32,36},{"U","G","F" ,"E","D","C","B","A","A*"})

"Jane" wrote:

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!