Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a commission calculation chart w/ "if" condition?
I am trying to set up a formula where a commission amount is calculated based
on the amount of sales an individual makes during a period. Say, if the sales amount is below $3000, the commission % is 1% (ie commission amount would be $30, which is $3000x1%). If the sales amount is greater than $3000 but less than $6000, the commission % is 1.5. If the sales amount is greater than $6000 but less than $8000, the commission % is 2%. So on and so forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If anyone knows, I would appreciate if you could let me know via or I can call you on long distance if you give me the phone number. Best regards, John |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a commission calculation chart w/ "if" condition?
Here's a link
http://www.mcgimpsey.com/excel/variablerate.html -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Johnw" wrote in message ... I am trying to set up a formula where a commission amount is calculated based on the amount of sales an individual makes during a period. Say, if the sales amount is below $3000, the commission % is 1% (ie commission amount would be $30, which is $3000x1%). If the sales amount is greater than $3000 but less than $6000, the commission % is 1.5. If the sales amount is greater than $6000 but less than $8000, the commission % is 2%. So on and so forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If anyone knows, I would appreciate if you could let me know via or I can call you on long distance if you give me the phone number. Best regards, John |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a commission calculation chart w/ "if" condition?
Hi!
Is it a straight commission on the total amount or is it a cumulative rate commission? Which one of these: 1. total = 5000 commission is 1.5% of 5000 2. total = 5000 commission is 1% of the first 2999 plus 1.5% of the amount from 3000 to 5000 Biff "Johnw" wrote in message ... I am trying to set up a formula where a commission amount is calculated based on the amount of sales an individual makes during a period. Say, if the sales amount is below $3000, the commission % is 1% (ie commission amount would be $30, which is $3000x1%). If the sales amount is greater than $3000 but less than $6000, the commission % is 1.5. If the sales amount is greater than $6000 but less than $8000, the commission % is 2%. So on and so forth...2.5%,3%, 3.5% up to 5%. Can this formula be set up in Excel? If anyone knows, I would appreciate if you could let me know via or I can call you on long distance if you give me the phone number. Best regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I limit my chart | Charts and Charting in Excel | |||
How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |