FLOOR_MATH
Rounds a number down, to the nearest integer or to the nearest multiple of significance.
Syntax
expression.FLOOR_MATH(arg1, arg2, arg3);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | The numeric value to round down. | |
| arg2 | Optional | ApiRange | ApiName | number | The multiple of significance to round down to. If it is omitted, the default value of 1 is used. | |
| arg3 | Optional | ApiRange | ApiName | number | Specifies if negative numbers are rounded towards or away from zero. If it is omitted or set to 0, negative numbers are rounded away from zero. If any other numeric value is specified, negative numbers are rounded towards zero. |
Returns
number
Example
Round a number down to the nearest integer or multiple in a spreadsheet.
// How do I round down a negative or positive number in a spreadsheet?
// Decrease a number to the nearest whole number or custom increment in a spreadsheet.
let worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
worksheet.GetRange("A1").SetValue(func.FLOOR_MATH(-5.5, 2, 1));