Microsoft Office Tutorials and References
In Depth Information
If the value in cell D25 is greater than 89, apply the result of A else
If the value in cell D25 is greater than 80, apply the result of B else
If the value in cell D25 is greater than 70, apply the result of C else
If the value in cell D25 is greater than 60, apply the result of D else
The formula embeds an IF function with only the True values being met and the last value
after all other logical tests are applied is F or the False value.
NOT NOT returns the reverse value of its arguments.
NOT returns the opposite of the logical value. If the logical value is False, NOT returns True. If
two cells are equal, NOT returns False. NOT can be used when evaluating two cells in lists of
information. For example, if two cells can never equal each other, NOT will return a False
logical value if the cells match. Notice the example in Figure 8.4. The first condition in cell D4 is
the logical value False and the formula returns True. The second example shows two cells
not equaling each other in cells C8 and D8 and the logical value again returns True. If cell C9
is less than D9 in the third example the logical value is False even when the condition
appears True. The last example could be used if you were planning holidays for workers
within a plant. If one employee always has to be on call, the NOT function would call out a
False logical value to notify that two employees were taking off the same week.
This is the value that can be evaluated with a True or False
condition. If True, NOT returns False, if False, NOT returns True.
Opposite return on
Tr ue mathematical tests
The NOT function can
be used when calling
out employees that
are marking weeks off
for holidays within the
same week. The logical
value returned would
False return on text values that are equal