Re: Various Formulas (Excel 2000)

Whether you round the average (D23) to zero decimals or just display as 0 is up to you. It only makes a difference if you are using it later in calcs. Rounding will change the value used in calcs while displaying it differently will not.

Re: Various Formulas (Excel 2000)

OK I took a look at your workbook, and I found some things that I would have done, so I hope you like them.

1) "This is the max and min units" OK check the Max and Min functions. These are where you put them in cells D24 and D25.

2) "total wages with overtime" Is this not <font color=blue># of Regular Hours worked * Rate of pay </font color=blue>+<font color=red> # of Overtime Hours worked * Overtime Rate of pay</font color=red>?

See what I have done in cells I23 and I24 and I added the Total wages figure just for the heck of it <img src=/S/cool.gif border=0 alt=cool width=15 height=15> in cell I25.

3) "avg. units producted per hour" You got that right, in cell D22. I guess it is the number of units produced divided by the # of hours to produce them.

4) "I cell formatted with 0 decimal places. Is that correct or should it be rounded" Jay its your workbook, some things should be rounded, but others should not. I would suggest you check the workbook I am attaching to see where I left the rounding off.

All the underlined cells have formulas, so I did that for you to look at. You may want to remove this format when you are done checking the formulas.

I also added a section in Columns A and B at Row Row 40 to make a section for use with the cells E24, E25 and D26. I though you would like to see these extras as well.

OK hope this gave you a starting point. Great work, you have done a wonderful job.

Re: Various Formulas (Excel 2000)

The name templist is defined as:

<pre>='Production Group Weekly Report'!$A$41:$C$48
</pre>

The VLOOKUP in cell E24 is looking for the value 631,590. That value is found in cell A52, which is outside the range defined by templist. Since the last parameter to VLOOKUP is FALSE, it is looking for an exact match which it does not find in the range A41:A48. That is causing the #N/A error. Just changing the definition of templist to include A52 also will not produce the result you seek since the cell at C52 is blank, not a date. My best guess is that the formula you want in E24 is:

<pre>=VLOOKUP(D24,$B$41:$C$48,2,FALSE)
</pre>

If you want to use a range name for the table, you will need to define a new name for this range.