tommygunnz
New Member
- Joined
- Dec 20, 2017
- Messages
- 17
I'm trying to make a commission structure for Excel and it's pretty difficult
So we get paid 30% of the front gross + 10% of the back gross = total commission.
Example: $2,000 front = $600, and $2000 back =$200 grand total $800
if the front is negative, subtract that to the back gross x 10%.
if its below 250, you get paid 250 minimum. if its above 250, you the higher pay.
example $-2000 front & $4000 back = 10% x $2000= $200 id get $250 commission
example $-2000 front & $8000 back = 10% x $6000=$600 id get paid $600
example $-20 front & $4000 back=10% x $3980 id get paid $398
example $200 front (200*.3=60) & $4000 back (4000*.1=400) total paid $460
We will always get paid a minimum of $250 total.
any way someone can help me make an function for this?
So we get paid 30% of the front gross + 10% of the back gross = total commission.
Example: $2,000 front = $600, and $2000 back =$200 grand total $800
if the front is negative, subtract that to the back gross x 10%.
if its below 250, you get paid 250 minimum. if its above 250, you the higher pay.
example $-2000 front & $4000 back = 10% x $2000= $200 id get $250 commission
example $-2000 front & $8000 back = 10% x $6000=$600 id get paid $600
example $-20 front & $4000 back=10% x $3980 id get paid $398
example $200 front (200*.3=60) & $4000 back (4000*.1=400) total paid $460
We will always get paid a minimum of $250 total.
any way someone can help me make an function for this?
