MONTE.AVERAGE function

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

Description

Calculate the average of cell over a simulation.

Syntax

MONTE.AVERAGE(cell, _reset)

cell is reference to a cell whos average 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

MONTE.MEAN