Hi, I'm looking for the excel formulas for E4 and E5

Cost/Unl Total Cost 3341 2697 FOOD COSTS (MATERIALS) Menu Code Quantity 3 3 1873 2 2267 3 1780 1913 1 1660 2 3523 3 2965 2 1793 2 2557 2 3776 2 2841 1 2135 3 3693 2 3923 1 2518 2 2992 3 1181 1 3262 2 3436 2 3810 3 2874 1721 2 3361 3 2570 2 Size Medium Large Large Large Large Medium Medium Large Medium Large Medium Medium Large Medium Large Medium Medium Medium Medium Medium Large Large Medium Large Large Medium Description Lasagna Vegetarian Garlic Prawns and Pasta Roast Vegetables Chlden Caolatore Herb Crusted leg of lamb Roast Chlden Roll Platter Vegetable Kebabs Sushi Mini Quiches Foccoda Platter. Vegetarian Crumbed Calamari Platter Fresh Seafood Platter Antipasto (Mixed Meat, Cheese and Olive Platter) Lemon Chiden Fingers Plotter Vegetarian Platter Spring Rolls Cheesy Tomato Basil Mussels Glazed Chicken Bites Cheese & Herb Potato Croquettes Bocconcini Tomato Skewers Garden Green Salad Greek Salad Italian Fruit Torte Tiramisu Lemon and Lime Tart Apple Ple Category Mains Mains Mains Mains Mains Mains Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Salads Salads Salads Desserts Desserts Desserts Desserts E4 3 E5 3 Total Cost 3 Size Medium Large Large Moins 2267 1780 Mains 3 3 1 2 1660 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 114 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 o. (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.) FOOD COSTS (MATERIALS) Menu Code Quantity Description Category Cost/Unit 3341 Lasagne Vegetarian Mains 2697 3 Garlic Prawns and Poste Mains 1873 Roast Vegetables Large Chicken Cacciatore Mains Large Herb Crusted leg of lamb 1913 Medium Roast Olden Roll Platter Mains Medium Vegetable Kebabs Finger Foods 3523 3 Sushi Finger Foods 2965 Min Quiches Finger Foods 2 Large Foceede Platter. Vegetarian Finger Foods Medium Crumbed Calamari Platter Finger Foods Medium Fresh Seafood Platter Finger Foods 2841 Large Antipasto Mixed Meat Cheese and Olive Platter Finger Foods 3 Lemon Chicken Fingers Platter Finger Foods 2 Large Vegetarian Platter Finger Foods Medium Mini Spring Rolls Finger Foods Medium Cheesy Tomato Basil Mussels Finger Foods 2992 3 Medium Glazed Chicken Bites Finger Foods Medium Cheese & Herb Potato Croquettes Finger Foods Medium Bocconcini Tomato Skewers Salads 2 Large Garden Green Salad Salads Large Greek Salad Salads Italian Fruit Torte 2 Tiramisu Desserts Large Lemon and Lime Tart Desserts Large Medium 2 1793 2557 3776 2 2 1 Medium 2135 3693 3923 2518 1 2 1 2 1181 3262 3436 3810 2874 1721 3361 3 3 Desserts Medium Large Desserts 3 2 2570 Medium Apple Ple Cost of Ingredients for Menu Options Large OH Menu Y Y Average Price Large $77.14 Calgary Moins Finger Foods Salads Desserts Dishes Avellable Average Price Medium 25 $51.25 42 $40.32 13 5253 $34.10 36073 $38.93 $51.40 Highest Price Lowest Price $140.00 $14.00 Menu Cod. Colegory 2627 1151 Moins 1230 Moins 3039 Moins 1261 Moins 1003 Maing 3341 Meins 2948 Mains 3821 Mein 1316 Meine 3053 Mein 3992 Meine 3900 Maine 2864 Maing 3860 Mains 3295 Maing 2697 Moins 1189 Moins 2346 Moins 1770 Moins 3924 Moins 1873 Molins 2267 Moins 2430 Moins 2792 1780 Mein 1913 Mein 3750 Maina 1660 Finger Foods 3483 Finger Foods 3781 Finger Foods 3523 Finger Foods Diel Roast Turkey Plotter Whole Turkey Roast with Stuffing Honey Maple Glazed leg Hom Seasoned Roost Pork with Cooking Traditional Lomb Roost Fruit Coke with Frosting and Decoration Lesegne Vegetarien Gnocchi (Spined and conte] Cannelloni Baat Lesere he way het Mane nekes Torta la Parva Reviel Frash (Spinach and Ricare) Reviel Fresh Val Gnocchi Con Patate Spaghetti Bolognese Siding Marinare Garlic Prowns and Paste Cannelloni Spinach & Ricette Eggo ant Parigione Pineapple Glazed Hom Italian Pot Roast Roest Vegetables Orden Colabore Olden Strogono! 39 Olen Platter Herb Cuated leg of land Reestriden Roll Pieter Oblouen Pletter The Vegetable Kabab Curry Pullo Fich, Prowns and Calamarl Petter Sushi Ingredient Cost Medium $63 $95 $125 $93 $140 $58 $65 598 $50 575 $42 563 $40 560 $35 553 $52 578 $44 566 $34 $51 $39 $50 $45 568 $34 $51 $46 $69 $63 $95 $45 $68 $45 568 $132 $102 $30 545 $35 553 $43 885 571 $65 598 $42 563 562 $37 556 556 $50 587 $65 Y $27 Cost/Unl Total Cost 3341 2697 FOOD COSTS (MATERIALS) Menu Code Quantity 3 3 1873 2 2267 3 1780 1913 1 1660 2 3523 3 2965 2 1793 2 2557 2 3776 2 2841 1 2135 3 3693 2 3923 1 2518 2 2992 3 1181 1 3262 2 3436 2 3810 3 2874 1721 2 3361 3 2570 2 Size Medium Large Large Large Large Medium Medium Large Medium Large Medium Medium Large Medium Large Medium Medium Medium Medium Medium Large Large Medium Large Large Medium Description Lasagna Vegetarian Garlic Prawns and Pasta Roast Vegetables Chlden Caolatore Herb Crusted leg of lamb Roast Chlden Roll Platter Vegetable Kebabs Sushi Mini Quiches Foccoda Platter. Vegetarian Crumbed Calamari Platter Fresh Seafood Platter Antipasto (Mixed Meat, Cheese and Olive Platter) Lemon Chiden Fingers Plotter Vegetarian Platter Spring Rolls Cheesy Tomato Basil Mussels Glazed Chicken Bites Cheese & Herb Potato Croquettes Bocconcini Tomato Skewers Garden Green Salad Greek Salad Italian Fruit Torte Tiramisu Lemon and Lime Tart Apple Ple Category Mains Mains Mains Mains Mains Mains Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Salads Salads Salads Desserts Desserts Desserts Desserts E4 3 E5 3 Total Cost 3 Size Medium Large Large Moins 2267 1780 Mains 3 3 1 2 1660 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 114 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 o. (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.) FOOD COSTS (MATERIALS) Menu Code Quantity Description Category Cost/Unit 3341 Lasagne Vegetarian Mains 2697 3 Garlic Prawns and Poste Mains 1873 Roast Vegetables Large Chicken Cacciatore Mains Large Herb Crusted leg of lamb 1913 Medium Roast Olden Roll Platter Mains Medium Vegetable Kebabs Finger Foods 3523 3 Sushi Finger Foods 2965 Min Quiches Finger Foods 2 Large Foceede Platter. Vegetarian Finger Foods Medium Crumbed Calamari Platter Finger Foods Medium Fresh Seafood Platter Finger Foods 2841 Large Antipasto Mixed Meat Cheese and Olive Platter Finger Foods 3 Lemon Chicken Fingers Platter Finger Foods 2 Large Vegetarian Platter Finger Foods Medium Mini Spring Rolls Finger Foods Medium Cheesy Tomato Basil Mussels Finger Foods 2992 3 Medium Glazed Chicken Bites Finger Foods Medium Cheese & Herb Potato Croquettes Finger Foods Medium Bocconcini Tomato Skewers Salads 2 Large Garden Green Salad Salads Large Greek Salad Salads Italian Fruit Torte 2 Tiramisu Desserts Large Lemon and Lime Tart Desserts Large Medium 2 1793 2557 3776 2 2 1 Medium 2135 3693 3923 2518 1 2 1 2 1181 3262 3436 3810 2874 1721 3361 3 3 Desserts Medium Large Desserts 3 2 2570 Medium Apple Ple Cost of Ingredients for Menu Options Large OH Menu Y Y Average Price Large $77.14 Calgary Moins Finger Foods Salads Desserts Dishes Avellable Average Price Medium 25 $51.25 42 $40.32 13 5253 $34.10 36073 $38.93 $51.40 Highest Price Lowest Price $140.00 $14.00 Menu Cod. Colegory 2627 1151 Moins 1230 Moins 3039 Moins 1261 Moins 1003 Maing 3341 Meins 2948 Mains 3821 Mein 1316 Meine 3053 Mein 3992 Meine 3900 Maine 2864 Maing 3860 Mains 3295 Maing 2697 Moins 1189 Moins 2346 Moins 1770 Moins 3924 Moins 1873 Molins 2267 Moins 2430 Moins 2792 1780 Mein 1913 Mein 3750 Maina 1660 Finger Foods 3483 Finger Foods 3781 Finger Foods 3523 Finger Foods Diel Roast Turkey Plotter Whole Turkey Roast with Stuffing Honey Maple Glazed leg Hom Seasoned Roost Pork with Cooking Traditional Lomb Roost Fruit Coke with Frosting and Decoration Lesegne Vegetarien Gnocchi (Spined and conte] Cannelloni Baat Lesere he way het Mane nekes Torta la Parva Reviel Frash (Spinach and Ricare) Reviel Fresh Val Gnocchi Con Patate Spaghetti Bolognese Siding Marinare Garlic Prowns and Paste Cannelloni Spinach & Ricette Eggo ant Parigione Pineapple Glazed Hom Italian Pot Roast Roest Vegetables Orden Colabore Olden Strogono! 39 Olen Platter Herb Cuated leg of land Reestriden Roll Pieter Oblouen Pletter The Vegetable Kabab Curry Pullo Fich, Prowns and Calamarl Petter Sushi Ingredient Cost Medium $63 $95 $125 $93 $140 $58 $65 598 $50 575 $42 563 $40 560 $35 553 $52 578 $44 566 $34 $51 $39 $50 $45 568 $34 $51 $46 $69 $63 $95 $45 $68 $45 568 $132 $102 $30 545 $35 553 $43 885 571 $65 598 $42 563 562 $37 556 556 $50 587 $65 Y $27