Results 1 to 6 of 6

Frusterated by formulas

Threaded View

  1. #1
    Registered User
    Join Date
    07-22-2015
    Location
    NY
    MS-Off Ver
    2013
    Posts
    4

    Angry 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?
    Last edited by kbuch315; 07-23-2015 at 09:51 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Need Formulas to Hide Partial Concatenate Data and Help Determining Two Other Formulas
    By Mattdim805 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2013, 04:11 PM
  2. Using Cell references in file paths for formulas to create dynamic formulas
    By MichaelStokesJr in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-04-2013, 11:49 AM
  3. Replies: 5
    Last Post: 09-25-2013, 02:51 PM
  4. [SOLVED] VBA to enter various formulas every 10 rows and show dynamic formulas not values
    By faby2203 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-04-2013, 07:05 AM
  5. Ctrl+Shift+Enter (CSE) array formulas in VBA using differing formulas
    By officeguy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 04:31 PM
  6. Multiple formulas in selected cell without damaging previous formulas.
    By excel5111987 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 02-05-2011, 06:15 AM
  7. code to add formulas to a range with previous formulas appearing inside the new one
    By Excel-o-ratoR in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2010, 06:02 AM
  8. Replies: 5
    Last Post: 05-05-2008, 02:22 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1