Function Reference: FIXED
| Syntax | ||
| =FIXED(number,decimals,[no_commas]) | ||
| Purpose / Description | ||
| Returns a text string representing a value in a fixed number formatted text string. | ||
| Arguments | ||
| Name | Type | Description |
| number | number | A constant, reference or nested expression that provides the number whose value is to be represented as a dollar formatted text string. |
| decimals | number | An optional constant, reference or nested expression that provides a number representing the number of decimal places for rounding and presentation. A zero value or positive value allows for rounding and display of the value to the given number of decimal positions. A negative value causes the displayed value to have no decimals, but also rounds the value to the left of the decimal point, zero-filling those number positions. |
| [no_commas] | logical | An optional constant, reference or nested expression that provides a flag to indicate the result should not contain grouping symbols (commas). Defaults to FALSE if omitted. If TRUE, the text string produced contains digits, a decimal and a negative sign (if required) only. If FALSE, the text string produced contains digits, a decimal and a negative sign (if required) and thousands separators. |
| Return Values | ||
| Type | Specific Value | Description |
| text string | If the value passed to the number argument is a number or a value that can be coerced to number, the result is the formatted text string, containing a fixed decimal formatted value, to the precision given in the optional decimals argument, and with or without the grouping symbol (commas), depending upon the value of the no_commas argument. | |
| error | #VALUE! | If the value of number or decimals is not a number and cannot be coerced to a number, or if the value of no_commas is not a logical and cannot be coerced to a logical value. |
| error | Any errors referenced by arguments are returned due to propagation of error values. | |
| Notes / Comments / Advice / Warnings | ||
| Note: | The decimal and grouping symbol used depend upon the regional settings on the user's machine. Although the argument is called no_commas, the actual character included or excluded is that selected in the user's regional settings. | |
| Comment: | An option to using the FIXED function is to use the more flexible TEXT function. | |
| Examples: | Open / download sample workbook: FIXED.xlsx | |