If
Picks one of two values based on a true/false condition, equivalent to Excel's IF. Connect a condition (usually the result of a Compare or a Checkbox), then the value to use when it holds and the value to use when it doesn't.
Inputs
| Input | Accepts | Required |
|---|---|---|
Condition | Yes/No | Yes |
TrueValue | Any | Yes |
FalseValue | Any | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Any |
Example
Your bonus accrual depends on hitting plan. A Compare node checks whether total
revenue (an Aggregate over the Bookings table) is at least the $10,000,000 target.
Connect that result to Condition, a Constant of 0.05 to TrueValue, and 0.03 to
FalseValue. The If node outputs the correct accrual rate, and every calculation
downstream of it updates automatically when the quarter's numbers change.