# A to Z of Excel Functions: the DOLLARDE Function

17 September 2018

*Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DOLLARDE function. *

** **

**The DOLLARDE function**

Whenever I see the **DOLLARDE **function, I think it should be called **DEUTSCHEMARK** (I like to leave my mark with these jokes…).

This function converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. These **fractional dollar** numbers are sometimes used for security prices.

The **fraction** part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the **fraction** part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).

This is a very different function to **DOLLAR**, which some users confuse with this function.

The **DOLLARDE **function employs the following syntax to operate:

**DOLLARDE(fractional_dollar, fraction)**

The **DOLLARDE** function has the following arguments:

**fractional_dollar:**this is required and represents a number expressed as an integer part and a**fraction**part, separated by a decimal symbol**fraction:**this is also required. This is the integer to use in the denominator of the fraction.

It should be further noted that:

- if
**fraction**is not an integer, it is truncated - if
**fraction**is less than 0,**DOLLARDE**returns the*#NUM!*error value - if
**fraction**is greater than or equal to 0 and less than 1,**DOLLARDE**returns the*#DIV/0!*error value.

Please see my example below:

*We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.*

*A full page of the function articles can be found here. *