SUMIFS function

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.
 
J

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
 
M

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top