|
I have a commission chart I would like excel to check against to return the commission rate onto a big box on the front of my chart. Basically I have the current percentage to goal and I need excel to check that against the chart, which is something like this 0 to 80 | 0% 80 to 100 | 5% 100 to 120 | 10% 120 to 150 | 15% 150 + | 20% Any chance anyone could help me on this one, I guess I need to know how to format my chart so excel can read it and how to make excel look at it.
|
# ¿ Jul 11, 2010 17:24 |
|
|
# ¿ May 5, 2024 23:01 |
|
Actually the numbers are percent to goal of total sales, so my sheet adds all of my sales against my monthly goal and tells me my percentage, and when that percentage is within those amounts I get te listed comission
|
# ¿ Jul 11, 2010 19:53 |
|
As of right now for this month my total sales are 132% to Goal, this means my team is currently getting 15% commission. This changes on a daily basis. This number controls the amount of commission my team can get. So anywhere from 80-100% to goal gets you 5% commission, etc. So I need look at that percentage (in this case 132) and then look at where that falls on the chart (80-100, 100-120, 120-149, 150+) and have it return the amount of commission that corresponds with that value on the chart (5, 10, 15, and 20. In this case 15). That way I can show each team member how much money they are getting in commissions right now. I have the whole chart set up fine except for having the chart automatically know the current rate of commission from our sales to goal.
|
# ¿ Jul 12, 2010 02:45 |
|
I saw you said not 0 to 80 and 5 on 81-100 and thats what I need, I'm sorry I'm really bad at explaining this stuff, which is probably why I have such a problem figuring out where to look in help and online to learn this stuff.
|
# ¿ Jul 12, 2010 17:35 |