Thread: mileage
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf
 
Posts: n/a
Default mileage

I need some help with this, I am entering odometer miles in a column
of cells and subtracting them to a different column and it keeps
entering the last odometer in the other column after it subtracts the
miles. So here is a look at what I am trying to do and maybe there is
some one that could help me thanks

odometer gal 100
93056 29 -93156
93156 0
0


Maybe the csv file below includes some ideas you can use.

------------- cut here -------------
Odometer,Gallons,Miles,mpg
1234,,,
1511,9.4,"=IF(A3="""","""",A3-A2)","=IF(A3="""","""",C3/B3)"
1777,8.2,"=IF(A4="""","""",A4-A3)","=IF(A4="""","""",C4/B4)"
2100,10.1,"=IF(A5="""","""",A5-A4)","=IF(A5="""","""",C5/B5)"
,,"=IF(A6="""","""",A6-A5)","=IF(A6="""","""",C6/B6)"
,,"=IF(A7="""","""",A7-A6)","=IF(A7="""","""",C7/B7)"
,,"=IF(A8="""","""",A8-A7)","=IF(A8="""","""",C8/B8)"
,,"=IF(A9="""","""",A9-A8)","=IF(A9="""","""",C9/B9)"
,,"=IF(A10="""","""",A10-A9)","=IF(A10="""","""",C10/B10)"