Net change and percentage of change

G

Guest

Hi,

I have a list of parts that have had price increases. One column has the old
price the other has the new price. I need to show the difference, whether it
is positive or negative and the percentage of the increase or decrease. The
difference is not a problem. The problem lies in calculating the percentage.
I don't how to do that. Can someone tell me?

Thanks,
Richard
 
G

Guest

Some thoughts ..

I'd usually calc percentage increases/decreases based on the old prices

Assuming old prices in A2 down, new prices in B2 down
Place in C2: =(B2-A2)/A2
Format C2 as percentage to taste.
Copy C2 down as far as required.

---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Percentage Increase 13
percentage in brackets 2
Try to find the difference by percentage between 2 cell totals 1
Calculating difference of two values as a percentage 2
IF FORMULA HELP 5
difference in numbers displayed as a +/- percentage 3
Percentage Change 2
Access Negative Percentages in Report in Access 2007 0

Top