SUMIFS function

  • Thread starter Thread starter lefty
  • Start date Start date
L

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.
 
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
 
Hi,

Try this

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

Mike
 
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
 
Back
Top