MONTE.MEAN function

This article describes the formula syntax of the MONTE.MEAN function.


Calculate the mean of a cell over a simulation.


MONTE.MEAN(cell, _reset)

cell is reference to a cell whos mean is to be computed.
_reset is an optional boolean to reset the calculation.

Calculate the running average over the course of the simulation. If the output range has two cells then the second cell is used to store the count. This is required if the mean is _reset during a simulation.

See Also