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
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 586 Job postings
 17 Who can benefit from AAT?
 36 Where can AAT take me?
 44 Getting started with AAT
 26 Finding an AAT training provider
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership