Returns a number as text, to a fixed number of decimal places.
Thousand separators (commas) can optionally be included.
Fixed([Number], [DecimalPlaces], [NoCommas])
Where:
Number is the number to round
Decimal places is the number of decimal places to return
NoCommas is either 0 (zero) or 1, 0 being include commas, 1 exclude commas.
Rule | Meaning |
---|---|
Fixed(1124.03, 1, 1) | The function rounds the number 1124.03 to the defined number of decimal places (in this case; 1) and then removes all commas from the result. The result in this case is 1124.0. |
Number | DecimalPlaces | NoCommas | Outcome |
---|---|---|---|
11940.732 | 2 | 0 | 11,940.73 |
9468.257 | 2 | 1 | 9468.26 |