In the process of making a costing template for a new drinksmenu.
Part 1 - Making a text cell represent a numerical value
Need to create a template where I can make one cell with text equal another cell with numerical data. i.e. in the spreadsheet A14(text) = B14(numeric) - but still display both (in the case of price changes).
Part 2 - Selecting said item A14(text) (from drop down list) in a different area (K3) but it would instead act as B14 (numeric value) - so when selected from drop down menu, it acts as a number(B14) rather than text value(A14).
Part 3 - It gets easier from here (I think). In M3 I want displayed a multiplication sum. i.e. L3*K3 (50 is entered into L3). Which would equal 3.00 (50*0.0600). i.e. (50XBulleitBourbonPrice Incl VAT) or (50*A14(which is acting as B14)) or (50X€0.06).
End Result is displayed in 7R X 5C-
Only data entry by user is to select options in column K and entering amount in column L. Total Price for all ingredients can be easily calculated
