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) |