Supported arithmetic operators
Operator | Meaning | Example |
+ (plus sign) | Addition | 3+3 |
- (minus sign) | Subtraction | 3-1 |
* (asterisk) | Multiplication | 3*3 |
X (upper- or lowercase) | Multiplication | 3x3 |
/ (forward slash) | Division | 3/3 |
% (percent sign) | Percent | 20% |
^ (caret) | Exponentiation | 3^2 |
! (exclamation) | Factorial computation | 5! |
Supported math and trigonometry functions
Function | Description | Syntax |
ABS | Returns the absolute value of a number | ABS(number) |
ACOS | Returns the arccosine of a number | ACOS(number) |
ASIN | Returns the arcsine of a number | ASIN(number) |
ATAN | Returns the arctangent of a number | ATAN(number) |
COS | Returns the cosine of a number | COS(number) |
DEG | Converts an angle (in radians) to degrees | DEG(angle) |
LN | Returns the natural logarithm of a number | LN(number) |
LOG | Returns the natural logarithm of a number | LOG(number) |
LOG2 | Returns the base-2 logarithm of a number | LOG2(number) |
LOG10 | Returns the base-10 logarithm of a number | LOG10(number) |
MOD | Returns the remainder of a division operation | (number)MOD(number) |
PI | Returns the value of π as a constant | PI |
PHI | Returns the value of Φ (the golden ratio) | PHI |
PMT | Calculates a loan payment based on a constant interest rate, a constant number of payments, and the present value of the total amount | PMT(rate;nper;pv) |
RAD | Converts an angle (in degrees) to radians | RAD(angle) |
SIN | Returns the sine of the given angle | SIN(angle) |
SQRT | Returns a positive square root | SQRT(number) |
TAN | Returns the tangent of a number | TAN(number) |
No comments:
Post a Comment