MONTE.RANGE function

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


Return rows of a range during a simulation.


MONTE.RANGE(range, _cyclic)

range is a a 2-dimensional range of cells.
_cyclic is an optional boolean indicating cycling over rows.

Return the n-th row of a range on iteration n.

MONTE.RANGE allows for data driven simulations. By default a simulation stops when the last row is returned. If _cyclic is TRUE then simulation continues starting from the first row. MONTE.RANGE returns the same number of rows as the output range.