Click or drag to resize

MONTE.WHEN function

When Condition is true return Range, otherwise do nothing.

Description

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

Syntax

MONTE.WHEN(Condition, Range)

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

  • Range is a formula or reference