跳到主要内容

DOLLARDE

Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number.

Syntax

expression.DOLLARDE(arg1, arg2);

expression - A variable that represents a ApiWorksheetFunction class.

Parameters

NameRequired/OptionalData typeDefaultDescription
arg1RequiredApiRange | ApiName | numberA number expressed as a fraction.
arg2RequiredApiRange | ApiName | numberThe integer to use in the denominator of the fraction.

Returns

number

Example

let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.DOLLARDE(1.03, 16));