How do I do a percentage formula in Excel?

Answer 1

To find the percentage of the value in one cell compared to value in another cell (let's say A1 & B1), format the cell where you want the solution to appear by clicking the % button on the Home tab. Then use the following formula:

=B1/A1

The result will show B1 as a percentage of A1

=A1/B1 gives you A1 as a percentage of B1

If your objective is to find the percentage change between the values in the two cells, your formula would be

=(B1/A1)-1

This achieves the same result as ((B1-A1)/A1)*100, which shows the percentage change when the values have moved from A1 to B1. If your objective is to find the percentage change when values move from B1 to A1, use:

=(A1/B1)-1, which is the same as ((A1-B1)/B1)*100

Test the above with some real numbers to see what happens. Remember to make sure that the cell where you insert the formula is formatted to show percentages (see above).

Answer 2

First enter a decimal amount in a cell as seen in cell C1 to the right::

Then click any of the cells. Then click the Home tab in the number group and click the Percentage symbol as seen here : Now it says 77% in the image here: