C1-B1B1 Keep the formula in the cell with Percentage format Thats all about calculating the percentage in Excel. Cell C2 contains the number 20 equal to the 02 value. The kind of formula to use in Excel depends on the desired result.
Hit Enter to get the students score as a percentage of the total possible points.
PartTotal100 Lets do this in excel. B2 1-C2 First Excel will calculate the formula 1-C2. So for example if you type 10 into cell A2 and then apply the percentage number format Excel will multiply your number by 100 to show it as a percentage remember that 1 is one part of one hundred so youll see 1000 displayed in the cell not 10. You can then use the fill handle to drag the formula down to the rest of the scores.