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

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

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