 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
Math/Logic Functions
Returns the value of a variable with the VariableName name. You can also simply type [$VariableName] into a formula to get the value of the variable. To learn more about variables, see the Variables section.
Returns the absolute value of Value.
Examples:
Abs(-9), returns 9;
Abs(3), returns 3.
Returns the value specifying the cosine of an
angle.
Examples:
Cos(90), returns 0;
Cos(60), returns 0.5.
Returns e (exponent) raised to the power of Value.
Examples:
Exp(1), returns 2.7182.
Exp(0), returns 1;
Returns 1 if valueA operation valueB
is true;
Returns 0 if valueA operation valueB
is false.
List of operations: equal, more, less, more or equal, less or
equal.
Examples:
If(5, |more|, 3), returns 1, because 5 is greater than 3;
If(2, |equal|, 7), returns 0, because 2 is not equal to
7.
If you need advanced logical structures, please use scripts.
Returns the integer portion of a number.
Examples:
Int(1.76), returns 1
Int(-6.32), returns -7
Returns the value specifying the natural logarithm of Value.
Examples:
Log(1), returns 0
Log(2.7182), returns 1
Returns Base raised to the power of Exp.
Examples:
Pow(1, 12), returns 1
Pow(2, 3), returns 8
Returns the rounded Value to specified Precision (number of digits after the decimal point).
Examples:
Round(1.234), returns 1
Round(2.23835324, 2), returns 2.24
Round(-2.234, 2), returns -2.23
Returns the number indicating the sign of Value:
-1 if less than zero;
0 if equal to zero;
1 if greater than zero. Examples:
Sgn(-12), returns -1
Sgn(0), returns 0
Sgn(3.4), returns 1
Returns the value specifying the sine of an
angle.
Examples:
Sin(90), returns 1;
Sin(0), returns 0.
Returns the square root of a number [A1].
Examples:
Sqr(9), returns 3;
Sqr(1), returns 1.
|
