Advanced Excel Statistical - FIXED Function

Description

The FIXED function rounds a number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text.

Syntax

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

Arguments

Argument Description Required/ Optional
Number The number you want to round and convert to text. Required
Decimals The number of digits to the right of the decimal point. Optional
No_commas

A logical value that,

  • if TRUE, prevents FIXED from including commas in the returned text

  • if FALSE or omitted, then the returned text includes commas as usual

 Optional

Notes

  • Numbers in Microsoft Excel can never have more than 15 significant digits, but decimals can be as large as 127.

  • If decimals is negative, number is rounded to the left of the decimal point.

  • If you omit decimals, it is assumed to be 2.

  • The major difference between formatting a cell containing a number by using a command from Ribbon and formatting a number directly with the FIXED function is that FIXED converts its result to text. A number formatted with the Cells command is still a number.

  • If Number or Decimals is non-numeric, FIXED returns #VALUE! Error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

Fixed Function
advanced_excel_statistical_functions.htm
Advertisements