formula help

[Aarif]

hi all good people,
As I am a new excel user and don't know how to work with formulas.

My question is if two partners are running a small business and investing
money and takes back when they are getting profit from business i a formula
to calculate.

Example,

Partner 1 invested 50,000
Partner 2 invested 25,000
profit earned by their business 100,000

both partners are want to get refund of their investment and the amount of
profit shared in 50:50
how to calculate this by formula.

I am hopeful to get answer from u good people.

Aarif

 

[Ron Coderre]

Try something like this:

Using these values:
A1: 50,000
A2: 25,000
A3: 100,000

B1: =MIN(A1/SUM($A$1:$A$2)*$A$3,A1)+MAX($A$3-SUM($A$1:$A$2),0)*0.5
Copy that formula to B2

B1 will return: 62,500
B2 will return: 37,500

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[CLR]

I don't know if this is what you want or not, but I'll give it a try...
In A1 put Partner #1 invested
In B1 put 50000
In A2 put Partner #2 invested
In B2 put 25000
In A3 put Profit
In B3 put 100000
IN A4 put Profit after investment
In B4 put this formula =B3-sum(B1:B2)
In A5 put 1st Partner profit share
In B5 put this formula =B4*.5
In A6 put 2nd Partner profit share
In B6 put this formula =B4*.5

hth
Vaya con Dios,
Chuck, CABGx3