[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

DOLLARDE

Syntax:

DOLLARDE ( fractional-dollar , fraction )

Description: Converts a dollar price expressed as a fraction into a dollar price expressed as a decimal number. [Note: This function is used to convert fractional dollar numbers, such as securities prices, to decimal numbers. end note]

Arguments:

Name

Type

Description

fractional-dollar

number

The number expressed as a fraction.

fraction

number

The integer to use in the denominator of the fraction. [Example: A fractional-dollar value of m.n means m + n/fraction dollars. end example]

 

Return Type and Value: number – The dollar price expressed as a decimal number.

However, if

fraction < 0, #NUM! is returned.

fraction = 0, #DIV/0! is returned.

[Example:

DOLLARDE(1.02,16) results in 1.125
DOLLARDE(1.1,32) results in 1.3125

end example]