Click or drag to resize

MONTE.CONDITIONAL function

Return Range when Condition is true, otherwise do nothing.

Description

This is the same as MONTE.WHEN(Condition, Range).

Syntax

MONTE.CONDITIONAL(Range, Condition)

  • Range is a formula or reference

  • Condition is a boolean value indicating whether to evaluate the second argument