Formula (profit sharing) help needed

**invgrp** · 07-27-2012, 01:00 AM

I've tried everything i know and I just can't figure out how to write the needed formula.

Simply put, its about profit sharing.

Each month I share profits with an investor but some months there are no profits so the loss for that month need to be made up before profits are shared again.

Here's an example:

Profit Cumulative Investor Me

$1,000 $1,000 $500 $500
-$1,000 -$1,000 $0 $0
$500 -$500 $0 $0
$2,000 $1,500 $750 $750

When profits are paid that's the end to those calculations.

The problem I'm having is when there are profits but overall there are still losses.

All I want to do is keep tract of profit/loss and when there are profits issue a check and when there are losses they need to be made up before profits are paid again.

Comment: I've never been very good at writing multiple "if" in a single formula.

Any help would be appreciated.

Thanks.

IG.

P.S. I couldn't get the columns to line up, sorry.

**dilipandey** · 07-27-2012, 01:15 AM

Hi invgrp,

Suggest you to change the thread title to reflect the query you are asking.. see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**dogberry** · 07-27-2012, 03:16 AM

Hi

May have got it totally wrong for you but I have attached a sample file that works it out for you without any if statements. All you need to do is enter the profit/loss and any amounts paid out. Once a payout is made Balance goes back to zero and if you are in a loss situation Balance will show a minus amount.

**dogberry** · 07-27-2012, 03:40 AM

Sorry forgot to update the paid out columns on the above sheet

**invgrp** · 07-27-2012, 02:23 PM

Thanks for the .xls.

Unfortunately, my ability to explain what I wanted was lacking at best.

What I'm trying to accomplish is just inserting the profit $ number and the xls does the rest.

I'd like have:

1. the cumulative column be calculated automatically
2. the Investor and the Me columns be calculated automatically and based upon 50%?
3. when the cumulative profits are > $0 profits are to paid and then the profits are started over.

Thanks again.

IG

---------- Post added at 11:23 AM ---------- Previous post was at 08:13 AM ----------

I figured it out.

I just added a couple of "if" conditions and that did the trick.

Thanks for responding.