General |
ABS(x) | Absolute value of x |
SQR(x) | Nonnegative square root of x |
INT(x) | The largest integer not exceeding x |
MOD(x, y) | Remainder when x is divided by y |
CEIL(x) | The smallest integer not less than x |
IP(x) | Integral part of x |
FP(x) | Fraction part of x |
ROUND(x, n) | Value of x rounded to n places of decimals |
SGN(x) | Sign of x. SGN(x)=1 when x>0, SGN(0)=0, SGN(x)=-1 when x<0 |
Exponent/Logarithm |
EXP(x) | Exponential function |
LOG(x) | Natural logarithm |
LOG2(x) | Logarithm with 2 as base |
LOG10(x) | Common logarithm |
Trigonometric |
SIN(x) | sine |
COS(x) | cosine |
TAN(x) | tangent |
CSC(x) | cosecant |
SEC(x) | secant |
COT(x) | cotangent |
ASIN(x) | arcsine, -π/2≦ASIN(x)≦π/2 |
ACOS(x) | arccosine, 0≦ACOS(x)≦π |
ATN(x) | arctangent, -π/2 < ATN(x) < π/2 |
ANGLE(x,y) | Angle formed by a half-line connecting the origin and point (x,y) and positive direction of x-axis, －π < ANGLE(x,y)≦π |
Hyperbolic |
TANH(x) | Hyperbolic tangent |
SINH(x) | Hyperbolic sine |
COSH(x) | Hyperbolic cosine |
Random number |
RND | Pseudo-random, 0≦RND < 1 |
Time |
TIME | Time in seconds elapsed from midnight of the day |
Others |
PI | Approximate value of π |
MAXNUM | Largest expressible positive number |
EPS(x) | Difference with the number just before x or just after x |
MAX(a,b) | Larger one of a and b |
MIN(a,b) | Smaller one of a and b |