|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 18th, 2009, 04:13 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate the diffrence in cost
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 
|
|
#2
October 18th, 2009, 05:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate the diffrence in cost
Have a look in the help index for ABS -- Don Guillett Microsoft MVP Excel SalesAid Software "Calculate difference in price" Calculate difference in 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
|
|
#3
October 18th, 2009, 05:58 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate the diffrence in cost
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 --------------- Jacob Skaria "Calculate difference in price" wrote: 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
|
|
#4
October 18th, 2009, 06:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate the diffrence in cost
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 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
