How to use the AMORDEGRC Function in Excel Office 365?
Tags: tousetheamordegrcfun, excel, excelfunctions
Published: 2021-08-26 02:06:49

---
title: How to use the AMORDEGRC Function in Excel Office 365?
published: true
date: 2021-08-23 15:59:06 UTC
tags: ToUseTheAMORDEGRCFun,Excel,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-the-amordegrc-function-in-excel-office-365/
---

 **AMORDEGRC function** calculates the **amount** according to the **life of the product** using a **depreciation coefficient of product life**. In this tutorial, we will guide you on **how to use the AMORDEGRC Function In Excel Office 365**. Let’s get them below!! Get an 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)**

## AMORDEGRC Function Syntax

```
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
```

**Syntax Explanation:**

- **cost** : total cost **amount**.
- **Purchase date** : purchase date of **depreciation**.
- **first period end** : first period end **date**.
- **salvage** – **salvage value** at the end of the life of the asset.
- **rate** : **depreciation rate**.
- **[basis]** – [optional] **Day count basis**. Default is 0.

## Example

- Firstly, you need to **create the sample data** with **value and argument**.

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

- Then, you have to calculate the **AMORDEGRC function** over **values** and **significance** with the **numbers**.
- Now, you need to use the AMORDEGRC function **formula** given below.

```
=AMORDEGRC(A2,A3,A4,A5,0,A7,A8)
```

**Explanation:**

- **A2** : cost value in A2 cell.
- **A3** : Purchase date in A3 cell.
- **A4** : first period end in A4 cell.
- **A5** : salvage value in A5 cell.
- **0** : period value in A6 cell.
- **A7** : rate value in A7 cell.
- **A8** : [basis] cost value in A8 cell.

![](https://geekexcel.com/wp-content/uploads/2021/08/depreciation-amount-for-0th-end-of-period-or-the-first-depreciation.png)<figcaption>depreciation amount for 0th end of the period or the first depreciation</figcaption>

- After that, you have to **copy the formula** to the **other cells** freezing all the amount and **changing period value from 0 to 1,2,3,…,n.**

![](https://geekexcel.com/wp-content/uploads/2021/08/copy-the-formula-to-the-other-cells-1-1024x207.png)<figcaption>copy the formula to the other cells</figcaption>

- Finally, you need to check how much value **remained from $5000 along the period** using **depreciation amount** is shown below.

![](https://geekexcel.com/wp-content/uploads/2021/08/end-of-9th-period-1024x195.png)<figcaption>end of 9th period</figcaption>

**Check this too** : [Excel Formulas to Reverse Order of Characters in a Cell with Functions!!](https://geekexcel.com/excel-formulas-to-reverse-order-of-characters-in-a-cell-with-functions/)

**NOTES:**

- Excel stores **dates as serial numbers** and is used in calculation by the **function**.
- It is used to recommend to use **dates as cell reference** instead of giving **direct argument to the function**.
- Arguments **date of purchase, end of first period date & basis** are truncated to **integers**.
- After that, the function returns the **#VALUE! Error** if the **date of purchase & end of first period date** is not a **valid date format**.
- The function returns the **#NUM! Error** if:
  - rate is less than or equals to zero. discount 0.
  - If basis argument is either < 0 or  > 4.

## Verdict

We hope that this tutorial gives you guidelines on **how to use the AMORDEGRC Function In Excel Office 365. ** Please leave a comment in case of any **queries,** and don’t forget to mention your valuable **suggestions** as well. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!! **Read more on [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Next:**

- **[Excel Formulas to Calculate the Interest for Given Period ~ Quickly!!](https://geekexcel.com/excel-formulas-to-calculate-the-interest-for-given-period/)**
- **[Formulas to Lookup the Cost for the Product or Service!!](https://geekexcel.com/excel-formulas-lookup-the-cost-for-the-product-or-service/)**
- **[Excel Formulas to Calculate the Principal for Given Period ~ Easily!!](https://geekexcel.com/excel-formulas-to-calculate-the-principal-for-given-period/)**
- **[Formulas to Calculate the Shipping Cost with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-shipping-cost-with-vlookup/)**
- **[Excel Formulas to Calculate Loan Interest in Given Year ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-calculate-loan-interest-in-given-year/)**