SLA is one kind of contract between companies to ensure the service quality of a product or service. SLA is very important to maintain service quality. This article will discuss how to calculate SLA percentage in Excel.

**Table of Contents**Expand

**What Is SLA and SLA Percentage?**

**SLA** stands for service level agreement. It expresses the level of service quality the customer expects from the vendor or service provider. It also includes a set of penalties if the service level is below the expected value.

And **SLA **percentage is the presentation of **SLA **in percentage. It can be expressed as the amount of service served following the **SLA **criteria divided by the total amount of service served by the vendor in percentage form. The formula for the **SLA **percentage is given below.

**How to Calculate SLA Percentage in Excel: 2 Simple Steps**

Here, we will discuss all the steps to calculate **SLA **percentage in Excel in detail.

In this article, we will show the SLA conducted by a logistic service provider and electronics product manufacturer. Assume that the manufacturer informs the logistic provider to collect the product from 9:00 AM to 02:00 PM every day and the logistic provider will collect the product within 4:00 PM according to the SLA. But the logistic provider can also collect the product after 4:00 PM but within 6:00 AM and they will get a 25% penalty for late collection of the product according to the SLA. Now, we will calculate the SLA percentage in Excel to express this scenario.

### 📌 Step 1: Calculate SLA Percentage with Formula

- We noted the data on the datasheet of Excel.

- Go to
**Cell C8**and put in the following formula.

`=C6/C7`

This is created based on the division of the product collected within the **SLA **criteria and the total number of products collected on that day.

- Press the
**Enter**

**Read More: **Make an Excel Spreadsheet Automatically Calculate Percentage

### 📌 Step 2: Apply % Format in Excel to Get SLA Percentage

We get the result in decimal form. But we want to get the result in percentage form. Change the format of **Cell C8**. Press **Ctrl + 1**.

**Format Cells**window appears.- Choose
**Percentage**from the**Number**tab. - Choose the number of decimal places.

- Finally, press the
**OK**button.

We get the **SLA **percentage.

**Download Practice Workbook**

Download this practice workbook to exercise while you are reading this article.

**Conclusion**

In this article, we described in detail the process of how to calculate the SLA percentage in Excel. I hope this will satisfy your needs. You can also use the comment section below for further queries or suggestions.

## Related Articles

- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Percentage of Budget Spent in Excel
- How to Calculate Utilization Percentage in Excel

- How to Calculate Absenteeism Percentage in Excel

- How to Calculate Savings Percentage in Excel

- How to Calculate Productivity Percentage in Excel
- How to Calculate Variance Percentage in Excel

- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel

**<< Go Back to Percentage Formula Examples | Calculating Percentages | Calculate in Excel | Learn Excel**