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] )
| Parameter | Description |
|---|---|
| number | Any number. |
| precision | The number of digits that appear to the right of the decimal
place. If you omit this argument, a default precision of 2 is used. If you specify negative precision, number is rounded to the left of the decimal point. You can specify precision up to 127 digits. |
| no_commas | Determines if thousands separators (commas) are used in
the result. Use 1 to exclude commas in the result. If no_commas is 0 or you omit this argument, thousands separators are included (for example, 1,000.00). |
Examples
This function returns 2,000.500:
FIXED(2000.5, 3)
This function returns 2010:
FIXED(2009.5, -1, 1)
See also