Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to calculate utilization rate in Excel and Google Sheets
Excel & Google Sheets
=B2/A2✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Total Capacity | Actual Usage | Utilization Rate |
| 100 | 85 |
=B2/A2→0.85
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
Step by step
- 1Enter your total capacity in cell A2.
- 2Enter the actual usage in cell B2.
- 3In cell C2, enter the formula =B2/A2 to calculate the utilization rate.
- 4Format cell C2 as a percentage to make the rate more readable.
Tips
- Ensure that the total capacity (A2) is not zero to avoid division by zero errors.
- Adjust the cell references in the formula if your data is located elsewhere in the worksheet.
- Consider formatting the result as a percentage for better readability.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
Frequently asked
What if my total capacity is zero?
If the total capacity is zero, the formula will return a #DIV/0! error. Ensure that the total capacity is a non-zero value.
Can I use this formula for different types of resources?
Yes, this formula can be used for any resource where you have a measure of total capacity and actual usage.
How do I format the result as a percentage?
Select the cell with the formula, right-click, choose 'Format Cells', then select 'Percentage' in Excel or use the percentage button in the toolbar in Google Sheets.