What is the AND function in Excel? Usage, simple example

Excel is a tool quite familiar to many people. One of the basic and widely used functions of Excel is the AND function. In this article, lassho.edu.vn will help you learn more about the AND function and its applications!

See now the software that is on SHOCKING discount

What is the AND function in Excel? The syntax of the AND function in Excel

The AND function is one of the basic logical functions in Excel, used to determine if all conditions in a test are true. The AND function is rarely used alone, but is often used in conjunction with functions that perform other logical tests, especially the IF function.

See also: SUMIF . function

Example how to use the AND function in specific excel

Let’s take a look at the specific example below to better understand how to use the AND function in Excel:

Example: Check for true/false condition

Describe:

• Formula 1 (cell B6): Displays TRUE if the value at A2 is greater than 5 and less than 30, otherwise displays FALSE
• Formula 2 (cell B7): Display TRUE if the value at A2 is greater than 5 and less than 10, otherwise display FALSE
• Formula 3 (cell B8): Displays TRUE if the value at A3 is greater than the value at A2 and less than 45, otherwise displays FALSE

How to use the AND function in combination with the IF . function

The AND function is often used in conjunction with the IF function to consider multiple logics at once.

Consider a specific example:

Classify students based on theoretical points and practical scores. If both the theoretical and practical scores are greater than or equal to 5 , the student is graded PASS , and if the score is less than 5 , the student is NO .

Step 1:

– First, enter the following formula in cell E4 : =IF(AND(C4>=5,D4>=5),”Pass”,”FAIL”).

* With C4 , D4 is the column position of the first student’s practice and theory scores in the list, respectively.

Explain:

• Practice score >=5 is written as C4>=5
• Theoretical score >=5 is written as D4>=5
• These two assets have an AND relationship, so are placed in the same AND . function
• The PASS/FAIL grading criteria are enclosed in quotation marks (” “)

Step 2: Then press Enter , you will see the result that the first student has a practice score of 6 greater than 5, but a theoretical score of 4.5 is less than 5, so it is classified as FAIL, satisfied with the test requirements. mentioned.

Step 3: Click on the result at E4 and then move the mouse to the lower right corner of the cell so that the mouse pointer changes to the plus sign (+). Then, hold and drag the mouse to the position you want to apply to the remaining cells, or double click to apply the formula to the entire cell in the column, we will get the result as shown in the figure.

Above are instructions for you to use the AND function in Excel. Hope this article will help you use Excel more quickly and efficiently!