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

Ask a Question

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.