Now that we’ve covered how to build the logic of a basic formula (yes, even though it has multiple nested conditional checks, it’s still a basic formula), we’re going to look at bringing in the additional logical functions OR and AND to test for combinations of logical tests all within the same check.
To begin, we first need to understand the logic associated with both new functions, so we’ll revisit our Truth Table to illustrate how OR and AND work (Figure 8-43).
Figure 8-43. OR Truth Table
The idea behind the OR function is that if any of the values are true, the entire statement is true, and if none of them are true, the entire statement is false.
We can use the OR function to test for up to 30 different values together and, as long as at least one of them results in true, the end result will also be true.
The OR function has the following format:
It could be something as simple as the following:
|=OR(1+1=2) : result = TRUE since 1+1 does equal 2|
Or it could be more complex with a series of nested logical functions similar to our example earlier in this chapter (the OR function just puts them all together to determine if any of them results in a true result).
To explore the OR function, we’ll look at a basic business model for paychecks. For someone to receive a paycheck, there are minimum criteria that must be met; the employee should ...