CellSpace/Manual (draft)
by CellWorks
Home
  
Table of Contents
  
Glossary
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);