Please note javascript is required for full website functionality.
MVP

Blog

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

Newsletter