In a worksheet, the start and end production dates of a machine are given, as well as the output during this period. How do you calculate the average daily production?
To calculate the average daily production:
1. Select cell B1 and type 10/18/2004.
2. Select cell B2 and type 11/13/2002.
3. Type 55,900 in cell B3.
4. Select cell B5 and type the following formula: =B3/(B1-B2).
 |
| DETERMINE THE AVERAGE OUTPUT USING MICROSOFT EXCEL |
Microsoft Excel Tutorials, Determine the average output using Microsoft Excel 2010, Microsoft Excel Video Tutorials, Basic Tutorials of Excel, VBA Macro using Excel Application
No comments:
Post a Comment