Arrow left
Back to guides
Google Sheets Formulas

AND Function in Google Sheets: Explained

In this article, you will learn what the AND function is and how to use it in Google Sheets.

What is the AND function in Google Sheets?

The AND formula returns “TRUE” if all of the inputs are logically true and otherwise provides “FALSE”.

So, if one or multiple arguments are not logically correct, the function returns “FALSE”. 

Your next financial spreadsheet could be right here!
100+ spreadsheet templates, from FP&A to tax planning.
Free Spreadsheet Templates

How to use the AND formula in Google Sheets

  1. Type “=AND(” or navigate to the “Insert” tab (or “Functions” icon) → “Function”“Logical”“AND”.
  2. Insert the logic(s) and expression(s) you want to test.
  3. Press the “Enter” key.
How to insert the AND function from the menu bar in Google Sheets

The general formula is as below:

=AND(logical_expression1, [logical_expression2, …])

Logical_expression1: You need to insert a logical test such as “A1=1”, ”A1<B1”, and “A1+B1=2” by manually input and/or cell reference.

Logical_expression2 (Optional): You can add more than one expression if needed.

Note: The number 0 is considered logically “FALSE” by the AND function; all other numbers (including negative numbers) are considered logically “TRUE”.

The following screenshot shows examples of the usage of the AND function.

How the AND function works in Google Sheets with examples

Level up your Google Sheets skills with our FREE LiveFlow Academy
Basic and intermediate classes live now! Earn your certificate today.
Enroll in LiveFlow Academy

How to use the AND and IF functions together in Google Sheets

The AND function is often combined with the IF function rather than used alone. As the AND formula returns “TRUE” or “FALSE”, the AND and the IF function, which needs “TRUE” or “FALSE” input to determine which value to show, go well together.

Assume that you are a manager and need to check whether your group members have test scores that meet all of the following criteria.

  1. Test A score is equal to or more than 30.
  2. Test B score is equal to or more than 30.
  3. The aggregate score of Test A and B is 110 or above.
How the AND function works with the IF function in Google Sheets with examples

The formula shown in the picture above contains the AND function containing the arguments below:

Logical_expression1: C15>=$C$10 (Test A Score 54>=30) → OK

Logical_expression2: D15>=$C$11 (Test B Score 67>=30)  → OK

Logical_expression3: E15>=$C$12 (Total Test Score 121>=110)  → OK

As for the formula in cell F15, the AND function returns “TRUE” as all requirements are met. Therefore, the IF function returns the defined value of “Yes”, the value provided when it is true.

Check this article if you want to learn about different types of references.

Lion fails to pass these exams because his total score is less than 110. Dog can’t pass either, as his TEST A score is lower than 30 (and the total score is less than 110).

Learn how LiveFlow can save you hours a month on financial reporting!
Just 30 minutes can change the way your business operates forever.
Book a Demo

Learn how to do this step-by-step in the video below 👇

Automate financial reporting with LiveFlow

Want to eliminate manual updates of your Excel & Google Sheets models?

Yes, show me how

Need help?

Our team is here to help you any time between 9am and 10pm EST.
Check Icon
Email us at:

Liked this article? Then you'll love the ones below