Think Harder
Suppose we
wanted to find out which employee salaries are greater than and which
are less than the AVERAGE.
If the salary is greater than the average,
let’s have Excel say, “Above.” If the salary is less than the average,
Excel should return with, “Below.”
This is a Conditional equation. In Excel, we would use the IF
Function.
1. Try it: Using the Logical Function
Select Cell
E1.
Type in the
label: Compare.
Select Cell E2.
Go to
Formulas ->Function Library.
Go to
Logical.
Select IF,
the Logical function, from the list of options. Keep going...
What is a Logical Function? A Logical function asks a question, and then determines if your data matches. The answers are usually binary: True or False, Yes or No. The IF function uses a test to compare your data.
