Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Green Jobs For Sustainable Development

Authors: Ana Maria Boromisa, Sanja Tišma

1st Edition

131775185X, 9781317751854

More Books

Students also viewed these Economics questions

Question

6. How can a message directly influence the interpreter?

Answered: 1 week ago