excel Using the FIXED Function


Example

The FIXED function rounds a number to the specified number of decimals defined by the decimals parameter, formats the number in decimal format using a comma as a separator unless specified as not required defined by the parameter no_commas, and returns the result as text. The decimals parameter is optional and defaults to two decimal places. The no_commas parameter is also optional and defaults to FALSE.

For example:

=FIXED(1234.567, 1)
=FIXED(1234.567, -1)
=FIXED(1234.567, 1, TRUE)
=FIXED(1234.567)

Would return:

1,234.6
1,230
1234.6
1234.57