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.

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.

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: