8:34 AM marietta.mrooms3.net ...oTFw 4 of 5 8. You are given the following works
ID: 3598909 • Letter: 8
Question
8:34 AM marietta.mrooms3.net ...oTFw 4 of 5 8. You are given the following worksheet that contains pricing information for making copies. Sheet for Copies 11 Order Number of Copies Total Cost Cells A2:B9 list the costs per copy based on the sotal number of copies being made. The price for ess than 10 copies corresponds to S0.10 per copy, the price for at least 10 copies but less than 2s copies corresponds to SO009 per copy,ete Write a formula in cell C12 to determine the total cost of making copies for this order (275 copies). Write the formula so that it work when copied into cells C13 C14. (10 Points) 9. Wrie a formula to choose the name of the third day of the week from the list starting with Sunday Monday. Tuesday,.Saturday. (10 Points)Explanation / Answer
Solution:
8. Formula in cell C12 : =IF( B12>A9, B12 * B9, IF(B12>A8, B12*B8, IF(B12>A7, B12*B7, IF(B12>A6, B12*B6, IF(B12>A5, B12*B5, IF(B12>A4, B12*B4, IF(B12>A3, B12*B3 ) ) ) ) )))
Copy the similar formulae for the rest for the cells to get the price amount calculated.
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.