Logical operations are hard... NOT!

In this chapter, you will explore logical operations using unemployment data from 1972. Each row corresponds to a woman was made unemployed because their seasonal job ended.

The simplest logical operation is NOT(), which negates its input. That is, NOT(TRUE) is FALSE and NOT(FALSE) is TRUE.

Logical operations are useful for filtering datasets: you can keep only the rows where some condition is TRUE. Data filtering can be done using FILTER(), which takes two arguments. The first argument is the range of the data that you want to filter, and the second argument is the range of the logical condition to filter on.

For example, if the data (not including the header row) is in A2:E10, and the final column contains the logical condition to filter on, you would type =FILTER(A2:E10, E2:E10).