| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate the the diffrence between 2 Dates and time | Excel Worksheet Functions | |||
| Calculate X1-5 and Y? If total cost is given. | Excel Discussion (Misc queries) | |||
| Calculate call cost in seconds | Excel Worksheet Functions | |||
| How to calculate future cost of roof | Excel Worksheet Functions | |||
| Calculate time and cost | Excel Worksheet Functions | |||
Hybrid Mode
