The IF Logical Function The Function Wizard will ask you for a Logical Test. This is the question, “Is this salary greater than the average?"   2. Try it: Enter the Logical Test Select Cell D2 (Click on the first salary). Type: > (this is the "Greater Than" sign). Select Cell D6 (Click on the cell with the Average formula). As you are working in the Function Arguments, Excel will type =IF(D2>D6) in Cell E2. Keep going... Exam 77-420 Microsoft Excel 2013 4. Apply Formulas and Functions 4.3 Apply Conditional Logic in Functions: Apply Conditional Logic in Functions (IF)

Formulas->Function Library->Logical ->IF