So, Row 2 will have varying values in each cell (see the "Price" row). I want to be able to put a 1 or 2 or sometimes even a decimal in the cells across from the menu item (see the 1 entered under the burger patty column). Once I enter that 1 or 2 or whatever, I want Excel to multiply it by the number in Row 2. Any time a number is inserted across from the menu items I want this done and the products added together and appear in the "cost" column next to the menu item.
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
COST | PRICE | D.I.P. | COST % | Burger Patty | |
Price | $0.89 | ||||
Quantity/Portion | 1/3 lb burger | ||||
Basic Burger | $8.75 | 1 | |||
Basic Burger, DBL | $10.75 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>