Calculate Price Increase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns of data. I want to calculate how much the price increased in a percent. I can't figure out how to do this. For example, the price was 2.50. It went up to 2.75. By what percent did it increase? Is there a formula for function for this?
 
Assuming you have in A1: 2.5, in B1: 2.75

Put in C1: =(B1-A1)/A1

Format C1 as percentage

C1 will return the percentage increase of B1 over A1

Copy C1 down col C
to calculate corresponding percentage increases
for the other prices listed down in cols A and B
(i.e. in A2 & B2, A3 & B3, A4 & B4, etc)

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
rw30 said:
I have two columns of data. I want to calculate how much the price
Click to expand...
increased in a percent. I can't figure out how to do this. For example,
the price was 2.50. It went up to 2.75. By what percent did it increase?
Is there a formula for function for this?
 
=A1/B1-1,

format as percentage

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

rw30 said:
I have two columns of data. I want to calculate how much the price
Click to expand...
increased in a percent. I can't figure out how to do this. For example,
the price was 2.50. It went up to 2.75. By what percent did it increase?
Is there a formula for function for this?
 
Back
Top