Excel: A Question of Balance (Page 1) 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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.


Try it: Using the Logical Function

Select Cell E1.

Type in the label: Compare

Go to Formulas ->Logical.

 

Select IF, the Logical function, from the list of options.
Formulas->Logical ->IF
What is a Logical Function? A Logical function asks a question, 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. 

 

  

 

  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