{"id":1219,"date":"2018-07-02T17:10:49","date_gmt":"2018-07-02T17:10:49","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1219"},"modified":"2023-11-03T10:46:48","modified_gmt":"2023-11-03T10:46:48","slug":"not","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/not\/","title":{"rendered":"NOT function"},"content":{"rendered":"\n
The Excel NOT function is a logical function that helps you evaluate and negate the value of a given expression. It returns TRUE if the expression is FALSE, and FALSE if the expression is TRUE. In simpler terms, it flips the logical value of a statement. This can be quite useful when you need to check for the opposite condition of a specific logical test.<\/p>\n\n\n\n
NOT(logical)<\/strong><\/p>\n\n\n\n The Excel NOT function is straightforward to use. You simply need to provide a logical value or expression as an argument. Here are some examples to illustrate its use:<\/p>\n\n\n\n This formula will return FALSE<\/b> because it negates the logical value TRUE<\/b>.<\/p>\n\n\n\n Conversely, this formula will return TRUE<\/b> because it negates the logical value FALSE<\/b>.<\/p>\n\n\n\n Here, the formula checks if 5 is greater than 10, which is FALSE<\/b. Applying NOT to it will return TRUE<\/b>.<\/b><\/p>\n\n\n\n If cell A2 contains the text “Apple,” this formula will evaluate to FALSE<\/b. However, applying NOT will change it to TRUE<\/b>.<\/b><\/p>\n\n\n\n Excel NOT function can be especially handy when used in combination with other logical functions or as part of more complex formulas to manipulate and analyze data effectively.<\/p>\n","protected":false},"excerpt":{"rendered":" The Excel NOT function is a logical function that helps you evaluate and negate the value of a given expression. It returns TRUE…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
logical<\/b><\/td> The value or expression you want to negate. It should be either TRUE or FALSE or any formula or comparison that results in a logical value.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=NOT(TRUE)<\/code><\/pre>\n\n\n\n
=NOT(FALSE)<\/code><\/pre>\n\n\n\n
=NOT(5>10)<\/code><\/pre>\n\n\n\n
=NOT(A2=\"Apple\")<\/code><\/pre>\n\n\n\n