The 40 numeric operators and methods listed here provide a numeric output based on numeric inputs. (An input may also include text methods that provide a numeric output, such as the [text1].Length * 2 +3 formula mentioned previously.) 


Several numeric operators and methods can be combined into one complex formula you’re looking for a certain kind of output. An example is: 


Sqrt(Pow([num1],2)+Pow([num2],2))


This formula calculates the length of the hypotenuse of a right triangle.


When using two or more operator types in one formula, the order of precedence for the calculation is as follows: 

  1. Unary (such as –[num1]
  2. Multiplicative
  3. Additive
  4. Relational 


If parentheses are used, like those in methods like Max(), Min(), Truncate(), etc., the expressions within the parentheses are evaluated first.