By using the formula parameter math option, you have the advantage that you can combine multiple parameters and multiple different calculations in a single formula. Formulas are entered as mathematical equations, where the parameter number is represented by Pn, where n is the parameter number. Some valid formulas are:
- P1+P2
- (P1+P2)/(P4-100)
- sin(P3)/cos(P4)
The valid mathematical operators are addition, subtraction, multiplication and division, as well as the functions listed in the table below.
Function |
Explanation |
SQR |
Square function which can be used as SQR(X) |
SIN |
Sine function which can be used as SIN(X). Sin returns the sine of the angle X in radians. |
COS |
Cosine function which can be used as COS(X). COS returns the cosine of the angle X in radians |
ATAN |
ArcTangent function which can be used as ATAN(X) |
SINH |
Hyperbolic Sine function which can be used as SINH(X) |
COSH |
Hyperbolic Cosine function which can be used as COSH(X) |
COTAN |
Cotangent (1/tangent) which can be used as COTAN(X) |
TAN |
Tangent which can be used as TAN(X) |
EXP |
e raised to the power X which can be used as EXP(X) |
LN |
Natural log, which can be used as LN(X) |
LOG(x,y) |
LOG of Y with base X. With Parameter Math, Y can equal the parameter that is being converted. For example, LOG(10,P3) would convert Parameter 3 to Log Base 10. |
SQRT |
Square Root which can be used as SQRT(X) |
ABS |
absolute value, which can be used as ABS(X) |
TRUNC |
Discards the fractional part of a number. e.g. TRUNC(-3.2) is -3, TRUNC(3.2) is 3. |
CEIL |
Rounds a non integer value to the nearest integer that has a value greater than it. i.e. CEIL(-3.2) = 3, CEIL(3.2) = 4 |
FLOOR |
Rounds a non integer value to the nearest integer that has a value less than it. ie. FLOOR(-3.2) = -4, FLOOR(3.2) = 3 |
RND |
Can be used as RND(X). Generates a random INTEGER number such that 0 <= Result < X. |
INTPOW |
Can be used as INTPOW(base,exponent). The INTPOW function raises Base to an integral power. INTPOW(2, 3) = 8. Note that result of INTPOW(2, 3.4) = 8 as well |
POW |
Can be used as POW (base,exponent). The Power function raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0. |
MIN |
Can be used as MIN(A,B). Returns the value of A or B, whichever is smaller. |
MAX |
Can be used as MAX(A,B). Returns the value of A or B, whichever is larger |