FIXED
Formulas / FIXEDFormat 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?
What are the arguments of the FIXED function?
- 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?
