Reference Updated April 8, 2026

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

  • OR('Node1', 'Node2')

  • 'Node1' || 'Node2'

Parameters

  • Node1: First input node, specified using the node name in single quotes (e.g. 'Profit').

  • Node2: Second input node.


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

YearValue
202517
20260
20270
20281

Input node: B

YearValue
20251
20260
20271500
20280

Formula: OR('A', 'B')

Year→ OR Result
20251
20260
20271
20281

FunctionWhen to use instead
AND (&&)When both inputs must be true at the same time instead of just one of them.
XORWhen exactly one of the two inputs should be true instead of allowing both to be true.
Was this page helpful?