+ Reply to Thread
Results 1 to 2 of 2

Formula needed to use the Fed Withholding chart in Excel

  1. #1
    Registered User
    Join Date
    01-15-2014
    Location
    Upstate NY
    MS-Off Ver
    Excel for MAC 2011
    Posts
    1

    Formula needed to use the Fed Withholding chart in Excel

    I have a payroll spreadsheet that will calculate everything for payroll except the withholding tables.
    I want to LOOKUP the withholding determined by the wage amount. Here is the Table: SINGLE Withholding Table.xlsx
    The formula also needs to reference the column to indicate the number of withholding allowances claimed.
    I've tried the formula below. The wages are calculated in cell E6. I think I may need to add an IF statement, but I'm seriously confused about where to add it.

    =VLOOKUP(E6,MarriedWithholding!$B$6:$C$73,MATCHES(E6, MarriedWithholding!$B$6:$C$73, 1), FALSE)

    Any help would be appreciated.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,936

    Re: Formula needed to use the Fed Withholding chart in Excel

    1. You attached "SINGLE ..." vs. MarriedWithholding
    2. You did not post the workbook with the formula
    3. Your posted formula has: MATCHES... (?) Is that a mistake or something new?
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula needed for planning chart - hard to explain in title !
    By chrisnewton in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2013, 05:47 AM
  2. Federal Tax Withholding Formula Slightly Off?
    By mv835 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-19-2013, 10:59 PM
  3. Calculate withholding
    By boneob in forum Excel - New Users/Basics
    Replies: 15
    Last Post: 03-08-2010, 09:47 AM
  4. federal withholding tax
    By Bobby in forum Excel General
    Replies: 18
    Last Post: 07-08-2006, 05:15 AM
  5. Replies: 2
    Last Post: 01-13-2006, 03:00 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