I am trying to write an IF formula for an order form where a discount is applied depending on the amount of units ordered.

The discounts are:

- 0 to 24 units - 0 discount
- 24 to 59 units – 5% discount
- 60 to 95 units – 10% discount
- 96 to 131 units – 15% discount
- 132 to 263 units – 20% discount
- 264+ units - 30% discount

The cell that I am taking the total from is `J1028`

. I have no idea how to do IF formulas so desperately need some help.

`I`

since it seems the umlaut may be affecting the ability to find 'IF' when searching. – pnuts Dec 21 '12 at 18:23