WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » NOT Excel Function

NOT Excel Function

NOT Function in Excel

NOT Excel function is a logical function in excel which is also called negation function, it negates the value which is returned through a function or a value from another logical function, this is an inbuilt function in excel which takes a single argument which is the logic which can be a formula or a logical value.

Syntax

NOT Function Formula

Compulsory Parameter:

  • Logical: it is numeric value 0 is considered false and the rest of the values considered as true. Logical is an expression that either calculates the TRUE or FALSE. If will return TRUE if the expression is FALSE and return FALSE if the expression is TRUE.

Examples

You can download this NOT Function Excel Template here – NOT Function Excel Template

Example #1

Here we have to check which value is greater than to 100; then we use the NOT function in the Logical test column, and it will return the reverse return if the value is greater than 100, then it will return FALSE, and if the value is less than or equal to 100, it will return the TRUE as output.

Example 1

Example #2

Let consider one another example wherein we have to exclude the color combination of Red Blue from the set of Toys data; then, we can use the NOT to filter out this combination. The output will be True because here the color is Red.

Example #3

Let take the employee data wherein we have to find out the bonus amount for employees who did the extra task and no bonus for whom did not perform the extra task, and employees get 100 Rs. for each extra task done them.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example 3

The output will be = 7500 Rs. As it will first check for a blank entry in a cell, if not blank, then it will multiply the extra task and 100 to calculate the extra bonus unlocked by the employee.

Example #4

Suppose we have to perform a check on colors such as for the below example, we have to filter out the toy name having the color Blue or Red r from the given set of data.Example 4

First, this will check the condition if the color column contains any toy with the color blue or red if the condition is true, then it will return blank as output; if not true, then it will return x as output.

Recommended Articles

This has been a guide to NOT Function in Excel. Here we discuss how to use the NOT excel function along with Examples and downloadable excel templates. You may also look at these useful functions in excel –

  • VBA Not Function
  • Excel Mathematical Function
  • Error Handling in VBA
  • Excel Recording Macros
  • Hide Formula in Excel
10 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download NOT Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More