Excel Function : DOLLARDE

Download now!

Excel Function : DOLLARDE

Category

Financial

Description

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number

Microsoft Excel Reference Page

https://support.office.com/en-us/article/DOLLARDE-function-db85aab0-1677-428a-9dfd-a38476693427

Syntax and Description of the DOLLARDE Excel Function

I don't know what the syntax DOLLARDE is in the excel function. Can anybody help me? A: It seems that DOLLARDE is a custom function, based on the following screenshot: And you can check its definition here: https://www.ablebits.com/office-addins-blog/2015/12/29/excel-dollarde-function/

About DOLLARDE Excel Function

The DOLLARDE function syntax has the following arguments: Fractional_dollar: A number that represents a dollar value with a fractional component. Fraction: The number of digits to the right of the decimal point in the fractional dollar amount. The DOLLARDE function converts a dollar price expressed as a decimal into a dollar price expressed as a fraction. For example, the DOLLARDE function converts 2.15 into 2 15/100.