Forum Discussion

shahid20's avatar
shahid20
Copper Contributor
Sep 20, 2022

Compare Students Grade

How to compare this 2019-20 (table 1) 2020-21 (table 2)   A B       If 2nd table less than 1st then weak if 2nd table greater than 1st then very good if 2nd table equal to 1st tabl...
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 20, 2022

shahid20 

=IF(B3>A3,"very good",IF(B3<A3,"weak",IF(B3=A3,"average")))

You can use a simple nested IF formula. If you work with Office365 or 2021 you can apply IFS as well.

 

  • mathetes's avatar
    mathetes
    Gold Contributor
    Sep 20, 2022

    OliverScheurich 

    shahid20 

     

    Presumably, though, there are names associated with the grades too...and you want to make sure you're comparing John Doe's grades from the two years....

     

    Is it possible for you, shahid20 ,to give us the full structure of the two tables? That formula from OliverScheurich is great for the data you've shared, but I find it hard to believe it's going to be that simple, unless you've already taken care of making sure each row in each table is for the same student.

    • shahid20's avatar
      shahid20
      Copper Contributor
      Oct 15, 2022

      A*          A     Below expected

      A           A      Expected 

      C

      A*

      Above Expected

      I need help for formula to show the result (Expected, Above Expected and Below Expected) based on two grades compare

       

      mathetes OliverScheurich