and

Logical AND. Evaluates to true if all parameters are true.

All parameters must be true/false expressions.

Syntax

and(x, y, ...)

Example

If(and(Clicks > 1000, Actions + Trans < 5), "Many clicks and few conversions", "")
If you add this function to a keyword table, the formula column outputs "Many clicks and few conversions" if the keyword has received more than 1000 clicks and fewer than five actions or transations combined.

Was this helpful?
How can we improve it?