# How to Calculate Productivity Percentage in Excel (4 Useful Methods)

Suppose you have the following dataset:

### Method 1 – Find the Labor Productivity Percentage

Steps:

• To multiply the number of laborers by their corresponding working hours per day, click the cell where the result will go (F5) in this example.
• Enter the following formula.
=C5*D5
• Press Enter.

• Use the Autofill Tool to copy the formula to the remaining cells in the column.

• Move to an adjacent cell (G5) and enter the following formula.
=C5/F5
• Press Enter.

The result will be productivity but will need to be formatted.

• Select the entire column (G).
• Go to the Home tab and choose Percent Style under the Number drop-down.

The results are now properly formatted.

### Method 2 – Find the Productivity Percentage of Machines

Steps:

• Click an appropriate cell (F5) and insert the following formula.
=D5*E5

• Press ENTER.

• Go to an adjacent cell (G5) and enter the formula below.
=C5/F5

• Press ENTER.
• Use the Autofill Tool to copy the formula to the remaining cells in the column.

• Select the entire column (G).
• Go to the Home tab and choose Number Format.

• The Format Cells dialog box will appear. Select Percentage and click OK.

Note: Alternatively, press CTRL + 1 to open the Format Cells dialog box directly.

The results are now properly formatted.

### Method 3 – Estimate the Productivity Percentage of Products

Steps:

• Click an appropriate cell (E5) and insert the following formula.
=C5/D5
• Press ENTER.
• Use the Autofill Tool to copy the formula to the remaining cells in the column.

The result will be productivity but will need to be formatted.

• Select the entire column (E).
• Press CTRL + SHIFT + 5 to get the result in percentages format.

### Method 4 – Calculate Productivity Per Employee

Steps:

• Click an appropriate cell (E5) and insert the following formula.
=C5/D5

• Press ENTER.
• Use the Autofill Tool to copy the formula to the remaining cells in the column.

Get FREE Advanced Excel Exercises with Solutions!
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at Youâ€™ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF