Mathematical Functions
Function |
Description |
ABS(A) |
Returns the absolute value of A |
ACOS(A) |
Returns the arccosine of A, in radians |
ACOSH(A) |
Returns the inverse hyperbolic cosine of A, in radians |
ASIN(A) |
Returns the arcsine of A, in radians |
ASINH(A) |
Returns the inverse hyperbolic sine of A, in radians |
ATAN(A) |
Returns the arctangent of A, in radians |
ATANH(A) |
Returns the inverse hyperbolic tangent of A, in radians |
ATANTWO(A,B) |
Returns the arctangent treating A and B as x- and y-coordinates, in radians |
CEIL(A) |
Returns the nearest integer value greater than or equal to A. |
CHAR(A) |
Returns the character corresponding to the ASCII code for integer A |
COS(A) |
Returns the cosine of A, where A is in radians |
COSH(A) |
Returns the hyperbolic cosine of A, where A is in radians |
Convert a numeric value from one dimension to another. The original numeric value is A. B and C are strings which represent the current dimension and the dimension to convert to, respectively. For example, to convert 21 inches to an equivalent value in metres: CONVERT(21, “in”, “m”) = 0.5334 |
|
DEGREES(A) |
Returns the angle in degrees, where A is in radians |
EXP(A) |
Returns e raised to the power of A |
FLOOR(A) |
Returns the nearest integer value less than or equal to A. |
INT(A) |
Returns the nearest integer value to A. |
LN(A) |
Returns the natural logarithm of A |
LOG(A) |
Returns the base-10 logarithm of A |
MAX(A,B) |
Returns the larger of A or B |
MIN(A,B) |
Returns the smaller of A or B |
MOD(A,B) |
Returns the remainder after A is divided by B |
RADIANS(A) |
Returns the angle in radians, where A is in degrees |
SQRT(A) |
Returns the positive square root of A |
SIN (A) |
Returns the sine of A, where A is in radians |
SINH (A) |
Returns the hyperbolic sine of A, where A is in radians |
TAN(A) |
Returns the tangent of A, where A is in radians |
TANH(A) |
Returns the hyperbolic tangent of A, where A is in radians |