# maths help

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

1. ### build

Joined:
May 1, 2011
Messages:
1
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

build, May 1, 2011

2. ### bookerk2

Joined:
May 4, 2011
Messages:
2
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

Joined:
Jun 9, 2016
Messages:
32
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.