Filter
Top Products
Using mathematical functions 11-9
TANH Hyperbolic tangent.
TANH(value)
ALOG Antilogarithm (exponential). This is more accurate than
10^x due to limitations of the power function.
ALOG(value)
EXP Natural exponential. This is more accurate than due
to limitations of the power function.
EXP(value)
EXPM1 Exponent minus 1 : . This is more accurate than
EXP when x is close to zero.
EXPM1(value)
LNP1 Natural log plus 1 : ln(x+1). This is more accurate than
the natural logarithm function when x is close to zero.
LNP1(value)
List functions
These functions work on list data. See “List functions” on
page 14-6.
Loop functions
The loop functions display a result after evaluating an
expression a given number of times.
ITERATE Repeatedly for #times evaluates an expression in terms of
variable. The value for variable is updated each time,
starting with initialvalue.
ITERATE(expression, variable, initialvalue,
#times)
Example
ITERATE(X
2
,X,2,3) returns 256
e
x
e
x
1–