Question: Complete the Which is best? row ( F 1 7 :L 1 7 ) of the Cost Comparison table on the Cellular worksheet. Notice that

Complete the Which is best? row (F17:L17) of the Cost Comparison table on the Cellular worksheet.
Notice that the costs associated with Option 2 are already calculated in the worksheet.
Write a formula to display "Option 1" if the total cost of Option 1 is less than the total cost of Option 2 for that month.
If the total cost of Option 2 is less than the total cost of Option 1, display "Option 2".
Otherwise, display "No Difference".
Reuse your formula to determine which option is best for each month and in cell L17 to determine which option is best overall.
 Complete the Which is best? row (F17:L17) of the Cost Comparison

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!