TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

ROUND

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

Rounds a number to a specified number of digits.

Parameters:

Name Type Description
arg1 number

Is the number you want to round.

arg2 number

Is the number of digits to which you want to round. Negative rounds to the left of the decimal point; zero to the nearest integer.

Returns:

Type
number | string | boolean

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ROUND(3.456, 2));
builder.SaveFile("xlsx", "ROUND.xlsx");
builder.CloseFile();

Resulting document