MAXA
function MAXA(args: number | string | boolean | [] | ApiRange = null): numberDescription
Returns the largest value in a set of values. Does not ignore logical values and text.
Parameters
Up to 255 values (number, text, logical value) for which the largest value will be returned. The first argument is required, subsequent arguments are optional.
Returns
numberTry It
const oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1:A5").GetValue();
var oFunction = Api.GetWorksheetFunction();
var maxA = oFunction.MAX(23, 45, true, "text", 0.89);
oWorksheet.GetRange("C1").SetValue(maxA);