How to Use Excel SYD Function in Office 365? (With Examples)
Tags: excelfunctions, excelsydfunctioninof
Published: 2020-10-02 07:58:52

---
title: How to Use Excel SYD Function in Office 365? (With Examples)
published: true
date: 2020-10-02 05:54:56 UTC
tags: ExcelFunctions,ExcelSYDFunctioninOf
canonical_url: https://geekexcel.com/how-to-use-excel-syd-function-in-office-365-with-examples/
---

## Excel SYD Function:

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

This post assists you to know the definition, fundamental syntax, and usage of the **Excel SYD 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).
## SYD Function – Definition:

- The Excel SYD Function **calculates the ‘sum-of-years’ depreciation for an asset for a specified period**.
- SYD is short for the **s** um of **y** ears **d** igits.
- It is a well-known method in evaluating accelerated asset depreciation. The formula is as follows:

## Fundamental Syntax of SYD Function:

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

```
=SYD(cost, salvage, life, per)
```

### Argument Description:

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

### Important Note:

- [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/) – The error appears if either:
  - The given **‘salvage’** argument is < 0;
  - The **‘per’** argument is greater than the supplied **‘life’** argument;
  - The **‘per’** or **‘life’** argument is less than or equal to 0.
- [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/) – The function returns the #VALUE! Error if any one of the supplied values is a non-numeric character.

## Examples of SYD Function:

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

### **Example 1: **

- Here, in this example, we have selected the input cells C5, D5, E5 & F5 to calculate the sum-of-years’ depreciation.
- Refer to the below syntax of the  **SYD function**  to return the output.

```
=SYD(C5, D5, E5,F5)
```

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-1-1.png)<figcaption id="caption-attachment-14968">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/10/Example-1-Output-1.png)<figcaption id="caption-attachment-14967">Example 1 – Output</figcaption>

- Now, you can see the result in the H5 cell.
- Then, 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: **

- The error appears if the given ‘salvage’ argument is < 0 or the ‘per’ argument is greater than the supplied ‘life’ argument or the ‘per’ or ‘life’ argument is less than or equal to 0.

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

### **Example 3: **

- The function returns the #VALUE! Error if any one of the supplied values is a non-numeric character.

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

## A Brief Summary:

We hope that the above post helped you to know how to use **EXCEL SYD Function in Office 365**. The examples let you understand the function even more clearer. Don’t forget to share your **queries/doubts** 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/)**