Supplementary Math Functions
In addition to using the functions in the math functions list, you can enter other supported math functions directly in the equation. The following table describes these other functions.
Function
Description
max
The largest number in a, b, ...
min
The smallest number in a, b, ...
sum
a + b + c + ...
mod
a modulo b
mean
Average sum (a, b, c, .../N)
(
Opening delimiter used to group a set of operations
today
Returns today’s date (number of days since 12/30/1899)
)
Closing delimiter used to group a set of operations
log
Base 2 (Natural) logarithm of a
fac
Factorial
pow10
10 raised to the power of a
sin
Sine of a
cos
Cosine of a
tan
Tangent of a
asin
Arcsine
acos
Arccosine
atan
Arctangent
sinh
Hyperbolic sine
cosh
Hyperbolic cosine
tanh
Hyperbolic tangent
coth
Hyperbolic cotangent
sech
Hyperbolic secans
cosech
Hyperbolic cosecans
arsinh
Inverse hyperbolic sine
arcosh
Inverse hyperbolic cosine
artanh
Inverse hyperbolic tangent
arcoth
Inverse hyperbolic cotangent
std
Standard deviation of a