How To Compute A Percentage In Excel?

Use the formula `=part/total`

Format the result cell as Percentage

To find a percentage of a number, use `=number*percentage`

To calculate percentage increase, use `=(new-old)/old`

To calculate percentage decrease, use `=(old-new)/old`

To get a value from a percentage, use `=total*percentage`

To divide by a percentage, use `=number/percentage`

To copy the formula to other cells, drag the fill handle

Use absolute references like `$A$1` when needed

Use `=ROUND(formula,2)` to round the percentage result

Suggested for You

Trending Today