NOT in Excel
NOT function is an inbuilt function that is categorized under the Logical Function, the logical function operates under a logical test. It is also called Boolean logic or function. Boolean functions are most commonly used along with or in conjunction with other functions, specifically along with conditional test functions (“IF’’ FUNCTION), to create formulas that can evaluate multiple parameters or criteria and produce desired results depending on that criteria. It is used as an individual function or as a part of the formula along with other excel functions in a cell. E.G. with AND, IF & OR function. It returns the opposite value of a given logical value in the formula, NOT function is used to reverse a logical value. If the argument is FALSE, then TRUE is returned and vice versa.
Note: Use NOT function, when you want to make sure a value is not equal to one Specific or particular value
It’s a worksheet function, it is also used as part of the formula in a cell along with other excel function
- If given with the value TRUE, the Not function returns FALSE
- If given with the value FALSE, the Not function returns TRUE
NOT Formula in Excel
Below is the NOT Formula in excel:
=NOT (logical) logical – A value that can be evaluated to TRUE or FALSE
The only parameter in the NOT function is a logical value.
The logical test or argument can be either entered directly or it can be entered as a reference to a cell that contains a logical value and it always returns the Boolean value (“TRUE” OR “FALSE”) only.
How to Use the NOT Function in Excel?
NOT Function in Excel is very simple and easy to use. Let us now see how to use NOT function in excel with the help of some examples.
Example #1 – Excel NOT Function
Here a logical test is performed on the given set of values (Student score) by using the NOT function. Here, will check which value is greater than or equal to 50.
In the table we have 2 columns, the first column contains student score & the second column is the logical test column, where NOT function is performed
Result: It will return the reverse value if the value is greater than or equal to 50, then it will return FALSE and if the lesser than or equal to 50, it will return TRUE as output.
The result will be as given below:
Example #2 – Using NOT Function with ISBLANK
logical test is performed on the H5 & H6 Cells by using the NOT Function along with ISBLANK function, here will check if cells H5 & H6 is blank OR not using NOT function along with ISBLANK in excel
OUTPUT will be TRUE.
Example #3 – NOT Function along with “IF” and “OR” Function
Here the color check is performed for the cars, in the below-mentioned table by using NOT Function along with “if” and “or” function
Here we have to sort out color “WHITE” or “RED” from the given set of data
=IF(NOT(OR(H11=”RED”,H11=”WHITE”)),”x”,””) formula is used
This logical condition is applied on a Color column containing any car with color “RED” or “WHITE”,
if the condition is true then it will return blank as output,
if not true then it will return x as output
Example #4 – VALUE! Error
It Occurs when the supplied argument is not a logical or numeric value.
Suppose, if we give a range in the logical argument
Selected the range C22:D22 in the logical argument i.e. =NOT (C22:D22)
a function returns a #VALUE error because NOT function does not allow any range and can take only a logical test or argument or one condition.
Example #5 – NOT Function for an empty cell or blank or “0”
An empty cell or blank or “0” are treated as false, therefore “NOT” function returns TRUE
Here in the cell “I23” the stored value is “0”, suppose if I apply “NOT” function with logical argument or value as “0” or “I23”, Output will be TRUE.
Example #6 – NOT Function for Decimals
When the value is decimal in a cell
Suppose if we take the argument as decimals i.e. suppose if I apply “NOT” function with logical argument or value as “225.25” or “c27”, Output will be FALSE
Example #7 – NOT Function for Negative Number
When the value is a negative number in a cell
Suppose if we take the argument as a negative number i.e. suppose if I apply “NOT” function with logical argument or value as “-4” or “H27”, Output will be FALSE
Example #8 – When the value or Reference is Boolean Input in NOT Function
When the value or reference is Boolean input (“TRUE” OR “FALSE”) in a cell.
Here in the cell “C31” the stored value is “TRUE”, suppose if I apply “NOT” function with logical argument or value as “C31” or “TRUE”, Output will be FALSE. It will be vice versa if the logical argument is “FALSE”, i.e. NOT function returns “TRUE” value as output
This has been a guide to NOT Function. Here we discuss the NOT Formula and how to use NOT function along with practical examples and downloadable excel templates. You can also go through our other suggested articles –