Fixed
Rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.
Syntax
FIXED(number, [decimals])
The FIXED function syntax has the following arguments:
- Number (Required) The number you want to round and convert to text.
- Decimals (Optional) The number of digits to the right of the decimal point.
Remarks
Using a negative number in [decimals] is not supported
If you omit [decimals], it is assumed to be 0.
Example
Field 1: 1234.567
Field 2: -1234.567
Field 3: 44.332
| Formula | Description | Result |
|---|---|---|
| =FIXED([Field 1], 1) | Rounds the number in Field 1 one digit to the right of the decimal point. | 1,234.6 |
| =FIXED([Field 3]) | Rounds the number in Field 3 two digits to the left of the decimal point. | 44.33 |
Updated almost 2 years ago