How do I set up multiple if statements in Excel?

L

LKraft0318

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

Myrna Larson

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)
 

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