FIXED Function in Excel rounds the supplied number to a specified number of decimal places and converts them into text format.
Syntax of FIXED Function in Excel:
FIXED( number, [decimals], [no_commas] )
Where,
- number – The number to be converted into text format.
- [decimal] – An optional argument that specifies the number of decimal places to be rounded off. If omitted, it takes default value as 2 and rounds off to 2 decimal places.
- [no_commas] – An optional logical argument that specifies if the value should be separated by commas.
- TRUE – Commas are not included in the resulting text;
- FALSE – Commas are included in the text.
Default value is FALSE, so if omitted Commas are included by default.
Example of FIXED Function in Excel:
Formula:
- In the first two examples [no_commas] argument is not passed to the Fixed Function so the comma will occur in the resulting text
- In the last example [no_commas] argument is TRUE so the commas does not occur in the resulting text
So the result will be
Result:
Note: #VALUE! Error occurs if either of the supplied arguments are non-numeric.