Forum Discussion
SM258
Oct 31, 2023Copper 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 ?
SM258 Please find the IF statement
- Vinod2406Brass Contributor
- JKPieterseSilver Contributor
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,)
- Vinod2406Brass ContributorTo help people who Search you can click on Mark as solution at the bottom of the post (the one with the solution you adopted)
- SM258Copper ContributorDon't really understand how to use the formula ... nor how to make the small table correspond with the betweens i'm aiming at
- JKPieterseSilver ContributorThe betweens are automatically catered for by this formula.