The Formula field supports the following operations, functions, and constants:
| Enumerations | Description |
|
+, -, *, /, \, ^ |
Basic arithmetic operators |
|
% |
Modulo (remainder) operator |
|
{x}^{y} |
x to the power of y |
|
abs({n}) |
Absolute value of n |
|
cos({n}) |
Cosine of n (in radians) |
|
sin({n}) |
Sine of n (in radians) |
|
sqr({n}) |
Square root of n |
|
tan({n}) |
Tangent of n (in radians) |
|
log({n}) |
Log base 10 of n |
|
ln({n}) |
Log base e of n |
|
atan({n}) |
Inverse tangent of n |
|
sec({n})Brightspace Learning Environment |
Secant of n |
|
cosec({n}) |
Cosecant of n |
|
cotan({n}) |
Cotangent of n |
|
Factorial({n}) |
Factorial of n, or (n!) |
|
exp |
The power of natural log (e) |
|
pi |
pi 3.14159 (accurate up to 50 decimal places) |
|
e |
e 2.71828 (accurate up to 50 decimal places) |