You need to use this formula to calculate the average GPA in Excel: =<cell with sum of grade values>/<total number of subjects>. Then, you can use VLOOKUP to enter the grades.

Added by Microsoft in 2016, the IFS function replaces the need for multiple nested IF statements. You can put all your conditions (percentage grade cutoffs in this example) in one function, making it ...

Learn how to calculate simple, weighted and exponential moving averages in Microsoft Excel using Data Analysis Tool Pack or Formula.