J
Jen
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(E18>7,602,E18*0.5), but that didn't work.
Can anyone help me??
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(E18>7,602,E18*0.5), but that didn't work.
Can anyone help me??
