Fixed
The Fixed function returns a rounded fixed point representation of a number, given an optional number of decimal places.
<Decimals> defaults to four when omitted. A negative <decimals> value rounds to the left of the decimal point.
When <no_commas> is set to true, the thousands separators are suppressed. The default is to show the thousands separators.
The rounding is maintained in subsequent calculations.
The <no_commas> setting is replaced by any of the specified number formats and is discarded in subsequent calculations.
Usage:
= Fixed(<number> [, <decimals> [, <no_commas>]])
Examples:
/* returns 12,345.6500 */
= Fixed(12345.65);
Rounding with no decimal places:
/* returns 1 */
= Fixed(2/3, 0, true);
Rounding to the left of the decimal point.
/* returns 370 */
= Fixed(367.7, -1, true);