The FIXED function in Excel is used to round a number to a specified number of decimal places and display the result as text. The syntax for the FIXED function is:
FIXED(number, [decimals], [no_commas])
- “number” is the number that you want to round and display as text
- “decimals” is an optional argument that specifies the number of decimal places to round to. If omitted, it defaults to 0.
- “no_commas” is an optional argument that specifies whether to display commas as thousand separators. If set to TRUE, commas are not displayed. If omitted, it defaults to FALSE, which means commas will be displayed.
For example, if you want to round the number 123.456 to two decimal places and display it as text with commas as thousand separators, you would use the following formula:
=FIXED(123.456, 2)
This would return “123.46” as the result.