Fixed

Syntax

Fixed(Number[, Decimals[, No_commas])

Parameters

Number. Number to round and convert to a text.

Decimals. Decimal places. The number of decimal places, to which the value is to be rounded. Optional parameter. The default value is 2.

No_commas. It determines whether to display decimal delimiters in the returned value. Optional parameter. Available values:

TRUE. Default value. Thousands separators in the returned value will not be displayed.
FALSE. Thousands separators in the returned value will be displayed.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It rounds a number to the specified number of decimal places and returns the result as text with or without thousands separators.

Comments

If Decimals is greater than 0, the number is rounded to the specified number of decimal places to the right of the decimal point. If Decimals is equal to 0, the number is rounded to the nearest integer. If Decimals is less than 0, the number is rounded to the left of the decimal point.

Example

Formula	Result	Description
=Fixed(20.14,-1)	20	It rounds up the 20.14 number to one character to the left of the decimal point.
=Fixed(B6,C6)	20,1	It rounds up the number from the B6 cell to the number of characters specified in the C6 cell. The B6 cell contains the 20.14 number. The C6 cell contains 1.