Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.1 Apply Functions in Formulas: Logical Functions (And/Or)

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. Try This: Fill Down the Formula Select: Cell E2. Autofill this equation to 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