Edit: Using Excel 2003.

I am trying to create a formula where by the result is the multiplication of a cell based on five possble ranges within that cell.

I currently have =if(A1<1500.00,A1*.1).

That works just fine if A1 is 1400.00.

I want it to also =if(AND(A1>1499.99,A1<3000.00),A1*0.15).

That, by itself, works just fine if A1 is 2000.00.

What I can't seem to figure out is how to have them both be in the same cell so that if A1 is 900 sometimes and other times it is 2200, that the formula will work. I need five of these in total to work in the same cell for the following ranges:

0-14999.99

1500.00-2999.99

3000.00-4499.99

4500.00-5999.99

6000.00+

With the corresponding multiplication respectively being:

*.10

*.15

*.20

*.25

*.30

Any help is appreciated.

I am trying to create a formula where by the result is the multiplication of a cell based on five possble ranges within that cell.

I currently have =if(A1<1500.00,A1*.1).

That works just fine if A1 is 1400.00.

I want it to also =if(AND(A1>1499.99,A1<3000.00),A1*0.15).

That, by itself, works just fine if A1 is 2000.00.

What I can't seem to figure out is how to have them both be in the same cell so that if A1 is 900 sometimes and other times it is 2200, that the formula will work. I need five of these in total to work in the same cell for the following ranges:

0-14999.99

1500.00-2999.99

3000.00-4499.99

4500.00-5999.99

6000.00+

With the corresponding multiplication respectively being:

*.10

*.15

*.20

*.25

*.30

Any help is appreciated.

Last edited: