Commission Split Formula

take a look at this. I don't think we're there yet... as you stopped explaining what you want before the end... I think. Choose the % from the yellow shaded drop-down boxes.

Originally Posted by Glenn Kennedy

take a look at this. I don't think we're there yet... as you stopped explaining what you want before the end... I think. Choose the % from the yellow shaded drop-down boxes.

Hey Glenn,

Thanks so much for taking a tackle at this!! This is almost perfect to what I'm looking for. So I apologize if it got confusing.

So the company % and the commission split % are correct.

I didn't add this, but we don't always take a 5% facilitation split, so there should be a 0% option for it as well.

The 5-15% commission split should be based off the company earnings not off the commission split (1).

So company Net should be 2.25 not 2.38

Really awesome job!!!!

I'm getting confused.... Not enough coffee. Check this over and (if needed) fill in expected answer manually in gold cells.

Originally Posted by Glenn Kennedy

I'm getting confused.... Not enough coffee. Check this over and (if needed) fill in expected answer manually in gold cells.

This is basically almost there. The company %, Comission split & Facilitation are all correct now.

Can you display the company split 2 off of the gross company earnings (for example another 50, 45, 40, 35, 30, 20)

So there should be 2 splits off of the 5$ to display 2 values.

so 2.50 for commission split 1 & 2.50 for company split 2.

And if theres a facilitation fee then it should be company split MINUS the facilitation fee.

I attached the example again.

Sorry if this is confusing.

OK. Another variant!!

LeoJ... Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!


The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.