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.
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.