Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.1 Apply Functions in Formulas: Use the IF Function with Other Functions (<, >, =)

The Logical Formula Results The Logical formula IF asked if the data in Column C, the Net Days calculated from the Lookup table, was less than 60. If it was less than 60, then look up the Total in Column B. If not then, enter a zero.   2. Fill Down the Formula Select: Cell D2. Autofill this equation to Cells D3:D5.   The formula in Cell D4 in this example is: =IF(C4<60,B4,0) Formulas ->Function Library ->Logical ->IF