FIXED (PQL - xl)
This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text
- Library: PQL \ Spreadsheet \ Text
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
FIXED(number, OPTIONAL decimals, OPTIONAL no commas)
Function Arguments
Name | Description | Type | Optional |
number | Number to round and convert to text | Number |
|
decimals | Number of decimal places; if omitted, uses two places | Number | Y |
no commas | Logical value whether not to use commas; if omitted or FALSE, returns with commas | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'FIXED' function - using the same inputs, logic and outputs.