+ Reply to Thread
Results 1 to 2 of 2

Conditional nested array formula for payroll taxes

  1. #1
    Registered User
    Join Date
    12-31-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    2

    Conditional nested array formula for payroll taxes

    I'm trying to write an array formula that uses start date, end date, hours per day, and rate to calculate monthly payroll taxes (FICA) for a list of employees.

    The formula needs to check the start/end dates for inclusion in the calculation as well as decide which % each employee will be hit with. Either 7.65% or (if their salary thus far in the year has exceeded 136,800) then use 1.45%.

    The problem is the calculation of the salary is already a sumproduct, and I'm having trouble nesting the if/then for the salary check into an existing array.

    I have attached a sample workbook I've been using to test formulas, so you can see exactly what I'm trying to do.

    Any help would be greatly appreciated. Thank you.
    Attached Files Attached Files
    Last edited by brittymcsmartypants; 09-18-2019 at 03:19 PM.

  2. #2
    Registered User
    Join Date
    12-31-2012
    Location
    United States
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Conditional nested array formula for payroll taxes

    I figured it out. The problem was with networking days. If I split that calculation into a row on it's own, then I get the following solution

    Please Login or Register  to view this content.

+ 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. Replies: 10
    Last Post: 04-23-2017, 09:10 AM
  2. formula for payroll taxes w/ limits?
    By Need2Know in forum Excel General
    Replies: 4
    Last Post: 02-07-2017, 10:47 PM
  3. Calculating Payroll Taxes with Wage Limits
    By BCClub in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-01-2014, 06:27 PM
  4. Payroll taxes
    By livestrange in forum Excel General
    Replies: 2
    Last Post: 06-26-2010, 12:46 AM
  5. Payroll Taxes
    By missyreiber in forum Excel General
    Replies: 31
    Last Post: 01-30-2010, 12:45 AM
  6. [SOLVED] Payroll equation for SS taxes
    By lja57 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2006, 04:55 AM
  7. Need formula for budgeting payroll taxes.
    By rfhorn in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-05-2005, 12:06 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