AND: How to Check If Cell Contains Text in Google Sheets

Use AND to check if cell contains text in Google Sheets. Complete tutorial with syntax and examples.

Syntax

AND(logical_expression1, [logical_expression2, ...])

How to Check If Cell Contains Text

Returns TRUE if all arguments are TRUE. To check if cell contains text, combine AND with the right arguments for your dataset.

Expert Tips

Use inside IF: =IF(AND(A1>0, B1>0), "Both positive", "No")

Get a Free Quote →