O'Reilly logo

SharePoint 2010 at Work by Mark Miller

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Cousins: OR and AND

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).

OR Truth Table

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:

=OR(test1,test2,test3,...test30)

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required