How to Use Excel SLN Function in Office 365? (*With Examples*)
Tags: excelfunctions, excelslnfunctioninof, slnfunctioninoffice3
Published: 2020-09-30 12:16:34

---
title: How to Use Excel SLN Function in Office 365? (*With Examples*)
published: true
date: 2020-09-30 11:45:51 UTC
tags: ExcelFunctions,ExcelSLNFunctioninOf,SLNFunctioninOffice3
canonical_url: https://geekexcel.com/how-to-use-excel-sln-function-in-office-365-with-examples/
---

## Excel SLN Function:

![SLN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/SLN-Function.png)<figcaption id="caption-attachment-14898">SLN Function</figcaption>

In this tutorial, we will discuss the explanation, syntax, and usage of the **Excel SLN Function in Office 365**. Get an official version of **Microsoft Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel).
## Explanation of SLN Function:

- The Excel SLN function **calculates the asset depreciation for one period using the straight-line method**.

## SLN Function – Basic Syntax:

The fundamental syntax of **SLN Function** is,

```
=SLN (cost, salvage, life)
```

### Argument Description:

- **Cost (Required)** – It is the initial cost of the asset.
- **Salvage (Required)** – It is the value at the end of the depreciation. Sometimes, it is also referred to as the salvage value of the asset.
- **Life (Required)** – It is the number of periods over which the asset is depreciated. It is also called a useful life of the asset.

### Important Note:

- **#DIV/0! Error** – If the ‘Life’ argument is equal to 0 (zero), then the function returns the #DIV/0! Error.
- **#VALUE! Error** – The function returns the #VALUE! Error if any one of the input arguments contains a non-numeric character.

## Practical Examples of SLN Function:

Let’s look at some practical examples of **SLN Function**  and explore how to use it in Microsoft Excel.

### **Example 1: **

- The input values of cost, salvage, and life are entered into the cell range C5: E7.
- Here, in this example, we have selected the input cells C5, D5, E5 to calculate the depreciation.
- Refer to the below syntax of the  **SLN function**  to return the output.

```
=SLN (C5, D5, E5)
```

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-1-6.png)<figcaption id="caption-attachment-14895">Example 1</figcaption>

- You need to click **Enter** to execute the formula.

![Example 1 - Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-1-Output.png)<figcaption id="caption-attachment-14894">Example 1 – Output</figcaption>

- Now, you can see the result in the G5 cell.
- You can repeat the same for other input values.
- In another way, you can just drag the cell G5 to G7 so it automatically returns the respective output.

### **Example 2: **

- If the ‘Life’ argument is equal to 0 (zero), then the function returns the #DIV/0! Error.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-2-7.png)<figcaption id="caption-attachment-14896">Example 2</figcaption>

### **Example 3: **

- The function returns the #VALUE! Error if any one of the input arguments contains a non-numeric character.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-3-5.png)<figcaption id="caption-attachment-14897">Example 3</figcaption>

## A Brief Summary:

In this short tutorial, we have illustrated how to use **EXCEL SLN**  **Function** in **Office 365** with clear-cut practical examples. If you have any **queries/doubts** , kindly share it in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning With Us!!

## Read Ahead:

- **[How to Use Excel SUMPRODUCT Function in Office 365?](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)**
- **[Use Excel INFO Function in Office 365 – Simple methods!!](https://geekexcel.com/use-info-function-in-microsoft-excel-365-simple-methods/)**
- **[How to use Excel FIND Function in Office 365?](https://geekexcel.com/how-to-use-find-function-in-microsoft-excel-365/)**