Owner manual

Chapter 11 Text Functions 3 11

“Listing of Text Functions” on page 306

“Value Types” on page 36

“The Elements of Formulas” on page 15

“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26

“Pasting from Examples in Help” on page 41

DOLLAR

The DOLLAR function returns a string formatted as a dollar amount from a given

number.

DOLLAR(num, places)

Â num: The number to be used. num is a number value.

Â places: An optional argument specifying the number of places to the right, or left,

of the decimal point at which rounding should occur. places is a number value.

When rounding to the specied number of places, standard arithmetical rounding is

used; if the most signicant digit being dropped is 5 or greater, the result is rounded

up. A negative number indicates rounding should occur to the left of the decimal

(for example, round to hundreds or thousands).

Examples

=DOLLAR(2323.124) returns $2,323.12.

=DOLLAR(2323.125) returns $2,323.13.

=DOLLAR(99.554, 0) returns $100.

=DOLLAR(12, 3) returns $12.000.

=DOLLAR(-12, 3) returns ($12.000), with parentheses indicating a negative amount.

=DOLLAR(123, -1) returns $120.