How to use the VDB Function in Excel office 365? – Simple steps!!
Tags: tousethevdbfunction, excel, excelfunctions
Published: 2021-08-31 01:21:01

---
title: How to use the VDB Function in Excel office 365? – Simple steps!!
published: true
date: 2021-08-30 19:42:20 UTC
tags: ToUseTheVDBFunction,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-vdb-function-in-excel-office-365-simple-steps/
---

In this article, you will learn how to use the **VDB Function In Excel Office 365** using its basic syntax, explanation, and examples. Let’s see them below!! Get the official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## VDB Function

**VDB function** is the **Variable declining balance depreciation method** is the way of calculating the depreciation of any asset within a specific period. The **“Variable declining balance” method** is the way where the **depreciation of an asset** can be calculated for any **interval of period** , and also it returns **depreciation decline amount** within any interval of period.

## VDB Function Syntax

```
=VDB (cost, salvage, life, start_period, end_period, [factor], [no_switch])
```

**Syntax Explanation:**

- **cost :** Cost price of the asset
- **salvage :** remaining price of the asset after its lifetime period
- **life :** period after which cost price becomes salvage price
- **start\_period :** start year period for the depreciation
- **end\_period :** end year period for the depreciation
- **[factor] :** [optional] factor or rate at which depreciation declines. Default is set to 2.
- **[no\_switch] :** [optional] default is False. It is Switch when the depreciation is greater than the declining balance calculation, it doesn’t switch to straight line depreciation.

## Example

- Firstly, you have to **create a sample data** with **input values**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Sample-data-47.png)<figcaption>Sample data</figcaption>

- Then, you need to calculate the **depreciation amount for the Iphone within 1st year & 2nd year period.**
- Now, you have to use the **formula** to calculate **depreciation**.

```
=VDB (B2, C2, D2, 1, 2)
```

**B2:** Cost price of the asset.  
**C2:** the remaining price of the asset after a period.  
**D2** : 4 years after cost price becomes salvage price.  
**1:** start year to calculate depreciation amount.  
**2:** end year to calculate depreciation amount.  
**Factor:** default is 2.  
**Switch:** default is False.

![](https://geekexcel.com/wp-content/uploads/2021/08/VBA-Amount-1st-2nd-year-1024x310.png)<figcaption>VBA Amount 1st &amp; 2nd year</figcaption>

- After that, you need to calculate the **depreciation amount for different year intervals** separately.
- Now, you have to use the following **formula** to calculate **depreciation within 1st year & 3rd year**.

```
=VDB (B2, C2, D2, 1, 3)
```

**B2:** Cost price of the asset  
**C2:** the remaining price of the asset after a period  
**D2:** 4 years after cost price becomes salvage price  
**1:** start year to calculate depreciation amount.  
**3:** end year to calculate depreciation amount.

![](https://geekexcel.com/wp-content/uploads/2021/08/VBA-Amount-1st-3rd-year-1024x351.png)<figcaption>VBA Amount 1st &amp; 3rd year</figcaption>

- Finally, you need to calculate the **depreciation for all others**.

![](https://geekexcel.com/wp-content/uploads/2021/08/depreciation-for-all-others-1024x519.png)<figcaption>Depreciation for all others</figcaption>

**Check this too:**

- [DB Function in Office 365](https://geekexcel.com/excel-db-function-in-office-365-with-examples/)
- [RANDBETWEEN Function](https://geekexcel.com/how-to-use-excel-randbetween-function-in-office-365/)

## Verdict

From this chapter, you can get some clarification about **how to use the VDB Function In Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Related Articles:**

- **[How to use the NPER Function in Excel office 365?](https://geekexcel.com/how-to-use-the-nper-function-in-excel-office-365/)**
- **[Excel Formulas to Lookup a Latest Price ~ A Complete Tutorial!!](https://geekexcel.com/lookup-a-latest-price-excel-formula/)**
- **[How to use the AMORDEGRC Function in Excel Office 365?](https://geekexcel.com/how-to-use-the-amordegrc-function-in-excel-office-365/)**
- **[Excel Formulas to Calculate the Interest for Given Period ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-for-given-period/)**