In this article, you will learn what the AND function is and how to use it 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”.
The general formula is as below:
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.
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.
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).
Are you learning this function to visualize financial data, build a financial model, or conduct financial analysis? If so, LiveFlow may help you automate manual workflows and keep numbers updated in real-time. You can access more than fifty financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.
To learn more about LiveFlow, book a demo.
If you don’t get the right answer to your question in this article or you have other questions on logic formulas, you may find the answers in the following articles.
Should you need to learn about the IF or IFS formulas, check the following articles.
How to Use IF Function in Google Sheets
How to Use IFS Function in Google Sheets
If you want to learn about how to use the OR formula, visit the web page below.
OR Function in Google Sheets: Explained
Are you interested in what a tick box is and how to use it? Read the following post.
How to Add a Check Box in Google Sheets
You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides
Learn how to do this step-by-step in the video below 👇