# FIXED

## Rational

Round a number to decimal places with or without commas.

## Description

The Excel FIXED function display a number in a text format after rounding the specified number of decimal places with or without commas.
For example, to round 1234.56789 to 2 digits after the decimal, use formula =FIXED(1234.56789,2,0), returns 1,234.57 (with two decimals).

## Syntax

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

## Parameters

number – Number to round
decimals [Optional] – Specify the decimal place to be rounded.
no_commas [Optional] – To display commas in the result.

## Return Value

The boolean result (True or False)

## Key Notes

• In FIXED function default value of decimal is 2 places. Linking a blank cell in decimals argument is considered as a null value, and the return value will be with no decimals.
• If no commas are required TRUE or 1 is an essential argument for the no_commas parameter of the FIXED formula otherwise FALSE or omitted (default) return the text including commas.
• You can also use the Excel ROUND formula to execute the same functionality except for the comma specification.
• In case of Negative value for the decimal argument, the return value will be in multiples. Example, with -2 and -3 as an argument, the return value of the number is rounded to closest multiple 100 and 1000 respectively and so on. In case the arguments exceed the value of a number, the return value will be ‘0’ (Zero).

Note: ROUND function return decimal position but in number format that can be part of Excel formula.

## Keep Reading Similar Functions:

### BAHTTEXT

The Excel BAHTTEXT function converts a number to Thai currency with a suffix of “Baht”. I.e., to translate \$5.50 in cell B7 =BAHTTEXT(B7) returns “ห้าบาทห้าสิบสตางค์”.

Read More »

### VALUE

The VALUE function converts valid numbers with various number formatting (number, date, \$ etc.) into a code number. E.g. “=VALUE(“31-12-2017”)” returns “43100”.

Read More »

### PROPER

The PROPER function capitalizes the first letter of each word in a given alphabetical text. I.e., =PROPER(“michael jackson”) returns “Michael Jackson”.

Read More »

### TEXT

The TEXT function allows converting a value to a specific format based on the given format codes. E.g. =TEXT(31-12-2018,”MM/DD/YYYY”) return ” 12/31/2018″.

Read More »

### DOLLAR

The DOLLAR function display a number with a dollar currency. I.e. =DOLLAR(500) returns \$500 as a currency but in a text format.

Read More »