Apologies if this has been asked before. I’m trying to create a simple spreadsheet where I can track product sales and stock levels.
What I have:
Four columns - Date, Product, Quantity, Total value
In the product column I have entered the items using Validity, so they can be selected from the drop down menu. Quantity is just free text cells. I then need the total column to check the value of the product cells, turn that into a monetary value and multiple by the quantity.
I have an IF THEN ELSE formula that can check the product and assign a monetary value (eg. C5*IF(C16=“Water”,“2.00”), but can’t work out how to multiple that by quantity to show the total value of the sale.
Thanks for any help.