FIXED

See also A-Z Spreadsheet Function List

Description Rounds a number to the supplied precision, formats the number in decimal format, and returns the result as text.

Syntax FIXED(number [, precision][, no_commas])

number is any number.

precision is the number of digits that appear to the right of the decimal place. When this argument is omitted, a default precision of 2 is used. If you specify negative precision, number is rounded to the left of the decimal point. You can specify a precision as great as 127 digits.

no_commas determines if thousands separators (commas) are used in the result. Use 1 to exclude commas in the result. If no_commas is 0 or the argument is omitted, thousands separators are included (e.g., 1,000.00).

See Also DOLLAR , ROUND , TEXT , and VALUE functions

Examples FIXED(2000.5, 3) returns “2,000.500”

         FIXED(2009.5, -1, 1) returns “2010”