MONTE.RANGE function

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

Description

Return rows of a range during a simulation.

Syntax

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.