Reference Updated April 8, 2026

AND (&&)

Category: Logical functions

Overview

Description	Connects two inputs with the logical AND and returns true (1) if both values are true and false (0) otherwise. Use when you need a 1/0 flag that becomes true only if both inputs are true at the same time.
Syntax	`AND('Node1', 'Node2')` `'Node1' && 'Node2'`
Parameters	Node1: First input node, specified using the node name in single quotes (e.g. `'Profit'`). Node2: Second input node.

Description

Connects two inputs with the logical AND and returns true (1) if both values are true and false (0) otherwise.

Use when you need a 1/0 flag that becomes true only if both inputs are true at the same time.

Syntax

Parameters

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

This example shows that AND returns 1 only when both inputs are true at the same time. If either input is 0, the result is 0.

Input node: A

Input node: B

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

Function	When to use instead
[OR (
XOR	When exactly one of the two inputs should be true instead of requiring both inputs to be true.