Formula to calc staff expenses

I am very new to excel. I have created an expense sheet for the staff. It is to calculate for meals. Breakfast is 9.95, lunch 10.50, dinner 27.50. I would like a formula that the employee can simply enter the amount of meals (eg. 4 breakfast) and that cell will automatically multiply the 4 by 9.95 and display the total amount being $39.80. Breakfast lunch and dinner have their own cells so I would like to use the formula for each and then have a cell at the end with the total amount. Any help would be greatly appreciated.

Hi and welcome to the forum

Please take a moment to read the forum rules regarding thread titles - I have changed your tite for you this time

I would suggest that you have a column for the qty and another for the item (you can have a drop-down for this to aviod typos). Then you need to create a another table that has 2 columns, 1 for the item, and the next for the corresponding cost.

You can then use a vlookup() to pull in the item cost and multiply it by the amount

If you have a problem with this, let me know and upload a sample workbook, I will talk you through it