Menu information is in a seperate table called Menu on another sheet In H14 enter a formula

Menu information is in a seperate table called "Menu" on another sheet  

Transcribed Image Text:

In H14 enter a formula to look up the Cost for the Menu code in C14 and size in E14 from the Menu table. Formula should copy down. In 14 enter a formula to calculate the Total Cost for that Menu item. Include a check in the calculation to see if the menu item is Off Menu, if it is return a cost of 0. (Items with a cost of 0 will automatically highlighted in orange to alert the user that they have selected an item that is not available.) In H14 enter a formula to look up the Cost for the Menu code in C14 and size in E14 from the Menu table. Formula should copy down. In 14 enter a formula to calculate the Total Cost for that Menu item. Include a check in the calculation to see if the menu item is Off Menu, if it is return a cost of 0. (Items with a cost of 0 will automatically highlighted in orange to alert the user that they have selected an item that is not available.)

Answer rating: 100% (QA)

In H14 formula will be C14E14 In I14 formula will be C14 Highlight one ... View the full answer