Defining a Formula

The variable is defined in Formula field. Variables can be letters for example, A, character strings or calculations using variables for example, A*2+B. This requires that the variables used in the calculation have been specified.

The acceptable characters in variable names include:

Unacceptable characters include Scandinavian characters and spaces ( ). The maximum length of a name is 16 characters.

The following mathematical operation are available:

Calculation Meaning
+ Addition
- Subtraction
* Multiplication
/ Division
abs(x) Absolute value
acos(x)  
asin(x)  
atan(x)  
cos(x)  
exp(x) Exponent function
int(x) Integer rounding
log(x) Natural logarithm
pow(x,y) x to the power of y
sin(x)  
sqrt(x) Square root
tan(x)  

The argument x and/or y can be real number or formula giving a numerical value.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)