DOLLARFR
function DOLLARFR(arg1: any = null, arg2: any = null): number | string | booleanDescription
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
Parameters
- arg1
anydefault: null Is a decimal number.
- arg2
anydefault: null Is the integer to use in the denominator of a fraction.
Returns
number | string | booleanTry It
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.DOLLARFR(1.1875, 16));