Formulas and Functions

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.
Related Topics
For related functions and additional information, see:
“FIXED” on page 313
“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