|
Excel: A Question of Balance
The
Function Wizard will ask you for a
Logical Test. This is the question, “Is this salary greater
than the average?" 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). Go on to
the next step...
|
||||
|
| ||||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.6. Use conditional logic in a formula 3.6.1. Using IF, AND, OR, NOT, IFERROR