DOLLAR

See also A-Z Spreadsheet Function List

Description Returns the specified number as text, using currency format and the supplied precision.

Syntax DOLLAR(number [, precision])

number is a number, a formula that evaluates to a number, or a reference to a cell that contains a number.

precision is a value representing the number of decimal places to the right of the decimal point. Omitting this argument assumes two decimal places.

See Also FIXED , TEXT , and VALUE functions

Examples DOLLAR(1023.789) returns “$1023.79”

         DOLLAR(495.301, -2) returns “$500”