Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

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

Copper Contributor

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

@SM258 

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

 AB
14a
25b
38c
411d
514e

 

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

@SM258 Please find the IF statement 

Don't really understand how to use the formula ... nor how to make the small table correspond with the betweens i'm aiming at
The betweens are automatically catered for by this formula.
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)