Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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?? |
#2
|
|||
|
|||
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?? |
#3
|
|||
|
|||
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheet Dilemma | Excel Discussion (Misc queries) | |||
Scan and copy cells from one spreadsheet to another. | Excel Discussion (Misc queries) | |||
Some exported records do not show on spreadsheet | Excel Worksheet Functions | |||
Help with Commission forumlas | Excel Worksheet Functions | |||
Calculating commission schedule (will pay for help!) | Excel Worksheet Functions |