Howdy All ... Looking for a form 1

[TheAceMan1]

Howdy All ...

Looking for a formula (or VBA routine) to calculate proportional payments of a bill, by two people, according to income.
Any help appreciated in advance.

Your Thoughts? ...

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!

 

[macropod]

Assume the incomes are in A1 & B1
In A2, insert: =A1/($A1+$B1)
copy across to B2.
put bill amount in C3.
In A3, insert: =A2*$C3
copy across to B3.
Proportionate amounts are in A3 & B3.



Cheers
Paul Edstein
[MS MVP - Word]

 

[TheAceMan1]

How are ya macropod ...

I've been deriving formulas all weekend and got mentally tired out. Don't believe I danced all around it. Yhanks for the post.

See Ya . . .

Be sure to see FAQ219-2884 Worthy Reading!
Also FAQ181-2886 Worthy Reading!