OR (||)
Category: Logical functions
Overview
Description | Connects two inputs with the logical OR and returns true (1) if at least one of the values is true and false (0) otherwise. Use when you need a 1/0 flag that becomes true as soon as at least one of two inputs is true. |
|---|---|
Syntax |
|
Parameters |
|
Examples
Typical use
This example shows that OR returns 1 when at least one of the two inputs is true. Non-zero values are treated as true, while 0 is treated as false.
Input node: A
Year | Value |
|---|---|
2025 | 17 |
2026 | 0 |
2027 | 0 |
2028 | 1 |
Input node: B
Year | Value |
|---|---|
2025 | 1 |
2026 | 0 |
2027 | 1500 |
2028 | 0 |
Formula: OR('A', 'B')
Year | → OR Result |
|---|---|
2025 | 1 |
2026 | 0 |
2027 | 1 |
2028 | 1 |