Calculate a percent distribution you can use a formula that simply divides an amount by the total. Then type the following formula. This formula divides the value in cell A1 by the value in cell B1.
Enter the formula shown below.
Hit Enter to get the students score as a percentage of the total possible points. Click the insert function button fx under formula toolbar the dialog box will appear Type the keyword PERCENTILE in the search for a function box PERCENTILE function will appear in select a function box. Summary To calculate percent of a total ie. To Excel the percent symbol is just formatting.