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.