calculate the diffrence in cost

[Calculate difference in price]

Im setting a simple spreadsheet to calculate the differenct in local gas
prices day by day. The formula i need is to figure the price difference from
day 1 to day 2 and so on. Sometimes it will subtract and sometimes it will
add to calculate the difference. Anyone have any help with this.
Thanks

 

[Don Guillett]

Have a look in the help index for ABS

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
"Calculate difference in price" <Calculate difference in
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Jacob Skaria]

Do you mean the difference with previous day..In colC cell C3 enter the below
formula and copy down as required.

=B3-B2

Col A Col B Col C
Date Rate Difference
10/18/2009 100
10/19/2009 101 1
10/20/2009 102 1
10/21/2009 100 -2



If this post helps click Yes

 

[Rich/rerat]

Calculate,
Here is a link to a work book for up to ten (10) stations that you can
compare for a month.

http://tinyurl.com/fuel-price-comparisons


--
Add MS to your News Reader: news://msnews.microsoft.com
Rich/rerat
(RRR News) <message rule>
<<Previous Text Snipped to Save Bandwidth When Appropriate>>


"Calculate difference in price" <Calculate difference in
(e-mail address removed)> wrote in message
Im setting a simple spreadsheet to calculate the differenct in local gas
prices day by day. The formula i need is to figure the price difference from
day 1 to day 2 and so on. Sometimes it will subtract and sometimes it will
add to calculate the difference. Anyone have any help with this.
Thanks