Software

Ask something
Discussion Locked

Using Percentages

0 helpful
6 replies

by keepbelieving

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is it possible to get the increase or decrease value from other cells in the form of percents? The increase or decrease would be placed in a seperate column. example: B1 50 C1 25- what is the increase or decrease from B1 to C1 in the form of percents?

6 replies

by don christner

If you're talking in Excel, the answer is easy. In you example in cell A1 place =c1/b1 and then hit enter. It will probably display 0.5. Now highlight cell A1 and goto format-cells select the numbers tab and then select percentage. Click OK and cell A1 will display 50%.

Don

by don christner

Of course, you're probably doing more than one cell. Just format the entire column as percentage and copy the formula down the entire column.

by keepbelieving

Thank you so very much. It took quite a while for me to figure this out, but I was extremely glad to see that you answered my question and that I was on the right path.

by thechas

Do you want the percent difference?
Or the percent change?

Start by setting the numeric format for the results column to %

Percent difference c1/b1
Percent change (c1-b1)/b1

Chas

This discussion is closed to new replies.