How to use AND Function in Microsoft Excel

Microsoft's Excel program allows you to build spreadsheets with mathematical formulas that adjust data according to your instructions on an ongoing basis.

In this artical we describes the Formula syntax and usage of the "AND" function in Microsoft Excel. 

Open Microsoft Excel on your Computer.

 

     1. Click On :New" at the left side

     2. And click on the "Create" button at the Rightside

Enter information and Data in the cells that you will Requires  in "AND"  Fuction.

• Enter the numbers in cells B2 through B16 of the worksheet.
• the number enter are  91, 67,32, 76, 98,66, 45, 77,88,57,48,28,23,48,85 and 67.

Entering the formula “=AND(B2<100,B2>33)” in cell B14.

The AND Formula/Function will return TRUE if all condition are TRUE

Hit "Enter" to See the Result.

Look for the small box with a plus(+) sign that pops up near the bottom of those cells. Click the arrow and choose "Fill Formatting Only." This will copy the type of formula you have just used, but move the values to the correct vertical row.

End....