Example: Math functions in expressions
These are the examples of math functions in expressions.
Function | Description | Example |
ABS, Abs, or abs | Returns the absolute value of the expression. | ABS(-1.23) returns 1.23.ABS(1.23) returns 1.23. |
ARCCOS, arccos, ACOS, or acos | Returns the arc cosine of the expression in radians. | ACOS(-1.0) returns 3.14159. |
ARCSIN, arcsin, ASIN, or asin | Returns the arc sine of the expression in radians. | ARCSIN(1) returns 1.570796. |
ARCTAN, arctan, ATAN, or atan | Returns the arc tan of the expression in radians. | ATAN(-45.01) returns -1.54858. |
COS, Cos, or cos | Returns the cosine of the expression in radians. | COS(14.78) returns -0.599465. |
LOG, Log, or log | Returns the natural log of the expression. | LOG(2) returns 0.69314718 |
LOG10, Log10, or log10 | Returns the base-10 log of the parameter. | LOG10(100) returns 2. |
SIN, Sin, or sin | Returns the sine of the expression in radians. | SIN(45.175643) returns 0.929607. |
SQRT, Sqrt, or sqrt | Returns the square root of an expression. | SQRT(144) returns 12. |
TAN, Tan, or tan | Returns the tangent of the expression in radians. | TAN(1) returns 1.5574077246549023. |
TRUNC, Trunc, or trunc | Returns the value of the parameter with any digits to the right of the decimal point removed. | TRUNC(10.8282) returns 10. |
POW, pow | Returns the result of raising the first value to the power of the second value. All values are converted to double-precision floating point first, and then the operation is performed. | POW(10,3) returns 1000. |
Provide Feedback