After a writing exam, i would like to put on a formula that helps me grade with letters

[SM258]

Hello Everyone ! 

I need help using the if formula on excel. What i need to do, is if the student made less than 4, it's A. Between 5 and 7 B. Between 8 and 10, C. Between 11 and 13 D and lastly, equals or more to 14 E. The formula i tried works with A and E, but not all the rest. I have tried many variations with no luck... Any help ? 

[#2]

@SM258 

Place your limits in a small table, for instance like this:

	A	B
1	4	a
2	5	b
3	8	c
4	11	d
5	14	e

Suppose your grade is in cell C1, then this formula gets the letter belonging to that grade:

=XLOOKUP(C1,$A$1:$A$5,$B$1:$B$5,"NA",1,)

[#3 · Accepted solution]

@SM258 Please find the IF statement 

[#4]

Don't really understand how to use the formula ... nor how to make the small table correspond with the betweens i'm aiming at

[#5]

The betweens are automatically catered for by this formula.

[#6]

To help people who Search you can click on Mark as solution at the bottom of the post (the one with the solution you adopted)