Paste in an empty cpolumn and drag down. I haven't set up for checks outside
of the range of marks you specified i.e. 0 or (say) 99 so if this is a
problem re-post

=IF(A1<=7,"U",IF(A1<=11,"G","F"))

Mike

"Jane" wrote:

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,
if the cell content is between 8-11 to insert the letter G, if the cell
content is between 12-15 to insert the letter F,etc

Any ideas?