TC2000 Help SitePersonal Criteria Formulas (PCF) PCF SyntaxMathematical Operators and Functions Table

Mathematical Operators and Functions Table

Mathematical operators and functions transform or combine numeric values and indicators to return a numeric result.

Many of these operators are the same as what you learned about in school.  You can multiply, divide, add, and subtract.

Some of the other operators might be less familiar. C MOD 1 would divide price by 1 and return the remainder. So it would return just the portion after the decimal. C \ 1 uses integer division and would divide price by 1 and round to the nearest integer. The SGN() function leaves positive values and zero unchanged, but converts negative values to a positive value of the same magnitude.

We have also created the GREATEST() and LEAST() functions to allow you to find the highest or lowest numeric value out of a list of indicators and numbers of any size.

Trigonometric functions and hyperbolic functions are also a type of mathematical function, but have separate articles.

Multiply (Mathematical Operator)
v * w
v=Numeric, w=Numeric
Divide or Ratio (Mathematical Operator)
v / w
Add (Mathematical Operator)
v + w
Add (Mathematical Operator)
v ++ w
Add (Mathematical Operator)
v -- w
Subtract or Difference (Mathematical Operator)
v - w
Subtract or Difference (Mathematical Operator)
v +- w
Subtract or Difference (Mathematical Operator)
v -+ w
Integer Divide (Mathematical Operator)
v \ w
Power (Mathematical Operator)
v ^ w
Modulo (Mathematical Operator)
v MOD w
Absolute Value
ABS(w)
w=Numeric
Log Base 10 CLG(w)
Natural Exponent EXP(w)
Natural Log LOG(w)
Sign (-1, 0 or 1) - Returns -1 if w is negative, 0 if w is zero and 1 if w is positive.
SGN(w)
Square Root SQR(w)
Allows an unlimited number of arguments separated by commas and returns the argument with the highest value.
GREATEST(v, w)
v=Numeric, w=Numeric...
Allows an unlimited number of arguments separated by commas and returns the argument with the lowest value.
LEAST(v, w)
Parentheses will force an operation to perform earlier in the order.
()