Here the total number of vacations is 15 days. In most cases youll divide the smaller number by the larger number. Use shift-tab to move to the previous field.
To calculate percent of a total ie.
Now to calculate percentage of total write this Percentage formula in cell C4 and drag it down. How to calculate percentage of a number. Visualize what a percentage represents. Next lets figure out what percent of our 1100 total is 100.