[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

DOLLARFR

Syntax:

DOLLARFR ( decimal-dollar , fraction )

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

Arguments:

Name

Type

Description

decimal-dollar

number

The number expressed as a decimal.

fraction

number

The integer to use in the denominator of the fraction.

 

Return Type and Value: number – The dollar price expressed as a fractional number. [Example: A result of m.n means m + n/fraction dollars. end example]

However, if

fraction < 0, #NUM! is returned.

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

[Example:

DOLLARFR(1.125,16) results in 1.02
DOLLARFR(1.125,32) results in 1.04

end example]