NOT

Reverses the logical value. Returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE.

Syntax:

NOT(logical_value)

where logical_value is the logical value to be reversed.

Example:

NOT( TRUE() )

returns FALSE

Application:

Employee Training Compliance

Let's say a company has a policy that all employees must complete a mandatory annual cybersecurity training. We want to quickly identify employees who have NOT completed the training.

Table: Employee Training Status

	Employee ID	Employee Name	Training Completed (Yes/No)	Compliance Status
	A	B	C	D
1	1001	Alice Smith	Yes	Compliant
2	1002	Bob Johnson	No	Non-Compliant
3	1003	Carol White	Yes	Compliant
4	1004	David Green	No	Non-Compliant
5	1005	Eve Brown	Yes	Compliant

Explanation:

In this table:

"Training Completed (Yes/No)" is our source data.
We want the "Compliance Status" column to tell us if an employee is not compliant (i.e., they have not completed the training).

Formula using NOT:

In cell D1 (for Alice Smith), you would enter the following formula:

IF(NOT(C1="Yes"), "Non-Compliant", "Compliant")

Let's break down the formula:

C1="Yes": This part checks if the value in cell C1 (Alice Smith's training status) is exactly "Yes".
- For Alice, this evaluates to TRUE.
- For Bob, this evaluates to FALSE.
NOT(C1="Yes"): The NOT function then reverses this logical value.
- For Alice (TRUE), NOT(TRUE) becomes FALSE.
- For Bob (FALSE), NOT(FALSE) becomes TRUE.
IF(NOT(C1="Yes"), "Non-Compliant", "Compliant"): The IF function then acts based on the result of NOT:
- If NOT(C1="Yes") is TRUE (meaning the training was not "Yes"), the IF function returns "Non-Compliant".
- If NOT(C1="Yes") is FALSE (meaning the training was "Yes"), the IF function returns "Compliant".