Lesson 9

Preview

The OR Function

The OR function is great to use when you only need one condition that needs to be met in order to get a TRUE result (FIGURE 1).
OR returns a TRUE output if any its arguments evaluate to TRUE. OR returns a FALSE output only if all of its argument inputs are FALSE.

A common use for the OR function is to expand the usefulness of other functions that perform logical tests. For example, the IF function (we will cover it also) performs a logical test and returns one value if the test evaluates to TRUE and another value if the test evaluates to FALSE.

​By using the OR function as the logical test argument of the IF function, you can test many different conditions instead of just one. 

Figure 1

If any Function Argument input is TRUE, the output is TRUE.


Practice Exercise 6: Concerning the OR function, use the above table to construct arguments for each employee. Use the Insert Function dialog box to construct each argument.

​​SCENARIO: You have several patients who have received comprehensive exams and want to know who has a health condition that is Good (Blue Status) or Acceptable (Black Status).

STEP 1A: Enter data from OR table in FIGURE 2. 

STEP 1B: Make cell C2 the active cell.

Figure 2

STEP 2A: Select Insert Function. There are multiple ways to select the Insert Function.

​Option 1: Select  Icon on the Formula Bar (FIGURE 3).

Figure 3

​Option 2: From the Formulas tab, library section  (FIGURE 4).

Figure 4

STEP 3A: ​From the “Or select a category” drop-down arrow, select “Logical” (FIGURE 5).

STEP 3B: The Logical category functions will appear including the OR function. Ensure OR is highlighted. If you do not see it, scroll down. 

STEP 3C: Once visible, click it to highlight it.

STEP 3D: Select the OK button.

Figure 5

STEP 4A: (FIGURE 6) Joe’s health condition color code is in cell B2; that will be our 1st argument.
Our scenario is checking if his security color classification is anything other than blue or black.
 
STEP 4B: Enter: B2=”Blue”  ARGUMENT #1.
B2=”Black”  ARGUMENT #2 (You must enter quotes)

Figure 6

STEP 5A: Notice that as you are entering the arguments, they are also being entered into cell C2 as shown by FIGURE 7.

​STEP 5B:Select the OK button.

Figure 7

STEP 5: ​Move mouse over to the bottom-right corner of cell C2 and Autofill down through cell C6 to obtain the OR results for the other patients (FIGURE 8).

Figure 8

​STEP 6: Since Joe, John, and James  have health conditions that were within the confines of this scenario, they had a TRUE result. Tom and Susan did NOT have an acceptable health condition, thus FALSE (FIGURE 9).

END OF LESSON


Back to: Intro to Excel 2016 Data Analysis > Module 4 – Intro to Excel 2016 Data Analysis

Leave a Reply