How to Calculate SLA Percentage in Excel (with Quick Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.


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.

Dataset for calculating SLA percentage

  • Go to Cell C8 and put in the following formula.
=C6/C7

Formula for SLA percentage in Excel

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.

Change the format of cell in percentage form

  • 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


<< Go Back to Percentage Formula ExamplesCalculating Percentages | Calculate in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Alok Paul
Alok Paul

Alok Paul has completed his B.Sc. in Electronics and Telecommunication Engineering from East West University. He has been working on the ExcelDemy project for more than 2 years. He has written 220+ articles and replied to numerous comments. He is experienced in Microsoft Office, especially in Excel. He also led some teams on Excel and VBA content development. He has a keen interest in Advanced Excel, Data analysis, Excel Pivot Table, Charts, and Dashboard. He loves to research... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo