<h2>
<u>ANSWER</u><u>:</u></h2>
- <u>TRUE</u>
- <u>FALSE</u>
- <u>FALSE</u>
- <u>TRUE</u>
- <u>TRUE</u>
<h2>
<u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u><u>_</u></h2>
<u>CARRY</u><u> </u><u>ON</u><u> LEARNING</u>
<u>CAN</u><u> </u><u>YOU</u><u> BRAINLEST</u><u> ME</u><u> PLEASE</u>
Answer:
Ans. Ready to download, please see the file attached to this document
Explanation:
Note. Consider changing the cell in yellow, does not make sense, it could be 10100 instead of 1010
Hi, to design this sheet, I also used the and(...) function of MS excel, in which you declate that in order to select a certain answer, 2 or more conditions must be true, in our case, if a purchase is up to 1000, the price would be $1010 (consider changing this value, maybe to 10100), if the purchase is more than 1000 and less than 5000, the price is $9,509.50, and if is more than 5000 units, the price would be $5,5005.50.
Please check the formula for further clarifications.
Best of luck.