I am making a spreadsheet to keep track of my hours worked as a server. I have 3 columns: one for my hours worked, one for my salary, and one for my tips.

I have a running date going down the A column. I figured out how to make all of the hours I enter to add up and equal a total at the bottom. As well as I figured out how to get the tips and salary to automatically had up.

Now- I am having difficulty figuring out how to get the hours and my wage of $9.50 to automatically multiply together. Like I am hoping that when I type in say: 6 hours into cell B2 that in C2 it will automatically pop up that I made $57. I want this to happen continuously for everyday. So I B3 to multiply by 9.50 and equal the amount in C3, then B4 and C4, then B5 and C5 and so on.

Then I also want the salary and tips to automatically add to equal a total for each day in another column.

Hopefully that makes sense. If someone could help me I would be so thankful. Thanks so much!