AND Function in Excel: Syntax, Examples and Free Practice
AND is an Excel Logic function. Returns TRUE only if every condition given is true.
AND syntax
=AND(logical1, [logical2], ...)
Arguments
logical1: The first condition to checklogical2: An additional condition to check (optional) (optional)
When to use AND
AND is used to build decision rules directly into a spreadsheet instead of manually judging each row.
Practice AND online, free
Open the live Excel-style spreadsheet and try AND yourself. No Excel install or sign-up needed to start.
Practice AND now →AND practice questions
- A student passes only if both subject marks are 50 or more. Write Pass or Fail in D2 to…
- A person is eligible if the age is 18 or more and the city is Pune. Write Eligible or No…
- Give a Bonus only if the sales are 100000 or more and the rating is 90 or more,…
- Write Ship if the status is Paid, the quantity is above 0 and the stock is In stock.…
- Write Average if the marks are between 40 and 60 (both included), otherwise Other. Put…
- Multiply price and quantity only if both are valid numbers and the quantity is above 0.…
- A code is valid if it starts with HR, has exactly 7 characters and ends with 4 digits.…
- Write All passed in E2 if every mark in B2:B6 is 40 or more, otherwise Someone failed.
- Years of service are in B2:B7 and the rating (1 to 5) in C2:C7. An employee gets a bonus…
More Logic functions
Frequently asked questions
What does the AND function do in Excel?
Returns TRUE only if every condition given is true.
What is the syntax of AND in Excel?
The syntax is =AND(logical1, [logical2], ...). logical1: The first condition to check; logical2: An additional condition to check (optional) (optional).
Where can I practice AND online for free?
Open the free live spreadsheet on Cellgrids and try AND yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Logic functions · Excel case studies · Excel tutorials · Excel shortcuts