Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 8th 15, 05:49 PM
Junior Member
 
First recorded activity by ExcelBanter: Jan 2015
Posts: 1
Default Payroll calculations

So I'm equipped with a very basic working knowledge of excel, and I decided to try and help my mother with a more automated payroll calculator using excel. I've had no issues doing the formulas I wanted to figure the gross income, IRA/Social/Medicare withdrawals as well as figuring the net income after the IRA/Social/Medicare. These were all fairly simple and straightforward. My issue comes when I get to the federal and state tax withdrawals. My thought I could get by with an individual table for each employee based solely on number of dependents, and then just use a IF function to fill in the amount withheld based on if the aforementioned net is between two values.

My thinking was to have a side table like this where the P column is the low end of each wage, the R is the corresponding high value, and the R column is the withholding allowance claimed.
-----P-----Q----R
3 $565 $575 3
4 $575 $585 4
5 $585 $595 5

From there my "net" value is judged between the values on each row of the table and then puts the designated allowance in the main table.


Hopefully this is is enough to explain what I'm trying to do. Like I said I'm not very experienced with excel, and I'm not even sure if this is the best way to handle this situation.

Any help is greatly appreciated.

  #2   Report Post  
Old January 8th 15, 07:36 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2011
Posts: 3,514
Default Payroll calculations

Have a look here at TaxCalculator_IRS.xls...

https://app.box.com/s/23yqum8auvzx17h04u4f

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Payroll calculations for real time orlcgm Excel Worksheet Functions 2 October 6th 09 04:23 PM
Payroll Calculations Bernie Excel Worksheet Functions 3 March 8th 08 02:16 PM
payroll calculations Bernie Excel Worksheet Functions 1 February 22nd 08 07:32 PM
Payroll calculations dsimpkins Excel Programming 1 August 27th 07 06:38 PM
Adding payroll stubs payroll calculator Sable New Users to Excel 2 August 5th 06 05:37 PM


All times are GMT +1. The time now is 10:25 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017