Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Asking in a different way for petrol sheet help
Hi, I'm trying this from another perspective. I have one fuel sheet
which has some days that dont have any use. The sheet always has a starting odometer and the user puts an ending odometer on another sheet which links back to petrol sheet. How do I get the out reading of 22564 to carry forward through E cell & F cell even though their is no use of vehicle between 1.2.07 and 12.2.07 and show zero in G(bus) and I(Total), their is never any private use. It's a generic form for other Depts. E3 is start of Month Odometer ,F3 and F4 is user finish odometer readings Formula I have in E3 is =CarryOver!$H$9 in F3 ='1'!$B$2 E4 is =$F$3 F4 ='1'!$B$2 Hope someone can help . Regards Stephen A B C D E F G H I Start End Hours Out In Bus Priv Total Date Time Time on task 1/2/07 0 0 22564 0 0 0 2/2/07 0 0 0 0 0 0 3/2/07 0 0 0 0 0 0 4/2/07 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5/2/07 0 0 0 0 0 0 6/2/07 0 0 0 0 0 0 7/2/07 0 0 0 0 0 0 8/2/07 0 0 0 0 0 0 9/2/07 0 0 0 0 0 0 10/2/07 0 0 0 0 0 0 11/2/07 0 0 0 0 0 0 12/2/07 0800 1626 8.26 22564 22565 1 1 13/2/07 0800 1626 8.26 22565 22633 68 68 14/2/07 0 0 22633 0 -22633 -22633 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Asking in a different way for petrol sheet help
I am a bit confused but it seems to me you want a running total. The
general philosophy of such formulas is: =A1+B2 Such a formula would be entered in A2. It adds the last interval value (same row, but another column) to the last value (same column, one row above). Such a formula will keep repeating the value in A1 as long as B2:Bx are 0. Does this help? Kostis Vezerides On Feb 13, 4:30 pm, "pano" wrote: Hi, I'm trying this from another perspective. I have one fuel sheet which has some days that dont have any use. The sheet always has a starting odometer and the user puts an ending odometer on another sheet which links back to petrol sheet. How do I get the out reading of 22564 to carry forward through E cell & F cell even though their is no use of vehicle between 1.2.07 and 12.2.07 and show zero in G(bus) and I(Total), their is never any private use. It's a generic form for other Depts. E3 is start of Month Odometer ,F3 and F4 is user finish odometer readings Formula I have in E3 is =CarryOver!$H$9 in F3 ='1'!$B$2 E4 is =$F$3 F4 ='1'!$B$2 Hope someone can help . Regards Stephen A B C D E F G H I Start End Hours Out In Bus Priv Total Date Time Time on task 1/2/07 0 0 22564 0 0 0 2/2/07 0 0 0 0 0 0 3/2/07 0 0 0 0 0 0 4/2/07 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5/2/07 0 0 0 0 0 0 6/2/07 0 0 0 0 0 0 7/2/07 0 0 0 0 0 0 8/2/07 0 0 0 0 0 0 9/2/07 0 0 0 0 0 0 10/2/07 0 0 0 0 0 0 11/2/07 0 0 0 0 0 0 12/2/07 0800 1626 8.26 22564 22565 1 1 13/2/07 0800 1626 8.26 22565 22633 68 68 14/2/07 0 0 22633 0 -22633 -22633 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a formula in one sheet that would read data from separate sheet automatically | Excel Discussion (Misc queries) | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
I need a daily sales sheet to pull from monthly figures sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |