Note:FIXED
Description
FIXED 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. When this argument is omitted, 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 a precision as great as 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 the argument is omitted, 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)
Note:
If an Invalid formula syntax warning appears, check whether the comma is set as the list separator in your regional settings on the Windows Control Panel. If a different character is set as the list separator, use this character in the above examples in place of the comma. (Windows XP: Access the Windows Control Panel and select Regional and Language Options. On the Regional Options tab page, click Customize. On the Numbers tab page, check which character is the default list separator on your computer. Use this character in the above examples instead of the comma.
Also, see