Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
roundtrip mileage with one name entered in A1 | New Users to Excel | |||
Mileage calculator in EXCEL | Excel Worksheet Functions | |||
Mileage Calculation | Excel Worksheet Functions | |||
mileage reimbursement formula | Excel Discussion (Misc queries) | |||
Is there a mileage grinder available? | Excel Discussion (Misc queries) |