The DOLLAR function returns a string formatted as currency from a given number value.
DOLLAR(num, places)
num: The number value to format as a string.
places: An optional number value specifying the number of places to the right, or left, of the decimal point at which rounding should occur. When rounding to the specified number of places, standard arithmetical rounding is used; if the most significant 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. |