This article describes the formula syntax of the MONTE.CDF function.
Return the probabilities cell is less than or equal to 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
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.