Excel

posted by .

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.

  • Excel -

    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

  • Excel -

    need help

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Bus. Math

    How much money should be deposited each year for 30 years at 3% to accumulate $1000,000?
  2. math using excel

    how do i use excel to plot a graph then find x from the slope of a line?
  3. excel Buget

    I am trying to get a formula for excel I have merchandis Amount shirt 13 29.95 pants 22 shoes18 dress16
  4. Data Analysis

    I have a mathematical problem that I don't know how to solve in Excel, where might I go for help?
  5. Probability

    Given additional information that 56% of the total employees in the company are male and 50% of them are employees who have been working less than 5 years. If an employee selected at random is known to have been working for 5 years …
  6. economic

    I HAVE AN ASSIGNMENT WHERE I HAVE TO PLOT POINTS ON A GRAPH IN EXCEL, THE INFORMATION GIVEN IS QS=2P-20 AND QD=80-2P AND I WAS TOLD TO USE PRICES 10,20,30,40,50 AND QUANTITIES 5,10,15,20,25,30,35,40 FOR THE GRAPH. I HAVE NO CLUE WHAT …
  7. words

    12. You’ve created a pie chart in Excel and placed it in a PowerPoint presentation. When you edit the pie chart in Excel, the pie chart in PowerPoint doesn’t retain the changes you’ve made. This means that the object has been …
  8. Ms. Sue please

    Ms. Sue I had asked this of you already and you said a histogram would be best but I get confused on this and when I enter it into excel it comes out wrong. The data we have is for age 1-14 death rate per 1000 is 4.6, 15-24 rate is …
  9. Excel VBA

    Am confused for this class am taking we had to design serval procedures that do different things: 6 procedures were sine, cosine, cube, square, common log, and natural log. In order to get this values we had to design loops. I have …
  10. Excel

    I have my employee schedule in a excel sheet. It is a weekly schedule that doesn't change week by week, but changes day by day within a week. Every Monday, Tuesday, etc. is the same schedule. In the file are days for Monday, Tuesday, …

More Similar Questions