Excel Functions Tutorials
- Excel Formulas Cheatsheet
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- Date and Time Function in Excel
- Statistical Function in Excel
NOT in Excel (Table of Contents)
NOT Function in Excel
NOT function is a logical function in Excel. It returns the opposite value of a given logical value in the formula. NOT in Excel helps to check that one value is equal to another value or not. If we put TRUE in NOT in Excel it returns False, it we put False then it returns True. We can use either TRUE or FLASE value in NOt in Excel at a time. Not in Excel can be used to check if the certain condition is met or not.
NOT Formula in Excel
There is only one parameter in the NOT in Excel that is logical value.
Explanation of NOT Function in Excel
- Logical: it is numeric value 0 is considered as false and 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.
How to use NOT Function in Excel?
NOT in Excel is very simple and easy to use and can be used as worksheet function.
You can understand the working of NOT Excel function by using the below NOT Function examples.
Example of NOT in Excel #1
Let perform a logical test on the set of values by using the NOT Excel function. Here we have to check which value is greater than to 100 then we use NOT Excel function in 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.
=NOT(B4>100) and output will be TRUE
Example of NOT Function Excel #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 Excel function to filter out this combination.
=NOT(D16=”Red Blue”) output will be True because here the color is “Red”.
Example of NOT Function Excel #3
Let take a Not Function examples considering the employee data wherein we have to find out the bonus amount for employees who didthe extra task and no bonus for whom did not perform extra task and employees get 100 Rs. for each extra task done them. Then we can achieve this by using NOT Excel function.
=IF(NOT(ISBLANK(C28)), C28*100, “No bonus”)
The output will be:= 7500 Rs. As it will first check for blank entry in cell if not blank then it will multiple the extra task and 100 to calculate the extra bonus unlocked by the employee.
Example of NOT FunctionExcel #4
Suppose we have to perform a check on colors such as for the below NOT Function examples we have to filter out the toy name having the color Blue or Red r from the given set of data. Then here we can perform a logical test by using NOT Excel function to achieve the required set of result.
=IF(NOT(OR(B43=”red”,B43=”blue”)),”x”,””) and output will be x here.
First, this will check the condition if the color column contains any toy with 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.
Things to Remember About the NOT Function in Excel
Error handling #VALUE!: If the given argument is not a numeric value or logical value then NOT Excel function returns a #VALUE! Error.
You can download this NOT Excel template here – NOT Function Excel Template
This has been a guide to NOT Function in Excel. Here we discuss the NOT Formula in excel and how to use NOT excel function along with Examples and downloadable excel templates. You may also look at these useful functions in excel –