FIXED Function in Excel

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:

FIXED Function in Excel 1

  • 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:

FIXED Function in Excel 2

Note: #VALUE! Error occurs if either of the supplied arguments are non-numeric.

previous FIXED Function in Excel                                                                                                                next FIXED Function in Excel