USDOLLAR


Description Returns the specified number as text using the US Dollar format and the supplied precision. Omitting the precision argument assumes two decimal places.

Syntax USDOLLAR ( number [, precision] )
Argument Description
number A number, a formula that evaluates to a number, or a reference to a cell that contains a number.
[precision] Optional. A value representing the number of decimal places to the right of the decimal point. If this argument is omitted, 2 is used.

Examples This function returns $1023.79:

USDOLLAR(1023.789)

This function returns $500:

USDOLLAR(495.301, -2)

See Also DOLLAR, FIXED, TEXT, VALUE