SUMIFS function

[lefty]

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.

 

[John]

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

 

[Mike H]

Hi,

Try this

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

Mike

 

[Mike H]

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

 

[Teethless mama]

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