Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.3 Apply Conditional Logic in Functions: Apply Conditional Logic in Functions (IF)

The IF Function 3. Try it: Enter the Function Arguments Type: Above for the true values. Type: Below for the false values. Excel will put the quote marks (" ") around the text that you type.   Click OK to finish the formula.   The equation, as it is written, uses relative references. If you copy and paste this equation, you may not get the results that you wanted.   4. Try This: Practice the IF Formula For practice, use the Formula tools to create the IF Logical equation in Cell E3 and Cell E4.   Very good. Keep going... Formulas->Function Library->Logical ->IF