Frusterated by formulas

I have to make a data table for school using excel 2013. I have most of it done, however I am stuck on figuring out the formulas for 2 columns.



Lab 3-2 Into the Woods Weekly Payroll Report Complete.xlsx

I have to figure out the answers to column J & K. The answers are right now manually entered but are suppose to be entered using a formula. Here are the questions my books is asking me to get those formulas.
To get the state tax: State tax is calculated as a percentage of federal tax. Use the tax rate in the Tax Rate table to calculate state tax in column J.
To get Net Pay: Calculate Net Pay in column K, as Gross Pay-Soc Sec.. Medicare, Federal Tax, and State Tax.

Can anyone help me figure out what formulas to use?

Hi, welcome to the forum

I would like to point out a few things to you here...
1. Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

2. This sounds very much like a homework project. Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

No I am not cheating, I am asking for help with figuring out formulas. I thought that's what this forum was for? I am not asking for the direct formula but help figuring it out (tips anyone can give me).

Sorry, didnt mean to imply you were cheating, just that you would be denying yourself a learning experience - no offence meant

We will by all means help with suggestions and tips, but you need to do most of the work yourself (sorry, sounding like a teacher here lol)

What have you tried so far, and what were the results?