FIXED

Description Rounds a number to the supplied precision, formats the number in decimal format, and returns the result as text.

Syntax FIXED ( number [, precision][, no_commas] )

Argument Description

number Any number.

[precision] Optional. The number of digits that appear to the right of the decimal place. If you specify negative precision, number is rounded to the left of the decimal point. You can specify a precision as great as 127 digits. If this argument is omitted, 2 is used.

[no_commas] Optional. Determines if thousands separators (commas) are used in the result. Use 1 to exclude commas in the result. Use 0 to include thousands separators (for example, 1,000.00). If the argument is omitted, 0 is used.

Argument	Description
number	Any number.
[precision]	Optional. The number of digits that appear to the right of the decimal place. If you specify negative precision, number is rounded to the left of the decimal point. You can specify a precision as great as 127 digits. If this argument is omitted, 2 is used.
[no_commas]	Optional. Determines if thousands separators (commas) are used in the result. Use 1 to exclude commas in the result. Use 0 to include thousands separators (for example, 1,000.00). If the argument is omitted, 0 is used.

Examples This function returns 2,000.500:

FIXED(2000.5, 3)

This function returns 2010:

FIXED(2009.5, -1, 1)

See Also DOLLAR, ROUND, TEXT, VALUE