In the example shown the formula in D6 is. Calculate a percent distribution you can use a formula that simply divides an amount by the total. Then type the following formula.
The result is formatted with Percentage number format to show 25 10 etc.
Calculate a percent distribution you can use a formula that simply divides an amount by the total. Simply select the cells to format and then click the Percent Style button in the Number group on the ribbons Home tab. For example if you want to calculate 20 of 500 multiply 20 by 500. Before writing any formulas its helpful to know that Excel is flexible enough to calculate the same way whether you type percentages with a percent sign like 20 or as a decimal like 02 or just 2.