How to Use Excel DOLLARDE Function in Office 365? – {with Examples}
Tags: exceldollardefunctio, excelfunctions
Published: 2020-09-28 08:00:28

---
title: How to Use Excel DOLLARDE Function in Office 365? – {with Examples}
published: true
date: 2020-09-28 06:52:57 UTC
tags: ExcelDOLLARDEFunctio,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dollarde-function-in-office-365-with-examples/
---

## Excel DOLLARDE Function:

[![DOLLARDE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DOLLARDE-Function.png)](https://geekexcel.com/?attachment_id=14635#main)<figcaption id="caption-attachment-14635">DOLLARDE Function</figcaption>

In this article, we are going to see the usage of **Excel DOLLARDE Function in Office 365** with its syntax, explanation, and examples. 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)
## **DOLLARDE Function – Description:**

- This function **converts a dollar price expressed as a fraction part into an equivalent decimal number**.
- For example, **DOLLERDE** ( **1.03, 16** ) taken as 1 ( **integer part** ) and 3/16 ( **fraction part** ) then convert it to a decimal value.

## **Syntax:**

**=DOLLARDE(fractional\_dollar, fraction)**

### Arguments Description:

**Fractional\_dollar – ** It is the number expressed as an integer part and fraction part separated by decimal symbol.

**Fraction – ** The denominator in the fractional unit. For example, 4 = 1/4, 5 = 1/5, 8 = 1/8, etc.

### Note:

- If the fraction is less than 0, then it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).
- If the fraction is greater than or equal to 0 and less than 1, then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).

## **Examples:**

Let’s see some examples to make you understand this concept easily.

### Example 1:

- In the below image, you can see the input **dollar values** and **fraction values** are given in **Columns B & C**.
- The **output decimal values** are displayed in **Column E**.

[![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-103.png)](https://geekexcel.com/?attachment_id=14631#main)<figcaption id="caption-attachment-14631">Example 1</figcaption>

### Example 2:

- If the fraction is less than 0, then it returns [**#NUM! Error**](https://geekexcel.com/how-to-fix-num-error-in-excel-office-365-with-example/).

[![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-86.png)](https://geekexcel.com/?attachment_id=14632#main)<figcaption id="caption-attachment-14632">Example 2</figcaption>

### Example 3:

- If the fraction is greater than or equal to 0 and less than 1, then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).

[![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-46.png)](https://geekexcel.com/?attachment_id=14633#main)<figcaption id="caption-attachment-14633">Example 3</figcaption>

## **Closure:**

In this article, you can clearly understand the usage of **Excel DOLLARDE Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel NORM.DIST Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-norm-dist-function-in-office-365-with-examples/)
- [How to Use Excel DCOUNT Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-dcount-function-in-office-365-with-examples/)