Formula Help for Excel

[Nicole12345]

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!

[Cutter]

Hello Nicole12345 - welcome to the forum.

Unfortunately you'll have to comply with the forum rules before we can help you.
Click on the Forum Rules link at the top of the page and pay particular attention to Rule #1.

Once you've acted on that the help will you need will be gladly given.

[MarvinP]

Hi Nicole and re-welcome to the forum,

Cutter is correct as we need to track questions and answers by good thread names. You could rename this thread to "How do I calculate total pay?"

I have the answer ready for you but can't post it until you do the following. Edit your original post by clicking on the Green Edit button below the post. Then click on "Go Advanced" and then look at the top where you have typed your thread name. Change this to my suggestion above. This will allow us to answer your question.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST