How do I set up multiple if statements in Excel?

I'm trying to set up a formula to calculate commissions based on weekly
sales, as follows:

If $1000<sales<$2500, commission = sales*30%
If $2500<sales<$4000, commission = sales*35%
If $4000<sales<$4500, commission = sales*40%

Can anyone help, please? I'm using Excel 2000.

Thanks.

One way

http://www.mcgimpsey.com/excel/variablerate.html

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"LKraft0318" <LKraft0318@discussions.microsoft.com> wrote in message
news:8EEDFBE3-5227-45C2-8399-1189DD25F80E@microsoft.com...
> I'm trying to set up a formula to calculate commissions based on weekly
> sales, as follows:
>
> If $1000<sales<$2500, commission = sales*30%
> If $2500<sales<$4000, commission = sales*35%
> If $4000<sales<$4500, commission = sales*40%
>
> Can anyone help, please? I'm using Excel 2000.
>
> Thanks.

Set up a table with the rates. It should look like this:

0 0
1000 0.30
2500 0.35
4000 0.40

Let's say you put that in K1:L4

Then with the sales in A1, the formula is

=A1*VLOOKUP(A1,$K$1:$L$4,2)


On Wed, 9 Feb 2005 12:41:07 -0800, "LKraft0318"
<LKraft0318@discussions.microsoft.com> wrote:

>I'm trying to set up a formula to calculate commissions based on weekly
>sales, as follows:
>
>If $1000<sales<$2500, commission = sales*30%
>If $2500<sales<$4000, commission = sales*35%
>If $4000<sales<$4500, commission = sales*40%
>
>Can anyone help, please? I'm using Excel 2000.
>
>Thanks.