This Excel tutorial explains how to use the Excel FIXED function with syntax and examples.
The Microsoft Excel FIXED function returns a text representation of a number rounded to a specified number of decimal places.
The syntax for the Microsoft Excel FIXED function is:
FIXED( number, [decimal_places], [no_commas] )
The FIXED function can be used in the following versions of Microsoft Excel:
The FIXED function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel FIXED function examples and explore how to use the FIXED function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following FIXED examples would return:
=FIXED(A1, 1, TRUE) Result: "1200.4" =FIXED(A1, 1, FALSE) Result: "1,200.4" =FIXED(A2, 0, TRUE) Result: "35124" =FIXED( A2, 0, FALSE) Result: "35,124" =FIXED(52.1254, 2, TRUE) Result: "52.13" =FIXED(52.1254) Result: "52.13"
(scroll to see more)