FIXED(number, decimals)
- where 'number' is the number to round, and
- 'decimals' is the number of digits after the decimal point.
FIXED() rounds a number to the specified number of decimals, and displays the result as text.
Description
FIXED(number, decimals)
FIXED(4567.786,1) returns 4567.8
- Calci displays an #ERROR message, if number is non-numeric.
- 'decimals' is optional. If not mentioned, Calci assumes it as '2'.
Examples
| Function | Output |
| 4567.786 | 4567.8 |
| 4567.786 | 4567.8 |
| 4567.786 | 4567.8 |
| 4567.786 | 4567.8 |