NOT Function in Excel Tutorial

Excel Tutorial

Introduction

The NOT function in Excel reverses a logical result. If a condition is TRUE, NOT returns FALSE. If a condition is FALSE, NOT returns TRUE.

It is useful when you want to check whether a value does not meet a particular requirement. In this tutorial, we will focus only on the NOT function through practical examples.

What Is the NOT Function in Excel?

The NOT function is a logical function that reverses the result of a condition.

  • TRUE becomes FALSE.
  • FALSE becomes TRUE.

NOT Function Syntax

=NOT(logical)

Argument:

  • logical: A condition or logical value that you want to reverse.

Practical Examples of NOT Function in Excel

Question 1: Check Whether a Student Has Not Passed

Problem Statement: A teacher wants to identify students who have scored below 40 marks.

Student Data:

Student NameMarksNot Passed
Rahul75
Priya35
Amit50
Neha28

Excel Formula (C2):

=NOT(B2>=40)

Expected Result:

Student NameMarksNot Passed
Rahul75FALSE
Priya35TRUE
Amit50FALSE
Neha28TRUE

Explanation: The condition checks whether marks are 40 or above. NOT reverses the result. Students scoring below 40 return TRUE.

Concept Covered: Reversing a numerical comparison.

Question 2: Identify Employees Who Have Not Achieved Their Sales Target

Problem Statement: A company has set a monthly sales target of ₹1,00,000 for every employee. The manager wants to identify employees who have not achieved this target.

Employee Data:

Employee NameMonthly SalesTarget Not Achieved
Rahul150000
Priya80000
Amit120000
Neha60000

Excel Formula (C2):

=NOT(B2>=100000)

Expected Result:

Employee NameMonthly SalesTarget Not Achieved
Rahul150000FALSE
Priya80000TRUE
Amit120000FALSE
Neha60000TRUE

Explanation: NOT reverses the result of the sales comparison. Employees with sales below ₹1,00,000 return TRUE.

Concept Covered: Reversing a business target condition.

Question 3: Identify Products That Are Not Active

Problem Statement: An inventory department wants to identify products whose status is not Active.

Product Data:

ProductStatusNot Active
LaptopActive
MouseInactive
KeyboardActive
MonitorInactive

Excel Formula (C2):

=NOT(B2="Active")

Expected Result:

ProductStatusNot Active
LaptopActiveFALSE
MouseInactiveTRUE
KeyboardActiveFALSE
MonitorInactiveTRUE

Explanation: Excel checks whether the product status is Active. NOT reverses the comparison, identifying products with a different status.

Concept Covered: Reversing a text comparison.

Question 4: Check Whether an Invoice Is Not Paid

Problem Statement: An accounts department wants to identify invoices whose payment status is not Paid.

Invoice Data:

Invoice IDPayment StatusNot Paid
INV101Paid
INV102Pending
INV103Paid
INV104Unpaid

Excel Formula (C2):

=NOT(B2="Paid")

Expected Result:

Invoice IDPayment StatusNot Paid
INV101PaidFALSE
INV102PendingTRUE
INV103PaidFALSE
INV104UnpaidTRUE

Explanation: The formula checks whether the payment status is Paid. NOT reverses the result, so any status other than Paid returns TRUE.

Concept Covered: Checking whether text does not match a specific value.

Question 5: Identify Employees Who Have Not Completed Required Attendance

Problem Statement: A company requires employees to complete at least 22 working days of attendance in a month. The HR department wants to identify employees who have not completed this requirement.

Employee Data:

Employee NameAttendance DaysRequirement Not Met
Rahul25
Priya20
Amit22
Neha18

Excel Formula (C2):

=NOT(B2>=22)

Expected Result:

Employee NameAttendance DaysRequirement Not Met
Rahul25FALSE
Priya20TRUE
Amit22FALSE
Neha18TRUE

Explanation: NOT reverses the attendance comparison. Employees with fewer than 22 attendance days return TRUE.

Concept Covered: Reversing an eligibility threshold.

Student Practice Tasks

Task 1: Identify Employees Below the Sales Target

The monthly sales target is ₹1,50,000.

EmployeeMonthly SalesTarget Not Achieved
Aman180000
Riya120000
Mohit90000

Use only the NOT function to identify employees who have not achieved the target.

Task 2: Identify Unavailable Products

A product is considered available when its status is Available.

ProductStatusNot Available
LaptopAvailable
MouseUnavailable
KeyboardAvailable

Use only the NOT function to identify unavailable products.

Final Student Challenge: Build an Employee Target Checker

Create an Excel sheet to identify employees who have not achieved their monthly sales targets.

Condition: The monthly sales target is ₹2,00,000.

Given Data:

Employee NameMonthly SalesTarget Not Achieved
Rahul250000
Priya180000
Amit200000
Neha150000
Karan220000

Your Challenge: Write a formula using only the NOT function to identify employees who have not achieved the target. The result should display TRUE or FALSE.

Key Takeaways

  • NOT reverses a logical result.
  • TRUE becomes FALSE, and FALSE becomes TRUE.
  • NOT accepts one logical argument.
  • It works with numerical comparisons and text comparisons.
  • It can identify records that do not satisfy a particular condition.
  • The result of NOT is always TRUE or FALSE.

Frequently Asked Questions (FAQs)

1. What is the NOT function in Excel?

The NOT function reverses a logical result. It changes TRUE to FALSE and FALSE to TRUE.

2. What is the syntax of the NOT function?

The syntax is =NOT(logical), where logical represents the condition you want to reverse.

3. Can NOT change FALSE to TRUE?

Yes. When the original condition is FALSE, NOT returns TRUE.

4. How many arguments does NOT accept?

NOT accepts one logical argument.

5. Can NOT work with text conditions?

Yes. For example, =NOT(B2="Active") checks whether a cell value is not Active.

6. Can NOT work with numerical conditions?

Yes. You can use NOT with numerical comparisons such as =NOT(B2>=100000).

7. What does NOT return in Excel?

NOT always returns either TRUE or FALSE.

8. Where is the NOT function used in real business situations?

It can identify employees below sales targets, unpaid invoices, inactive products, and students who have not passed.