Excel 2000 in a Nutshell

Name

FIXED

Synopsis

Use FIXED to round a number to the specified number of decimal places and return a text result. If desired, the number will be formatted using commas to make it easier to read.

To Calculate

=FIXED(Number, Decimals, No_Commas)

The Number argument is required for this function. The Decimals and No_Commas arguments are optional.

No_Commas

Specifies a logical value of TRUE or FALSE that indicates whether the numeric value should have commas. If this value is FALSE or omitted, commas are used as needed.

Note

The only difference between using FIXED and the Format → Cells command is that results of the function have a text format, whereas the Format → Cells command returns a numeric value. It doesn’t matter which method you use when working with other functions because the function will automatically convert the text value to a number in order to perform calculations.

Example

Figure 18-3 illustrates how FIXED is used to round a numeric value to the specified number of decimal places. In this example, a value of 2 was specified for the Decimals argument. Since that is the default value for the argument, if the argument had been omitted the function would have rounded to two decimal places.