Q: Refer again to the spreadsheet in Q2, and assume that the following range names have been created: number_ordered (cell B5); discount51 (cell B11); discount101 (cell B12); and cost_per_cabinet (cell B15). What is a formula for cell B16 that would use these range names?
or
Q: Assume that the range names number_ordered (cell B5), discount51 (cell B11), discount101 (column B12), and cost_per_cabinet (cell B15) have been constructed by consulting the spreadsheet from Q2. What formula would make use of these range names in cell B16?
- =if(number_ordered<51,0,if(number_ordered>100, cost_per_cabinet*discount101, cost_per_cabinet*discount51))
- =if(number_ordered<51,0,if(number_ordered>100, cost_per_cabinet*30%, cost_per_cabinet*20%)
- None of these
- =if(number_ordered<51,0,if(number_ordered>100, cost_per_cabinet*discount101, cost_per_cabinet*discount51)
- =if(discount51=”true”, cost_per_cabinet*discount51, if discount101=”true”, cost_per_cabinet*discount101, 0 ))
Explanation: The only formula that accurately applies the discount logic based on the number of cabinets ordered while correctly utilizing the range names is Option 2.
