Help with a quick formula please

Haggisman · 10 Oct 2007 at 22:57

Hey guys, need help with a formula i want to throw in an Excel spreadsheet,

Basically I want an equation which will take the total of our monthly outgoings (e.g. bills/rent etc) and calculate how much my gf and me should pay each, proportional to how much we earn (seems the fairest way to do it)

as an example, total outgoings = £5
I earn £15
She earns £10
So I pay £3 and she pays £2 (1/5 of what we earn)

Please help!

If we say for this that total outgoings is cell A1 my earnings is cell A2 and her earnings is cell A3

Many thanks in advance!

moid · 10 Oct 2007 at 23:02

your salary / (your salary + her salary) = share which you pay as a percent.

Just times this by the total outgoing

i.e.

(A2/(A2+A3))*A1

Haggisman · 10 Oct 2007 at 23:15

Thats absolutely perfect, thanks very much ^^

Munromax · 10 Oct 2007 at 23:59

I've been married for 35 years and never needed a formula to work out who pays - I just pay for everything and that's fair! (Im told)

NickR · 11 Oct 2007 at 08:16

Munromax said:
I've been married for 35 years and never needed a formula to work out who pays - I just pay for everything and that's fair! (Im told)

lol

same here (apart from the 35 years)