multiple "ÏF" formula
- by Karen
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 formula's so desperately need some help.
Thanks