πŸ“‘ How to Use And, Or, and Not in Google Sheets Query

Bookmarked How to Use And, Or, and Not in Google Sheets Query by Prashanth
Prashanth KV provides some options for complex string comparison operators in regards to the QUERY formula using the WHERE clause:

We can use the AND, OR, NOT logical operators in the Where clause in Query.Β The purpose of Where clause in Query is to return only rows that match aΒ specified condition.

To NOT select a particular condition, you can use <> or !=. This would look something like this: =QUERY(ICON,"Select B,C,A,AF,AG,AH,Z WHERE AF!='NO'")

Leave a Reply

Your email address will not be published. Required fields are marked *