Although theres no basic percentage formula in Excel you can multiply a number by a percentage using a formula. Percentage 1 percentage 2 sample size 1 sample size 2 x 100 average percentage In this formula percentage 1 represents the decimal value of the given percentage from sample size 1. When you start typing average you will get a few options to choose.
Where the sum is the result of adding all of the given numbers and the count is the number of values being added.
For example if you have a column containing numbers and want to calculate 10 of one of those numbers enter 10 in another cell then use a formula using the asterisk as the multiplication. Below is given data for calculation of the average percentage. If we have to calculate percent of a number divide the number by whole and multiply by 100. Use your cursor to select the function and press the Tab.