Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use OR function inside SUMIFS | Excel Discussion (Misc queries) | |||
sumifs function | Excel Discussion (Misc queries) | |||
Sumifs function | Excel Worksheet Functions | |||
SUMIFS function help | Excel Discussion (Misc queries) | |||
Can SUMIFS use the OR function? | Excel Worksheet Functions |