(Msg. 1) Posted: Sat Oct 24, 2009 6:45 am
Post subject: SUMIFS function Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
(Msg. 2) Posted: Sat Oct 24, 2009 7:59 am
Post subject: RE: SUMIFS function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> 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
(Msg. 3) Posted: Sat Oct 24, 2009 8:19 am
Post subject: RE: SUMIFS function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
> 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
(Msg. 4) Posted: Sat Oct 24, 2009 8:25 am
Post subject: RE: SUMIFS function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
=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
(Msg. 5) Posted: Sat Oct 24, 2009 10:14 am
Post subject: Re: SUMIFS function [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <lefty.TakeThisOut@discussions.microsoft.com> wrote in message
news:AEB8A0CC-1F0D-44B3-98DA-FB658E1676A7@microsoft.com...
> 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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office