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

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

## Excel DOLLARFR Function:

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

In this tutorial, we will guide you to learn the usage of **Excel DOLLARFR 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)

## **DOLLARFR Function – Explanation:**

- This function **converts the decimal number into a fractional number**.
- It is just opposite to the [**DOLLARDE Function**](https://geekexcel.com/how-to-use-excel-dollarde-function-in-office-365-with-examples/).

## **Syntax:**

**=DOLLARFR(decimal\_dollar, fraction)**

### Arguments Description:

**Decimal\_dollar – ** It is the decimal number.

**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 0, 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 understand how this function works.

### Example 1:

- In this screenshot, you can see the **input decimal values** and **fraction**  **values** are given in **Columns**  **B & C**.
- The **output fractional numbers** are displayed in **Column**  **E**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-104.png)<figcaption id="caption-attachment-14638">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-87.png)<figcaption id="caption-attachment-14639">Example 2</figcaption>

### Example 3:

- If the fraction is 0, 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-47.png)<figcaption id="caption-attachment-14640">Example 3</figcaption>

## **Verdict:**

In this tutorial, we guided you to learn the usage of **Excel DOLLARFR Function in Office 365** with its syntax, explanation, and examples. Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)**Keep Learning!!

### Read Ahead:

- [How to Use Excel QUARTILE.EXC Function in Office 365?](https://geekexcel.com/how-to-use-excel-quartile-exc-function-in-office-365/)
- [How to Use Excel TRIMMEAN Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-trimmean-function-in-office-365-with-examples/)