I have to create a payroll document for class using Excel and I am quite confused.

Question

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.

Answer 1

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

Answer 2

need help