Confused and need help putting salary formula's together

[Robbietheboy]

I recently opened a business and starting to get some traction and I need to put a formula together that kicks in at different points.
first €25k goes to person one
next €35k - 70% goes to person two and 30% goes to person one
after reaching €60k all further income is split 50/50

Here is my pathetic effort at it. I am not an excel person but trying to learn.

 

[kchiba]

Hi Robbie,

see the attached file, I have tried to make all the parameters dynamic, so you can change the split. The formulas are in the highlighted cells

kanti

 

[David Evans]

There are several ways of getting this done, Robbietb!
Here's my crack at it ...

 

[Robbietheboy]

kc, David,
Thank you both very much for your help. David I have gone with your version and I cannot thank you enough for your help. This has been a big elephant in the room in my business for the last 6 months and this will give it great clarity. Thanks again it is "greatly" appreciated
Robbie

 

[Ashish0078]

Hello Robbie,

I am also try something to solve your problem ,,i hope it is easily understable for you..check my attached file

 

[ankurmurarka]

Hello Robbie,

I am also try something to solve your problem ,,i hope it is easily understable for you..check my attached file

you did straight forward calculation however, commission is slab wise ...

 

[Suraj Gawade]

Hi Robbie,
I think thi will be the simplest way to solve the problem.
Check attached file.

 

[Khurrum]

Sorry Robie got it late. Dont know, is it what you looking for?

 

[sivakumarrathinam]

Using only if conditions I try to answer for your question You can change the limit here instead of 25000 and 60000

 

[sivakumarrathinam]

Using only if conditions I try to answer for your question You can change the limit here instead of 25000 and 60000

Now revised and with explains the questions what I understand