software

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

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-Proquot;Aarifquot; wrote:

gt; hi all good people,
gt; As I am a new excel user and don't know how to work with formulas.
gt;
gt; My question is if two partners are running a small business and investing
gt; money and takes back when they are getting profit from business i a formula
gt; to calculate.
gt;
gt; Example,
gt;
gt; Partner 1 invested 50,000
gt; Partner 2 invested 25,000
gt; profit earned by their business 100,000
gt;
gt; both partners are want to get refund of their investment and the amount of
gt; profit shared in 50:50
gt; how to calculate this by formula.
gt;
gt; I am hopeful to get answer from u good people.
gt;
gt; Aarif

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
quot;Aarifquot; wrote:

gt; hi all good people,
gt; As I am a new excel user and don't know how to work with formulas.
gt;
gt; My question is if two partners are running a small business and investing
gt; money and takes back when they are getting profit from business i a formula
gt; to calculate.
gt;
gt; Example,
gt;
gt; Partner 1 invested 50,000
gt; Partner 2 invested 25,000
gt; profit earned by their business 100,000
gt;
gt; both partners are want to get refund of their investment and the amount of
gt; profit shared in 50:50
gt; how to calculate this by formula.
gt;
gt; I am hopeful to get answer from u good people.
gt;
gt; Aarif