ROUNDDOWN
function ROUNDDOWN(arg1: number = null, arg2: number = null): number | string | booleanDescription
Rounds a number down, towards zero.
Parameters
- arg1
numberdefault: null Is any real number that you want rounded down.
- arg2
numberdefault: null Is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero or omitted, to the nearest integer.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ROUNDDOWN(3.456, 0));