SUMIFS function
 

Hi, everybody. I have a spreadsheet that I'm designing for work and need
assistance. I am trying to figure out salary information. Comission is
based on the amount of sales. For instance, if cell C6 contains the amount
of the individual's sales for the month and salary is based on: 1 - $2000 =
5% of sales, $2001 - $5000 = 7% and$5000 and up = 12.5%. What would I
utilize for a formula to calculate? Would this be a SUMIFS function and if
so how would I create that? This is utilizing Excel 2007.
--
Thanks!
Lefty

SUMIFS function
 

Hi
You can do it this way
=IF(A12<2000,A12*105%,IF(A12<=5000,A12*107%,IF(A12 5000,A12*112.5%)))
HTH
John
"lefty" wrote in message
...
Hi, everybody. I have a spreadsheet that I'm designing for work and need
assistance. I am trying to figure out salary information. Comission is
based on the amount of sales. For instance, if cell C6 contains the amount
of the individual's sales for the month and salary is based on: 1 - $2000 =
5% of sales, $2001 - $5000 = 7% and$5000 and up = 12.5%. What would I
utilize for a formula to calculate? Would this be a SUMIFS function and if
so how would I create that? This is utilizing Excel 2007.
--
Thanks!
Lefty

SUMIFS function
 

Hi,

Try this

=((MIN(3000,MAX(0,C6-2000))*0.07)+MIN(100,C6*0.05))+MAX(0,C6-5000)*0.125

Mike

"lefty" wrote:

Hi, everybody. I have a spreadsheet that I'm designing for work and need
assistance. I am trying to figure out salary information. Comission is
based on the amount of sales. For instance, if cell C6 contains the amount
of the individual's sales for the month and salary is based on: 1 - $2000 =
5% of sales, $2001 - $5000 = 7% and$5000 and up = 12.5%. What would I
utilize for a formula to calculate? Would this be a SUMIFS function and if
so how would I create that? This is utilizing Excel 2007.
--
Thanks!
Lefty

SUMIFS function
 

Hi,

Ignore my last and use this

=((MIN(100,C6*0.05))+MIN(3000,MAX(0,C6-2000))*0.07)+MAX(0,C6-5000)*0.125

Mike

"Mike H" wrote:

Hi,

Try this

=((MIN(3000,MAX(0,C6-2000))*0.07)+MIN(100,C6*0.05))+MAX(0,C6-5000)*0.125

Mike

"lefty" wrote:

Hi, everybody. I have a spreadsheet that I'm designing for work and need
assistance. I am trying to figure out salary information. Comission is
based on the amount of sales. For instance, if cell C6 contains the amount
of the individual's sales for the month and salary is based on: 1 - $2000 =
5% of sales, $2001 - $5000 = 7% and$5000 and up = 12.5%. What would I
utilize for a formula to calculate? Would this be a SUMIFS function and if
so how would I create that? This is utilizing Excel 2007.
--
Thanks!
Lefty

SUMIFS function
 

=LOOKUP(C6,{1,2001,5001},{0.05,0.07,0.125})*C6


"lefty" wrote:

Hi, everybody. I have a spreadsheet that I'm designing for work and need
assistance. I am trying to figure out salary information. Comission is
based on the amount of sales. For instance, if cell C6 contains the amount
of the individual's sales for the month and salary is based on: 1 - $2000 =
5% of sales, $2001 - $5000 = 7% and$5000 and up = 12.5%. What would I
utilize for a formula to calculate? Would this be a SUMIFS function and if
so how would I create that? This is utilizing Excel 2007.
--
Thanks!
Lefty