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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

mileage
 

Show us the formulas you are using.

Into which column are you entering the odometer readings

Which column has your formula for subtracting?


Gord Dibben MS Excel MVP

On Wed, 7 Jun 2006 16:04:01 -0700, john14310
wrote:

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
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

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)"