Percentage formulas
Percent of total, percent change, adding and removing a percentage, and margins. 6 answers, each checked by running it, with a live example and an exercise.
How to calculate percentage change between two numbers in Excel
=(C2-B2)/B2Subtract the old value from the new one and divide by the old: =(C2-B2)/B2, formatted as a percentage.
How to calculate the percentage of a total in Excel
=B2/SUM($B$2:$B$7)Divide each value by the total, with the total locked: =B2/SUM($B$2:$B$7), or =B2/$B$8 if the total is in a cell.
How to add a percentage to a number in Excel
=B2*(1+$F$1)Multiply by 1 plus the percentage: =B2*(1+$E$1). To increase by 8%, multiply by 1.08.
How to subtract a percentage from a number in Excel
=B2*(1-$F$1)Multiply by 1 minus the percentage: =B2*(1-$F$1). A 15% discount is 85% of the price.
How to calculate what percentage one number is of another in Excel
=B2/C2Divide the part by the whole: =B2/C2, and format the result as a percentage.
How to calculate profit margin percentage in Excel
=(B2-C2)/B2Divide profit by revenue: =(B2-C2)/B2, where B is the price or revenue and C the cost.