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 F:L of the Cost Comparison table on the Cellular worksheet.
Notice that the costs associated with Option are already calculated in the worksheet.
Write a formula to display "Option if the total cost of Option is less than the total cost of Option for that month.
If the total cost of Option is less than the total cost of Option display "Option
Otherwise, display No Difference".
Reuse your formula to determine which option is best for each month and in cell L to determine which option is best overall.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
