FIXED

Formulas / FIXED
Format numbers as text with fixed decimals.
==FIXED(number, [decimals], [no_commas])
  • number - required
  • decimals - [OPTIONAL]
  • no_commas - [OPTIONAL]

Examples

  • =FIXED(A2, 1)

    This example, rounds the number in A2 one digit to the right of the decimal point, returning 1.234.6.

  • =FIXED(A2, -1)

    The Sourcetable function FIXED can also round a given number to the left of the decimal point. For example, this rounds A2 one digit to the left of the decimal point, returning 1.23.

  • =FIXED(A3, -1, TRUE)

    The Sourcetable function FIXED can also be used with the TRUE argument to round a negative number to the left of the decimal point. For example, this rounds A3 one digit to the left of the decimal point and returns -1230.

  • =FIXED(A4)

    The Sourcetable function FIXED can also be used without the argument. This example rounds A4 two digits to the left of the decimal point, returning 44.33.


Summary

The FIXED function rounds a number to a specified number of digits and formats it as text with commas and a period. The output is always in decimal format.

  • The FIXED function is useful for formatting numbers as text and returning text rather than a number.
  • The FIXED function rounds to the given number of digits and can be used to concatenate text with numbers.
  • The FIXED function can be used to format numbers and retain their numeric properties.

Frequently Asked Questions

What is the FIXED function?
The FIXED function is a numerical function that rounds numbers to the specified number of decimal places. This function is one of Sourcetable's rounding functions and is used to display a number in a fixed-decimal format.
What are the arguments of the FIXED function?
The FIXED function requires two arguments:
  • Number: This argument is required and must be in decimal format.
  • Decimals: This argument is optional and determines the number of decimal places that the returned value should have.
  • No_commas: This argument is optional. If it is set to TRUE, commas will not be included in the returned value.
What is the result of the FIXED function?
The FIXED function returns a text value as the result. The result is rounded to the left of the decimal point.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV