SOLVED

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

Copper Contributor

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

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 ?

5 Replies

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

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,)

best response confirmed by SM258 (Copper Contributor)
Solution

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

@SM258 Please find the IF statement

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

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

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

The betweens are automatically catered for by this formula.

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

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)
1 best response

Accepted Solutions
best response confirmed by SM258 (Copper Contributor)
Solution

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

@SM258 Please find the IF statement