Microsoft Office Tutorials and References
In Depth Information
Let’s Be Logical
7. Type a ), and press Enter.
The cell to the right of the first item displays the returned text.
8. Use the fill handle from the first cell with the formula, and drag the
formula down to all the other cells adjacent to list entries.
Let’s Be Logical
I once worked on a grammar problem that provided a paragraph with no
punctuation and asked that the punctuation be added:
That that is is not that that is not is not that it it is
The answer follows:
That that is, is not that that is not. Is not that it? It is.
So true! That that is, such as an apple, is not that that is not, such as an
orange. (Is your head spinning yet?)
NOT
NOT is a logical operator. It is used to reverse a logical value, turning true to
false or false to true.
Enter this formula into a cell:
= 5 + 5 = 10
The result is the word TRUE. Makes sense. The math checks out. Now try this:
=NOT(5 + 5 = 10)
What happens? The word false is returned.
The NOT function provides greater flexibility when designing the test
portion of a SUMIF function (which you read about in Chapter 8). Sometimes it
is easier to define what you want omitted from the sum than to define what
you want included. Figure 14-4 shows an example of how this works. The task
is to sum up all orders except those in June. Column A lists the months, and
column C lists the amounts.
Search JabSto ::




Custom Search