TRY NEW VERSION

FLOOR

FLOOR(arg1, arg2) → { number | string | boolean }

Rounds a number down to the nearest multiple of significance.

Parameters:

Name Type Description
arg1 number

Is the numeric value you want to round.

arg2 number

Is the multiple to which you want to round. Number and Significance must either both be positive or both be negative.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FLOOR(5.786, 0.7));
builder.SaveFile("xlsx", "FLOOR.xlsx");
builder.CloseFile();

Resulting document