R
Ryan
Hello,
I hope someone can assist me. I am somewhat new to Excel and hate to
ask stupid questions, but believe what I want to do is possible with a
formula.
I'll try to explain that what and why so it makes since. I have a
spreadsheet that is used in the calculation of sales commissions.
The salesperson has a sales goal, among other things, the spreadsheet
calculates their monthly performance to goal when we key in their
actual sales for the past month. It displays their performance to
goal as a percentage.
Then, there is a table. If a salesperson is at 90% of their goal, they
get one flat dollar amount. If they at a higher percentage, they get
the next higher dollar amount. There is a table on the side of the
spreadsheet with these dollar amounts.
Currently, we look at the calculated percentage and manually look up
the proper flat dollar amount for that percentage and key it into a
cell. I am certain this can be calculated by Excel but am unsure how
to proceed. Here is the "thought process" I am trying to turn into a
formula. These are examples.
1. If the calculated percentage in cell A12 is between 90% and 100%,
then I want cell C12 to display a sum of $100.
2. If the percentage in cell A12 is between 100% and 110%, then I want
the cell in C12 to display a sum of $200.
Now, I can tell it what sum to display or I can put in the cell number
where the table amount is and tell it to drop in what is in the proper
table cell.
Does that make ANY sense. Right now, I look at the percentage in C12,
look at the table on the side and key in the dollar amount. Can't
excel do that itself?
Again, sorry if I am unclear here. I am trying to explain what I want
to do as clearly as possible.
Thanks so much!
I hope someone can assist me. I am somewhat new to Excel and hate to
ask stupid questions, but believe what I want to do is possible with a
formula.
I'll try to explain that what and why so it makes since. I have a
spreadsheet that is used in the calculation of sales commissions.
The salesperson has a sales goal, among other things, the spreadsheet
calculates their monthly performance to goal when we key in their
actual sales for the past month. It displays their performance to
goal as a percentage.
Then, there is a table. If a salesperson is at 90% of their goal, they
get one flat dollar amount. If they at a higher percentage, they get
the next higher dollar amount. There is a table on the side of the
spreadsheet with these dollar amounts.
Currently, we look at the calculated percentage and manually look up
the proper flat dollar amount for that percentage and key it into a
cell. I am certain this can be calculated by Excel but am unsure how
to proceed. Here is the "thought process" I am trying to turn into a
formula. These are examples.
1. If the calculated percentage in cell A12 is between 90% and 100%,
then I want cell C12 to display a sum of $100.
2. If the percentage in cell A12 is between 100% and 110%, then I want
the cell in C12 to display a sum of $200.
Now, I can tell it what sum to display or I can put in the cell number
where the table amount is and tell it to drop in what is in the proper
table cell.
Does that make ANY sense. Right now, I look at the percentage in C12,
look at the table on the side and key in the dollar amount. Can't
excel do that itself?
Again, sorry if I am unclear here. I am trying to explain what I want
to do as clearly as possible.
Thanks so much!