How to use AND in Google Sheets

Product Solutions Templates Resources Pricing

AND

Returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false. Learn more

Logical

The AND function in Google Sheets is a logical function that allows you to check whether multiple conditions are true. It takes one or more logical expressions as arguments and returns TRUE only if all of the expressions evaluate to TRUE. If any of the expressions evaluate to FALSE, the function returns FALSE.

The syntax for the AND function in Google Sheets is:

AND(logicalexpression1, [logicalexpression2, …])

Where:

logicalexpression1 is the first condition that you want to test. logicalexpression2, … (optional) are additional conditions that you want to test, up to a maximum of 255 conditions. For example, if you want to check whether both cell A1 and cell B1 contain a value, you can use the following formula:

=AND(ISBLANK(A1)=FALSE, ISBLANK(B1)=FALSE)

This formula uses the ISBLANK function to check whether each cell is blank, and then uses the AND function to check whether both cells contain a value. If both cells contain a value, the formula returns TRUE. If either cell is blank, the formula returns FALSE.

Visit Official Docs

Want even more from Google Sheets?

With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.

Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.

Try Softr now and build your custom web apps in 10 minutes – no code required!

Try Softr for Free