FIXED
function FIXED(arg1: number = null, arg2: number = null, arg3: boolean = null): stringDescription
Rounds a number to the specified number of decimals and returns the result as text with or without commas.
Parameters
- arg1
numberdefault: null The number to round and convert to text.
- arg2
numberdefault: null The number of digits to the right of the decimal point. If omitted, the function will assume it to be 2.
- arg3
booleandefault: null Specifies whether do display commas in the returned text (false or omitted) or not (true).
Returns
stringTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.FIXED(1234.9, 1, false));