The Calc action calculates the formula specified in the Formula parameter.
Note the following when creating a formula:
-
Decimal numbers: Decimal numbers in the formula must be indicated with a dot (.). Example: 5.2
-
Variables: Variables can be used in the formula. The name may only contain letters (a-z). The value for the variable must be numerical.
-
Functions: You can use the following mathematical functions in the formula: abs, aCos, aCosH, aSin, aSinH, aTan, aTanH, aTanTwo, ceil, cos, cosH, degToRad, en, exp, expMOne, floor, fMod, intVal, hypot, log, logOneP, logTen, max, min, pow, radToDeg, round, sin, sinH, sqrt, tan, tanH
-
Constants: You can use the following constants in the formula: e, euler, lnPi, lnTen, lnTwo, logTenE, logTwoE, onePi, pi, piFour, piTwo, sqrtOneTwo, sqrtPi, sqrtThree, sqrtTwo, twoPi, twoSqrtPi
Parameters
|
Type |
Name |
Description |
|---|---|---|
|
TEXT |
Formula |
Specifies the formula to be calculated. |
|
KEYVALUELIST |
Variables |
Specifies the list of variables used in the formula. |
Return
|
Type |
Description |
|---|---|
|
SINGLEVALUE |
Returns the calculated result of the formula. |