General discussion

Locked

Using Percentages

By keepbelieving ·
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?

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Using Percentages

by Don Christner In reply to Using Percentages

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

Collapse -

Using Percentages

by Don Christner In reply to Using Percentages

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.

Collapse -

Using Percentages

by keepbelieving In reply to Using Percentages

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.

Collapse -

Using Percentages

by TheChas In reply to Using Percentages

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

Collapse -

Using Percentages

by keepbelieving In reply to Using Percentages

Thank you so very much for your help. It was really useful.

Collapse -

Using Percentages

by keepbelieving In reply to Using Percentages

This question was closed by the author

Back to Software Forum
6 total posts (Page 1 of 1)  

Related Discussions

Software Forums