FLOOR.MATH (PQL  xl)
This function rounds a number down to the nearest multiple of the specified value
 Library: PQL \ Spreadsheet \ Math & Trig
 Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
 Solve: This function can be used with the Solve plugin: both as part of the objective function and constraint functions
Syntax
FLOOR.MATH(number, OPTIONAL significance, OPTIONAL mode)
Function Arguments
Name  Description  Type  Optional 
number  Number to round  Number 

significance  Number representing the rounding factor  Number  Y 
mode  Represents the direction (towards or away from 0) to round negative value  Number  Y 
Comments
This function is the same as the Microsoft Excel 'FLOOR.MATH' function  using the same inputs, logic and outputs.