next up previous contents index
Next: SIN Up: A. Function Reference Previous: SECOND   Contents   Index


SIGMOID

Syntax: SIGMOID(X)

X = a numeric value

SIGMOID returns the value of the sigmoid function. The result is between 0 and 1. The function is given by:

\begin{displaymath}
\frac{1}{1+e^{-x}}
\end{displaymath}

Examples:

SIGMOID(1) = 0.26894142

SIGMOID(D14) = .5, where D14 = 0

SIGMOID(T5) = 1.026188e-10, where T5 = 23.

Excel function: N/A


next up previous contents index
Next: SIN Up: A. Function Reference Previous: SECOND   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003