MONTE.WHEN function

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


When condition is true return range, otherwise do nothing.


MONTE.WHEN(condition, range)

condition is a boolean value indicating whether to evaluate the second argument
range is a formula or reference

This function is the same as MONTE.CONDITIONAL(range, condition)."