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 ex due |
| to limitations of the power function. |
| EXP(value) |
EXPM1 | Exponent minus 1 : ex – 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) |
| These functions work on list data. See “List functions” on |
| |
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(X2,X,2,3) returns 256 |
Using mathematical functions |