and

Returns True if all parameters are true

Syntax

and(x, y, ...)

Parameters

All parameters must be true or false expressions.

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 5 actions or transactions combined.

Related links

• Use functions in custom columns
• if
• or
• not
• if_error
• is_error
• if_not_finite
• is_not_finite