# HELP IF a cell is between certain numbers multiply by a certain figure...

#### tandersondixon

##### New Member
Hi everyone,

Apologies if this has been answered before.

I am creating a rebate calculator for my business. Some people get rebates based on every order (TYPE1) (i.e. £0.1), others get volume based rebates (TYPE@) across the year, i.e. if they order 1000 items they get £0.1, 2000 items £0.02, 5,000 items £0.3 and so on.

I have created a table for every order and for the TYPE1 it simply calculates order * rebate = total rebate and then sums this at the bottom to give a total.

For TYPE 2 I do not know how to make a formula. I was going to black out the rebate column for every order and just have a formula in the total column that calculates the rebate based on the order. However I do not know how to do this.

How can i make it so if the total lands between different numbers the rebate total multiplies by a different figure.

Tom

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Replies
3
Views
107
Replies
0
Views
217
Replies
2
Views
116
Replies
16
Views
229
Replies
0
Views
245

1,127,100
Messages
5,622,722
Members
415,923
Latest member
Kam80

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back