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...

Formulas->Function Library->Logical ->IF Exam 77-882: Microsoft Excel 2010 Core 5. Applying Formulas and Functions 5.4. Apply conditional logic in a formula (<,>,=): IF