1. Logical operations
In this chapter you'll learn to work with logical values, namely TRUE and FALSE.
2. The opposite of true
The simplest logical operation is to change a TRUE value to FALSE, or FALSE to TRUE. This is done using the NOT() function. Just as you would say in English, FALSE is NOT TRUE and TRUE is NOT FALSE.
3. This and that
There are two logical operations that accept multiple inputs. The AND() function returns TRUE when all of its inputs are TRUE, and FALSE when any of its inputs are FALSE.
4. One or the other
The OR() function also accepts multiple inputs. It returns TRUE when any of its inputs are TRUE, and FALSE when all of its inputs are FALSE.
5. Summary
To summarize, there are three logical operations. NOT() turns TRUE into FALSE and FALSE into TRUE. AND() returns TRUE when all its inputs are TRUE, and OR() returns TRUE when any of its inputs are TRUE.
6. Let's get logical!
Let's get logical!