FIXED Function Explained
The FIXED function in Microsoft Excel rounds a number to a specified number of decimal places and returns the result as text with a fixed number of decimals. It takes two arguments: the number to be rounded and the number of decimal places to round to. The result is formatted as text, so it will not affect any further calculations.
FIXED Function Syntax
FIXED(number, [decimals], [no_commas])
- number: The number to be rounded and displayed as text with the specified number of decimals.
- decimals: (optional) The number of digits to the right of the decimal point. If omitted, the default value is 2.
- no_commas: (optional) A logical value that specifies whether to display commas in the returned text. If omitted, the default value is FALSE.