ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   trying to write a formula for payroll (https://www.excelbanter.com/excel-worksheet-functions/182169-trying-write-formula-payroll.html)

beachin2006

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

Ron@Buy

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


ryguy7272

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



All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com