Logical Functions: NOT

The NOT function returns the opposite answer: changes FALSE to TRUE or vice versa.

 
Before You Begin: Add Another Column

Select Column H.

Go to Home->Cells->Insert.

There should a new, blank Column G.

 

1. Try it: Create a Logical Formula
Select Cell G1 and type: Won't Pay in 30.
Select Cell G1 and format the label BOLD.

Select Cell G2.
Go to Formulas->Function Library ->Logical.
Click on NOT.

What Do You See? Microsoft Excel will prompt you to fill in the Arguments.
Logical1: C5=30


2. Fill Down the Formula
Select: Cell G2.
Autofill the equation in Cells G3:G5.
The answer should be FALSE or TRUE.

Formulas ->Function Library ->Logical ->NOT

Exam 77-882: Microsoft Excel 2010 Core

5. Applying Formulas and Functions

5.4. Apply conditional logic in a formula (<,>,=)