This article describes the formula syntax of the MONTE.CDF function.
Return the probabilities cell is less than or equal to values.
MONTE.CDF(cell, values)
cell is a reference to the cell whos cumulative distribution function is to be computed. values is an array of values at which the cumulative distribution is computed.
This computes the cumulative distribution function of the empirical distribution
of variates from cell
over the course of a simulation at specified values
.
If the output range is larger than the size of values
it will use the
last cell to keep
track of the number of times this function has been called during the simulation.