I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

=IF(A1<10000,A1*0.08,IF( A120001,A1*0.04,A1*0.06))

Laura Cook


" wrote in
message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

On 1 Feb, 18:48,
wrote:
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

=IF(A1<10000, A1*0.08,IF(A120001, A1*0.04,IF(A110001,A1*0.06)))

And that should do the trick.

Hope this helps,
Matt
http://teachr.blogspot.com

=if(a120000,.04,if(a210000,.06,.08))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

" wrote in
message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

it is. Any help ?

"CLR" wrote:

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

=if(a120000,.04,if(a210000,.06,if(a10,.08,00))) *a1


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...

=if(a120000,.04,if(a210000,.06,.08))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

" wrote
in message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

You may wish to consider something like this..........


=IF(A120000,10000*0.08+10000*0.06+0.08*(A1-20000),IF(A110000,10000*0.08+0.06*(A1-10000),0.08*A1))

This way, the more the person sells, the more money they make.

Vaya con Dios,
Chuck, CABGx3




" wrote:

it is. Any help ?

"CLR" wrote:

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

I think that Chuck may have been alluding to the fact that with your figures
as salesman gets 800 commission for 10,000 but gets LESS than that for all
values up to 13,333! Similarly he gets 1,200 commission for 20,000 but
needs to to more than 30,000 before he will get that much again.

From the information you gave it is not clear what you want for exactly
10,000. I am going to assume that you meant <=10,000 adjust the formula if
not:

=A1*(4-(A110000)-(A120000))*0.02


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


" wrote in
message ...
it is. Any help ?

"CLR" wrote:

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the
following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04.
can
anyone help ?

One more to ponder.

=LOOKUP(A1,{0,10002,20002},{0.08,0.06,0.04})*A1


Gord Dibben MS Excel MVP

On Fri, 1 Feb 2008 10:48:00 -0800,
wrote:

I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

Hi,

It's not actually the way you stated it, but did you
mean for the split to go like this?

Sales of 23000 would be paid like follows
10000 at 8% plus 10000 at 6% plus 3000 at 4%

If that is the case take a look at John McGimpsey's site
http://www.mcgimpsey.com/excel/variablerate.html

HTH
Martin



" wrote in
message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

Good point Martin


Gord

On Sat, 2 Feb 2008 09:21:38 +1000, "MartinW" wrote:

Hi,

It's not actually the way you stated it, but did you
mean for the split to go like this?

Sales of 23000 would be paid like follows
10000 at 8% plus 10000 at 6% plus 3000 at 4%

If that is the case take a look at John McGimpsey's site
http://www.mcgimpsey.com/excel/variablerate.html

HTH
Martin



" wrote in
message ...
I need the formula to multiply by 3 diferent rates base on the following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04. can
anyone help ?

Hmmmm...........typeo here's correction........

=IF(A120000,10000*0.08+10000*0.06+0.04*(A1-20000),IF(A110000,10000*0.08+0.
06*(A1-10000),0.08*A1))

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote in message
...
You may wish to consider something like this..........



=IF(A120000,10000*0.08+10000*0.06+0.08*(A1-20000),IF(A110000,10000*0.08+0.
06*(A1-10000),0.08*A1))

This way, the more the person sells, the more money they make.

Vaya con Dios,
Chuck, CABGx3




" wrote:

it is. Any help ?

"CLR" wrote:

I sure hope that's not a Sales Commssion scale..........

Vaya con Dios,
Chuck, CABGx3



" wrote:

I need the formula to multiply by 3 diferent rates base on the
following
assumptions if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04.
can
anyone help ?

if a<10,000,a*0.08,if a10001,a*0.06, if a20001,a*0.04
You almost have the formula correct as you presented the issue.

You must keep in mind that the IF/THEN/ELSE function will stop considering
conditions, when the first TRUE path has been determined.

I also use the = and <= conditional operative.

=if(A1=20,000,A1*0.04,(A1<=10000,A1*0.08, A1*0.06))
-OR-
=if(A1<=10,000,A1*0.08,(A1=20000,A1*0.04, A1*0.06))
However, I like the format of showing the percentage rather than the decimal
equivalent as follows;

=if(A1<=10,000,A1*8%,(A1=20000,A1*4%, A1*6%))