Related Tutorial: Combining the AND Function with the IF Function in Excel.
The AND function is one of Excel’s Logical functions. Like other logical functions, the AND function gives only a TRUE or FALSE answer.
To determine whether the output will be TRUE or FALSE, the AND function evaluates at least one mathematical expression located in another cell in the spreadsheet.
The syntax for the AND function is:
= AND ( logical-1 , logical-2 , ... logical-255 )
logical - refers to the cell reference that is being checked. Up to 255 logical values can be entered into the function.
Example Using Excel's AND Function:
For help with this example, see the image above.
- Enter the following data into cells D1 to D3: 78 , 110 , 45.
- Click on cell E1 - the location where the results will be displayed.
- Click on the Formulas tab.
- Choose Logical Functions from the ribbon to open the function drop down list.
- Click on AND in the list to bring up that function's dialog box.
- Click on cell D1 in the spreadsheet to enter the first cell reference in the logical1 box.
- Type < 100 after the cell reference in the logical1 box.
- Click in the box next to logical2 in the dialog box.
- Click on cell D2 in the spreadsheet to enter the second cell reference.
- Type < 100 after the cell reference in the logical2 box.
- Click in the box next to logical3 in the dialog box.
- Click on cell D3 in the spreadsheet to enter the third cell reference.
- Type < 100 after the cell reference in the logical3 box.
- Click OK.
- The value FALSE should appear in cell E1 because the data in cell D2 is greater than 100.
- The complete function = AND ( B1 < 100 , B2 < 100 , B3 < 100) appears in the formula bar above the worksheet when you click on cell E1.
- To return a value of TRUE in cell E1, type a number in cell B2 that is less than 100.
