maths help

Discussion in 'Excel' started by build, May 1, 2011.

  1. build

    build

    Joined:
    May 1, 2011
    Messages:
    1
    Likes Received:
    0
    Hi
    Hope this is the right place for this, sorry if not and could you point me to the right place if not


    This is my problem

    I have two people sharing the running cost of caravan one person will use the caravan a lot more
    than the other.

    I'm trying to work out how to get at the cost for each person.


    The total running cost of the caravan From March to October is £2200.00

    The season runs from March to October

    Names of people are


    Fred
    Tom


    Fred will use the caravan 30 days a year


    Tom will use it 8 days a year


    These could be more or less days

    The rest of the time would be empty.

    So Fred would have to pay more of the total cost than Tom

    Hope some one can help a dum blonde


    Thank you

    Jane



    Reply With Quote
     
    build, May 1, 2011
    #1
    1. Advertisements

  2. build

    bookerk2

    Joined:
    May 4, 2011
    Messages:
    2
    Likes Received:
    0
    Couple of solutions to your problem

    I am assuming that you want a formula and/or action to calculate days divided by the cost of the car. So you could use a simple function that says:
    =2200.00/C2 (THIS IS WHERE I STARTED WHEN I TESTED IT)
    and it should look like this when you use auto fill in your total box. Does this help?
    EMPLOYEE DAYS USED TOTAL DUE
    steve 4 550
    dave 10 220
    paul 3 733.3333333
     
    bookerk2, May 4, 2011
    #2
    1. Advertisements

  3. build

    XLPadawan

    Joined:
    Jun 9, 2016
    Messages:
    32
    Likes Received:
    5
    Location:
    Allen, TX
    Being a math guy first (Excel is my secondary skill), I have just the thing you need:

    Total cost of van divided by total user-days = 2200.00 / 38 = 57.89
    Multiply each rider's days by 57.89:
    Fred: 30 x 57.89
    Tom: 8 x 57.89

    Maybe I'm the one who's in the wrong place, or maybe I just like dumb blondes.
     
    XLPadawan, Jun 16, 2016
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. bookerk2

    help with conditional formatting

    bookerk2, May 4, 2011, in forum: Excel
    Replies:
    1
    Views:
    749
    XLPadawan
    Jun 16, 2016
  2. jsduiahd
    Replies:
    0
    Views:
    628
    jsduiahd
    Jul 26, 2011
  3. Nago
    Replies:
    0
    Views:
    574
  4. Catw0327

    Timebase help!!!

    Catw0327, Apr 10, 2012, in forum: Excel
    Replies:
    1
    Views:
    777
    XLPadawan
    Jun 16, 2016
  5. Mark

    Help Fill Series

    Mark, Apr 4, 2013, in forum: Excel
    Replies:
    1
    Views:
    1,173
    XLPadawan
    Jun 16, 2016
  6. caziscarol

    Excel help recording hours

    caziscarol, Oct 27, 2013, in forum: Excel
    Replies:
    1
    Views:
    554
    chimpytech
    Apr 12, 2014
  7. Peter Kaufmann

    Lookup Function Help

    Peter Kaufmann, Nov 8, 2014, in forum: Excel
    Replies:
    1
    Views:
    390
    Peter Kaufmann
    Nov 13, 2014
Loading...