Logical Functions
The most commonly-used logical functions are IF, AND, OR, and NOT.
- We use the IF function to determine if a given condition is met. A course with pass/fail grading is an example of using the IF function.
- The AND function tells you if more than one set of conditions are met or not. If everything in the set of conditions is met, you get the output TRUE. If anything in the set of conditions is not met, you get the output FALSE. For example, you can use the AND function to determine if a student passed both the midterm and final exam in a course.
- The OR function tells you if at least one of the input conditions are met. If one or more of the conditions are met, you get the output TRUE. If all conditions are not met, you get the output FALSE. For example, you can use the OR function to determine if a student passed at least one of the two courses they took.
- The NOT function changes TRUE to FALSE or FALSE to TRUE. Each of these functions has unique and has more complex input syntax than the other functions we have studied.
As you watch this tutorial, note the proper input syntax for each type of function.
Source: Renae K. Clark, https://www.youtube.com/watch?v=F30EeEWHIQo This work is licensed under a Creative Commons Attribution 3.0 License.
Last modified: Thursday, August 5, 2021, 9:39 AM