AND (&&)

In Logical functions

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

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

Parameters

Node1Node referenceRequired

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

Node2Node referenceRequired

Second input node.

Example

Typical use

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')

See also

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.