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


"Aarif" wrote:

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