This process is the reverse of what you did earlier. 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. On the Home tab in the Number group click the percentage symbol to apply a Percentage format.
Assuming that the total value is in cell A2 and percent in B2 the above formula turns into a simple A2B2 and returns 10450.
Find Percentage of a Number Partwhole 100 final outcome 210100 20 Remaining items 100-20 80. For this example the formula you would use is A1 1-B1. Then type the following formula. Summary To calculate percent of a total ie.