Financial - DOLLARDE Function

Description

The DOLLARDE 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. Fractional dollar numbers are sometimes used for security prices. The fraction part of the value is divided by an integer that you specify.

Syntax

DOLLARDE (fractional_dollar, fraction)

Arguments

Argument	Description	Required/ Optional
Fractional_dollar	A number expressed as an integer part and a fraction part, separated by a decimal symbol.	Required
Fraction	The integer to use in the denominator of the fraction.	Required

Notes

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.
If either of the specified arguments is non-numeric, DOLLARDE returns the #VALUE! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

advanced_excel_financial_functions.htm