|
Excel: A Question of Balance
The
Function Wizard will ask you for a
Logical Test. This is our question, “Is this salary greater
than the average?" Try it:
Enter the Arguments Select D2,
the first salary Type: > Select D5,
the cell with the Average formula. Type:
Above for the true values. Type:
Below for the false values. Click OK
to finish the formula.
|
||||
|
| ||||
