Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default trying to write a formula for payroll

I am new to Excel and need assistance with a spreadsheet
I have the hourly rate, regular rate and overtime rate
Gross pay of $667.5 as well as the fica and fex taxes
How do I write this out to give me the net pay for each employee
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 345
Default trying to write a formula for payroll

Difficult to understand your full requirement from your description
i.e how you want your spreadsheet to look, will you require printed reports
etc., etc.
However try look here, lots of free spreadsheets already set up and maybe
you can find something that will help:
http://www.ozgrid.com/search/templates.htm



"beachin2006" wrote:

I am new to Excel and need assistance with a spreadsheet
I have the hourly rate, regular rate and overtime rate
Gross pay of $667.5 as well as the fica and fex taxes
How do I write this out to give me the net pay for each employee

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default trying to write a formula for payroll

Use a (free) template:
http://office.microsoft.com/en-us/te...011771033.aspx
http://www.vertex42.com/ExcelLinks/c...eduling-1.html



Regards,
Ryan---

--
RyGuy


"Ron@Buy" wrote:

Difficult to understand your full requirement from your description
i.e how you want your spreadsheet to look, will you require printed reports
etc., etc.
However try look here, lots of free spreadsheets already set up and maybe
you can find something that will help:
http://www.ozgrid.com/search/templates.htm



"beachin2006" wrote:

I am new to Excel and need assistance with a spreadsheet
I have the hourly rate, regular rate and overtime rate
Gross pay of $667.5 as well as the fica and fex taxes
How do I write this out to give me the net pay for each employee

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 formula when shift is 3pm to 1 am payroll spreadsheet help Excel Discussion (Misc queries) 4 October 14th 06 07:19 PM
Adding payroll stubs payroll calculator Sable New Users to Excel 2 August 5th 06 05:37 PM
need help with a payroll formula Frustrated Excel Worksheet Functions 1 February 1st 06 08:40 AM
How do I write a formula in excel that calculates payroll? Excel overtime formula Excel Worksheet Functions 3 October 29th 05 10:52 PM
Need formula for budgeting payroll taxes. rfhorn Excel Worksheet Functions 10 April 5th 05 04:11 PM


All times are GMT +1. The time now is 09:21 AM.

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

About Us

"It's about Microsoft Excel"