MINA

function MINA(args: number | string | boolean | [] | ApiRange = null): number

Description

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

Parameters

argsnumber | string | boolean | [] | ApiRangedefault: null

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

number

Try It


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

Get Help

  • If you have any questions about ONLYOFFICE Docs, try the FAQ section first.
  • You can request a feature or report a bug by posting an issue on GitHub.
  • You can also ask our developers on ONLYOFFICE forum (registration required).