AND Function Results The Logical formula AND asked if the data in Column C, the Net Days, is less than 120 AND if the data in Column B is greater than 5000. 2. Fill Down the Formula Select: Cell E2. Autofill the equation in Cells E3:E5. The formula in Cell E5 in this example is: =AND(C5<120,B5>5000)   What Do You See? The answer in this example is either  TRUE or FALSE. Formulas ->Function Library ->Logical ->AND Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.4. Apply conditional logic in a formula (<,>,=)