Formula to check stock levels and sale

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.

https://wiki.documentfoundation.org/Ask/Guide_-_How_to_use_the_Ask_site#More_details #More_details

Maybe something like attached? [modified]
ProductLookup122739.ods (13.5 KB)

For anything more than the most simple spreadsheet as above, you should think whether a database would be more suitable.

=iFS(C16="voda",C5*2,C16="limo",C5*3.35,C16="prosecco",C5*5.98,…,…,1=1,"no value")