In the example below Actual PointsPossible Points Grade. On the Home tab in the Number group click the. Enter all the numbers you want to increase or decrease in some column column B in this example.
If you want to calculate a percentage of a number in Excel simply multiply the percentage value by the number that you want the percentage of.
This formula divides the value in cell A1 by the value in cell B1. Change new value-old value. Percentage of Days spent in USA 5 15 100 3333. Percentage of Total 1.