How can we calculate the grades A-F in Excel if we have the test results as numbers. So for each cell in the Total column we will enter SUMGrade Cell Weight Cell so my first formula is SUM B2C2 the next one would be SUM B3C3 and so on. 0 59 F 60 69 D 70 79 C 80 89 B 90 100 A.
The output of any formula or function can be fed directly into another formula or function.
The first thing we should do is to organize this information in a lookup table. To get the letter grade based on score values the nested IF function in Excel can help you to solve this task. VLOOKUP E5 key 2 TRUE. The table below shows the standard math operators available in Excel.