+ Reply to Thread
Results 1 to 7 of 7

auto fill in a formula series

  1. #1
    Registered User
    Join Date
    03-17-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    auto fill in a formula series

    sample fuel.xlsx
    i would like to have an excel file that calculates my car's <litres/100km> and <average litre per 100km>. i have been keying in the formula manually.
    1. are the formulas correct
    2. is there a way to fill in the formula automatically using fill series or something like that?
    3. i dont have the data for <litres filled> in E2 which screws up my numbers. what can i do to overcome that?
    thanks

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: auto fill in a formula series

    Hi and welcome to the forum

    Try these, copied down....
    D3=IF(C3="","",C3-C2)
    F3=IF(D3="","",E3*100/D3)
    G3=IF(C3="","",SUM($E$2:E3)/SUM($D$2:D3)*100)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    03-17-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: auto fill in a formula series

    sorry but which formulas go into cells F2 and G2?

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: auto fill in a formula series

    The answer you have in D2 does not make sense, but you can leave it as is
    the F3 and G3 you can copy up

  5. #5
    Registered User
    Join Date
    03-17-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: auto fill in a formula series

    sorry i didnt explain at the start... when i got the car it had already had some kms done on the odometer. thats why D2 is strange. also i didnt record "litres filled" for the 1st time which was a mistake on my part. here is an updated file with what i estimate those cells should be.
    sample fuel2.xlsx
    please note columns A,B,C,D and E are data, not calculations. each time i fill at the pump, i key in the "date", "odometer" reading, the trip meter which tells me the "km travelled" since the last fill, and the "litres filled" into the tank. from that data, i want to calculate column F and G

  6. #6
    Registered User
    Join Date
    03-17-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: auto fill in a formula series

    aah now i get it! thanks a million FDibbins!!

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,116

    Re: auto fill in a formula series

    Happy to help and thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to use auto-fill to have a sequential series of quarters?
    By GIS2013 in forum Excel General
    Replies: 7
    Last Post: 07-18-2013, 04:07 AM
  2. auto fill series number formula
    By corescript in forum Excel General
    Replies: 2
    Last Post: 09-23-2012, 05:57 AM
  3. Auto fill series option as default?
    By Medivac in forum Excel General
    Replies: 3
    Last Post: 01-09-2012, 03:50 PM
  4. Auto Fill Series issue...
    By e3donald in forum Excel General
    Replies: 3
    Last Post: 04-26-2006, 03:15 PM
  5. [SOLVED] auto fill series
    By Dave in forum Excel General
    Replies: 2
    Last Post: 01-19-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1