In Items sheet, Write " Required Qty " in cell J6 . Use if function in cell J7...
✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
In Items sheet, Write "Required Qty" in cell J6. Use if function in cell J7 to test the Quantity value according to the table below:
| Condition | Result for Required Qty |
| Quantity < 5 | 15 |
| Quantity < 10 | 10 |
| Quantity < 20 | 5 |
| Anything else | 0 |
Copy the function to cells J8:J30. What is the total Require Qty for all items.
.
Write the answer in the box.
Want instant access to all verified answers on moodle.polytechnic.bh?
Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!