I have to create a payroll document for class using Excel and I am quite confused.
Here is the parts that I am confused on.
-I have to calculate the number of years the employees have been working for us, I believe the function I need to use is TODAY() but it is not working, how can I get that function to work?
I also need to figure out how to use the functions IF (when looking at 401K amounts compared to payroll and health care payments)
Also if I want to get the sum of a few cells I would use SUM or TOTAL ?
Thanks.
You can always get help in computer programs by pressing the F1 key and then using the Index or Search feature.
Here are some places online where you can get help with Excel in particular:
Excel 2003 Help and How-to - Excel - Microsoft Office Online See the power of Excel dashboard reporting, a technique to visually present critical data in summary form. More on Excel Help ...
http://office.microsoft.com/en-us/excel/FX100646961033.aspx
Index of Help for Excel functions, graphs and testing Help and tips for microsoft excel functions, graphs and spreadsheet testing.
http://www.meadinkent.co.uk/excel.htm
Excel tutorials, lessons and help. Excel tutorials, lessons, and help. If you're a new or advanced Excel spreadsheet user, you're sure to find something here.
http://math.about.com/od/excel/Excel_Tutorials_Lessons_and_Help.htm
need help
To calculate the number of years an employee has been working for you, you need to use the DATEDIF function instead of TODAY(). The TODAY() function simply returns the current date, whereas DATEDIF calculates the difference in years between two given dates.
Here is how you can use the DATEDIF function to calculate the number of years an employee has worked:
1. Ensure you have the start date of employment in one cell (let's say A2) and the current date in another cell (let's say B2). You can use the date format for both cells to ensure accuracy.
2. In the cell where you want to display the number of years of employment (let's say C2), enter the following formula:
=DATEDIF(A2,B2,"y")
This formula calculates the difference in years (denoted by "y") between the start date (A2) and the current date (B2).
Now, let's move on to the IF function.
The IF function is used to perform logical tests and return different values based on the test result. Here's how you can use it for comparing 401K amounts with payroll and healthcare payments:
1. In a new cell (let's say D2), enter the following formula:
=IF(401K_amount > payroll_amount, "Amount is greater", "Amount is not greater")
Replace "401K_amount" and "payroll_amount" with the actual cell references where these values are stored.
This formula compares the 401K amount with the payroll amount. If the 401K amount is greater than the payroll amount, it will display "Amount is greater". Otherwise, it will display "Amount is not greater".
Finally, regarding your question about getting the sum of a few cells, you should use the SUM function.
1. In a cell where you want to display the sum (let's say E2), enter the following formula:
=SUM(A2:C2)
Replace "A2:C2" with the actual range of cells you want to add up. For example, if you want to add the values in cells A2, B2, and C2, you would use this formula.
I hope these explanations help you with your payroll document creation. Let me know if you have any further questions!