How to calculate conditional discount

Moon786

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 afore-mentioned 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 per-product total price).

The discount must be computed using a single formula that will work correctly regardless of how big the subtotal is. All decision-making about the discount, based on the size of the subtotal, must be done automatically by the formula (using the IF function).

Krisso

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))