How to calculate conditional discount
Moon786
Registered Posts: 3
this question in excel,
The discount is to be computed as follows: (1) No discount for the first $100. (2) For subtotals above $100, five percent of the amount that the subtotal exceeds $100. (3) For subtotals above $500, the aforementioned discount plus an additional five percent of the amount that the subtotal exceeds $500. The discount should be applied to the subtotal of all products (not the perproduct total price).
The discount must be computed using a single formula that will work correctly regardless of how big the subtotal is. All decisionmaking about the discount, based on the size of the subtotal, must be done automatically by the formula (using the IF function).
The discount is to be computed as follows: (1) No discount for the first $100. (2) For subtotals above $100, five percent of the amount that the subtotal exceeds $100. (3) For subtotals above $500, the aforementioned discount plus an additional five percent of the amount that the subtotal exceeds $500. The discount should be applied to the subtotal of all products (not the perproduct total price).
The discount must be computed using a single formula that will work correctly regardless of how big the subtotal is. All decisionmaking about the discount, based on the size of the subtotal, must be done automatically by the formula (using the IF function).
0
Comments

This can be achieved using an if and formula. something along these lines
=IF(B8>500,B8*10%,IF(AND(B8<=500,B8>100),B8*5%,0))
0