MONTE.CONDITIONAL function

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

Description

Return range when condition is true, otherwise do nothing.

Syntax

MONTE.CONDITIONAL(range, condition)

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

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