MONTE.MAX function

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


Return the maximum values of a cell over a simulation.


MONTE.MAX(cell, _reset)

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

Calculate the running maximum over the course of the simulation. The output can be a range that will store the the running largest values that have been generated.