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

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 (\|\|)	When at least one of the two inputs may be true instead of requiring both to be true.
XOR	When exactly one of the two inputs should be true instead of requiring both inputs to be true.