Life is full of logical conditions. We wake up and we have two choices. Get out of the bed or again go to sleep.
Same is the case with our applications or programs in EXCEL which we create. Every decision is full of conditions which need to to fulfilled before the final execution.
But there are different types of conditions. Some are necessary and some are optional. So this article will be focusing on the conditions which are necessary i.e. have to be met at any cost for the execution of the program.
We are discussing about the AND FUNCTION in EXCEL.
AND function comes under the LOGICAL FUNCTIONS category in Excel.
AND function is very important and is going to be used a lot because of which it has become one of the very important functions in excel.
It simply behaves like the binary AND. [A separate section covers the information at the end of the article]
It checks if all the conditions are TRUE OR NOT.
IT returns TRUE if ALL THE CONDITIONS ARE TRUE and false , if any of the conditions is FALSE.
This article will discuss the purpose , syntax, use and examples of AND FUNCTION in EXCEL.
PURPOSE OF AND IN EXCEL
AND FUNCTION RETURNS TRUE IF ALL THE CONDITIONS ARE TRUE AND FALSE IF ANY OF THE GIVEN CONDITIONS IS FALSE.
If we try to analyze this function by its name “AND”, we can understand the meaning in a better way.
AND itself means together. For example, I and my friend went somewhere. It means we both went. Both conditions are true.
Similarly AND function will be true, if all conditions being tested are true.
PREREQUISITES TO LEARN AND
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Some information about the BINARY MATHEMATICS is an advantage for the use of such formulas.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
SYNTAX: AND FUNCTION
The Syntax for the function is
=AND(CONDITION 1, CONDITION 2, CONDITION 3, …… SO ON)
CONDITION1 Any condition (e.g. if any cell>12)
CONDITION2 Any condition (if any cell <45)
Atleast TWO CONDITIONS are needed. At the most, any number of conditions can be used.
EXAMPLE:AND FUNCTION IN EXCEL
STEPS TO USE AND
TWO cases have been discussed.
ONE will result in TRUE and OTHER as FALSE.
The value to be checked is present in the cell H9
We’ll put the formula in I9 as
As 40 satisfies the both conditions, the result is TRUE.
FOR CASE II
The value to be checked is present in the cell H12
We’ll put the formula in I12 as
As 60 satisfies the both conditions, the result is FALSE.
OTHER WAYS TO REACH THIS ARTICLE
OR FUNCTION, SUM FUNCTION, BINARY SUM, CHECK IF ANY OF THE CONDITION IS TRUE
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.