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:

$$\frac{1}{1+e^{-x}}$$

Examples:

SIGMOID(1) = 0.26894142

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

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

Excel function: N/A