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

tandersondixon

New Member
Joined
Jul 26, 2013
Messages
1
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.

Thanks for your help in advance.

Tom
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Watch MrExcel Video

Forum statistics

Threads
1,122,930
Messages
5,598,925
Members
414,268
Latest member
bluebandersnatch

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top