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

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
<john14310@discussions.microsoft.com> 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)"