Forum Discussion

SM258's avatar
SM258
Copper Contributor
Oct 31, 2023

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 ? 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor

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

     

    • Vinod2406's avatar
      Vinod2406
      Brass Contributor
      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)
    • SM258's avatar
      SM258
      Copper Contributor
      Don't really understand how to use the formula ... nor how to make the small table correspond with the betweens i'm aiming at
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        The betweens are automatically catered for by this formula.

Resources