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:
Examples:
SIGMOID(1) = 0.26894142
SIGMOID(D14) = .5, where D14 = 0
SIGMOID(T5) = 1.026188e-10, where T5 = 23.
Excel function: N/A