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. 
() 