Excel: Fixed Function

In Excel, the Fixed function returns a text representation of a number rounded to a specified number of decimal places.

The syntax for the Fixed function is:

Fixed( number, decimal_places, no_commas )

number is the number to round.

decimal_places is the number of decimal places to display in the result.

no_commas - If this parameter is set to TRUE, the result will not display commas. If it is set to FALSE, it will display commas in the result.

Applies To:

Excel 2007, Excel 2003, Excel XP, Excel 2000

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Fixed(A1, 1, TRUE) would return "1200.4"

=Fixed(A1, 1, FALSE) would return "1,200.4"

=Fixed(A2, 0, TRUE) would return "35124"

=Fixed( A2, 0, FALSE) would return "35,124"

=Fixed(52.1254, 2, TRUE) would return "52.13"