TRY NEW VERSION

MINA

MINA(args) → { number }

Returns the smallest value in a set of values. Does not ignore logical values and text.

Parameters:

Name Type Description
args number | string | boolean | array | ApiRange

Up to 255 values (number, text, logical value) for which the smallest value will be returned. The first argument is required, subsequent arguments are optional.

Returns:

Type
number

Example

Copy code
builder.CreateFile("xlsx");

const oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
var minA = oFunction.MINA(23, 45, true, "text", 0.89);
oWorksheet.GetRange("C1").SetValue(minA);

builder.SaveFile("xlsx", "MINA.xlsx");
builder.CloseFile();

Resulting document