commission spreadsheet
 

Hello, I am trying to update my new commission structure and I am stumped on
this last section, which is new. The new structure is that any commission
made over $5000 is only paid out at 50% and everything between 0 - $5,000 is
paid out at 100%.

This portion of my spreadsheet looks like this:

Estimated Commission = all commission paid out

Less Windfall (Paid at 50% past $5,000) = anything over 5000 gets paid out
at 50%. for example, if the estimated commission was 10,000, this section
would say 2,500

Total estimated commission = Estimated Commission - Windfall

I tried =IF(E187,602,E18*0.5), but that didn't work.

Can anyone help me??

One way:

Total estimated commission: =(E18 + MIN(E18,5000))*0.5



In article ,
Jen wrote:

Hello, I am trying to update my new commission structure and I am stumped on
this last section, which is new. The new structure is that any commission
made over $5000 is only paid out at 50% and everything between 0 - $5,000 is
paid out at 100%.

This portion of my spreadsheet looks like this:

Estimated Commission = all commission paid out

Less Windfall (Paid at 50% past $5,000) = anything over 5000 gets paid out
at 50%. for example, if the estimated commission was 10,000, this section
would say 2,500

Total estimated commission = Estimated Commission - Windfall

I tried =IF(E187,602,E18*0.5), but that didn't work.

Can anyone help me??

Wow, you rock! Thank you so much for your help!! :)

"JE McGimpsey" wrote:

One way:

Total estimated commission: =(E18 + MIN(E18,5000))*0.5



In article ,
Jen wrote:

Hello, I am trying to update my new commission structure and I am stumped on
this last section, which is new. The new structure is that any commission
made over $5000 is only paid out at 50% and everything between 0 - $5,000 is
paid out at 100%.

This portion of my spreadsheet looks like this:

Estimated Commission = all commission paid out

Less Windfall (Paid at 50% past $5,000) = anything over 5000 gets paid out
at 50%. for example, if the estimated commission was 10,000, this section
would say 2,500

Total estimated commission = Estimated Commission - Windfall

I tried =IF(E187,602,E18*0.5), but that didn't work.

Can anyone help me??