I have a spreadsheet that I'm using to calculate my exam results, and consequently my grade average.

My current average (calculated from input date of paper marks) is located in cell F14. This average is displayed at a percentage, e.g. 67%.

IF F14 falls between 40 - 49%, then degree = "3rd"
IF F14 falls between 50 - 59%, then degree = "2.ii"
60 - 69% = 2.i
70 - 100% = 1st


I need to check which category the number in cell F14 falls into (i.e. 2.ii or 1st etc) in order to work out what class of degree I can get.

Any tips on how to use the IF function, or what else I should be using?