How to use the Excel FIXED function

The Excel FIXED function converts a number to text with fixed number of decimals, rounding as needed. The FIXED function can be useful when you want to concatenate a formatted number with other text. Note: the TEXT function is more flexible and can apply many different number formats.

Syntax: =FIXED(number, [decimals], [no_commas])

The FIXED function syntax has the following arguments:

  • Number (Required): The number you want to round and convert to text.
  • Decimals (Optional): The number of digits to the right of the decimal point.
  • No_commas (Optional): A logical value that, if TRUE, prevents FIXED from including commas in the returned text.

Example: Let’s look at some Excel FIXED function examples and explore how to use the FIXED function as a worksheet function in Microsoft Excel:

Excel FIXED - How to use the Excel FIXED function

Syntax:  =FIXED(A2,B2,C2)


Excel FIXED function - How to use the Excel FIXED function

Based on the Excel spreadsheet above, the following FIXED examples would return:

Syntax: =FIXED(A3,B3,C3)
Result: 245

Syntax: =FIXED(A4,B4,C4)
Result: 245

Syntax: =FIXED(A5,B5,C5)
Result: 125.000

Syntax: =FIXED(A6,B6,C6)
Result: 245.25

Add a Comment

Your email address will not be published. Required fields are marked *