Skip to main content

FIXED

The FIXED function rounds a number to a specified number of decimals and returns the result as text.

Syntax​

=FIXED(number, [decimals], [no_commas])

Parameters​

  • number: The number to round and convert to text
  • decimals: Optional. The number of decimal places (default is 2)
  • no_commas: Optional. TRUE to omit commas, FALSE to include them (default is FALSE)

Examples​

=FIXED(1234.5678, 2) // Returns "1,234.57"
=FIXED(1234.5678, 1, TRUE) // Returns "1234.6"
=FIXED(1234.5678, 0) // Returns "1,235"