SEQUENCE (PQL - xl)
This function rounds the specified number up to the nearest number, using the specified number of decimal places
- Library: PQL \ Spreadsheet \ Math & Trig
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
Function Arguments
Name | Description | Type | Optional |
rows | Specifies the number of rows to generate in the sequence. It is mandatory for users to specify this argument. If this argument is not provided, the #CALC! error will be returned | Number |
|
columns | Specifies the number of rows to generate in the sequence. It is mandatory for users to specify this argument. If this argument is not provided, the #CALC! error will be returned | Number | Y |
start | Specifies the starting value. If this argument is provided, the function returns values starting with the specified value. In case nothing is specified by the user, then the default value 1 is used | StringOrNumber | Y |
step | Specifies the increment value. If this argument is provided, the function returns values incremented with that specified value. In case nothing is specified by the user, then the default value 1 is used | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'SEQUENCE' function - using the same inputs, logic and outputs.