FLOOR (PQL - xl)
This function rounds a number down to the nearest multiple of a specified value
- Library: PQL \ Spreadsheet \ Compatibility
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
FLOOR(number, significance)
Function Arguments
Name | Description | Type | Optional |
|---|---|---|---|
number | Number to round | Number |
|
significance | Number representing the rounding factor | Number |
|
Comments
This function is the same as the Microsoft Excel 'FLOOR' function - using the same inputs, logic and outputs.