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
1. Try it: Using the Logical Function
Type in the
Formulas ->Function Library.
the Logical function, from the list of options.