MONTE.CDF function

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.