How to Calculate the SLA Percentage in Excel – 2 Quick Steps

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.

The formula for the SLA percentage is given below.

The sample dataset showcases the SLA conducted by a logistic service provider and electronics product manufacturer. The manufacturer requires the logistic provider to collect the product from 9:00 AM to 02:00 PM every day. The logistic provider will collect the product until 4:00 PM according to the SLA. But the product can also be  collected between 4:00 PM and 6:00 AM incurring on a 25% penalty for late collection.

Step 1 – Calculate the SLA Percentage with a Formula

Dataset for calculating SLA percentage

  • Go to C8 and enter the following formula.
=C6/C7

Formula for SLA percentage in Excel

This is 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 Enter

Read More: Make an Excel Spreadsheet Automatically Calculate Percentage


Step 2 – Apply a % Format  to Get the SLA Percentage in Excel

  • To see the result in percentage, press Ctrl + 1.
  • In Format Cells, select the Number tab.
  • Choose Percentage.
  • Select the number of decimal places.

  • Click OK.

The SLA percentage is displayed.


Download Practice Workbook

Download this practice workbook to exercise.


Related Articles


<< Go Back to Calculating Percentages | Calculate in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
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