Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4 - Nested IF Statement ACME Company has a bulk buy purchase that they offer customers. They have found that the discounts are mot effective
4 - Nested IF Statement ACME Company has a bulk buy purchase that they offer customers. They have found that the discounts are mot effective if applied differently for times of the year. Between the months of January to the end of June, customers are offered a discount of 10% if the quantity was greater than or equal to 20 and a 5% discount if the quantity is over 10. For the remainder of the months the discounts have been reduced to 8% and 3% respectively. Construct an IF statement in column E that will calculate the discount %? The Total Cost is calculated (Price x Quantity x (1 - Discount) ** if you cannot get the discount by month working, just use the quantity discount to gain partial marks on the question. Higher marks are gained when the variables are defined in cells and referenced
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started