The FIXED function formats a number as text with a fixed number of decimals.
number is the number to be rounded and formatted.
precision specifies how the number is to be rounded. For instance, 2 will round the number to 2 decimal places, while -2 will round the number to 2 places to the left of the point.
commas is a logical value which determines whether the number is to have commas (TRUE) or not (FALSE or omitted).
For example:
FIXED(1234.19999, 2, TRUE) returns "1,234.20"
FIXED(1234.19999, -2, FALSE) returns "1200"
See also: