Usually, the NOT function is used in conjunction with other formulas such as IF, OR, or AND to build a comprehensive formula that can answer multiple conditions at the same time. This makes it a valuable formula to use in situations where you need to compare more than two conditions at once. For example, let\u2019s say we\u2019re calculating whether the sales team members are viable for a commission and bonus. We can use the NOT function to test whether they negate a certain income level or a certain number of accounts – if they provide a FALSE result for either one of the two, they can receive their commission. If they provide a FALSE result for both, they\u2019re entitled to the bonus too.<\/p>\n
Let\u2019s explore the NOT function further and how you can use it in Google Sheets.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
What is the NOT function?<\/h2>\n
The NOT function is quite a simple formula as there are only two possible variations.<\/p>\n
Either it takes a logical TRUE as input and returns a FALSE, or it consumes a logical FALSE for input and returns a TRUE.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula.png” alt=”NOT function 0″ title_text=”NOT formula” align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The formula also provides a response when we provide numbers as the input argument. It still returns a logical TRUE or FALSE regardless.<\/p>\n
A zero is converted to logical FALSE and a non-zero a logical TRUE.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula-\u2013-1.png” alt=”NOT function 1″ title_text=”NOT formula \u2013 1″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Syntax<\/h3>\n
The syntax for the NOT function is as follows:<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.16″ border_width_left=”4px” global_colors_info=”{}” theme_builder_area=”post_content”]=NOT(logical_expression)[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- logical_expression:<\/b> is an expression that evaluates to a logical TRUE or FALSE. This can be a direct expression or a reference to the cell that represents a logical expression<\/li>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Please note:<\/b> When using the NOT function on its own, it will only accept one input argument. This is because there is no way of negating two or more logical values together. They must be separated by something else.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to use the NOT function in Google Sheets<\/h3>\n
On its own<\/h4>\n
Although the NOT function may not be that helpful in most situations when used on its own, it\u2019s a good formula to use when determining a negative action.<\/p>\n
For example, let\u2019s say we\u2019ve added a promotion to a product but users must have had an account for more than 1 year to be eligible. We can negate users with accounts less than a year old by obtaining a logical FALSE result with the following formula:<\/p>\n
=NOT(B2<12)<\/b><\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula-\u2013-2.png” alt=”NOT function 2″ title_text=”NOT formula \u2013 2″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
As you can see, those who have had an account for more than 12 months are eligible for the promotion!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
In conjunction with other formulas<\/h4>\n
The NOT function can also be used in conjunction with other formulas, such as OR, AND or IF. This allows us to compare multiple conditions at the same time in just one formula. If you\u2019re not familiar with these other formulas, take a look at our other articles on spreadsheet functions such as How to use the nested IF statement<\/a>.<\/p>\n
Let\u2019s take the example mentioned earlier and create a formula using the AND, OR, IF and NOT functions at the same time. If a salesperson exceeds the sales goal OR the account goal, they receive a commission. If a salesperson exceeds the sales goal AND the account goal, they get the bonus. The NOT function can be used to actually calculate the answers themselves, rather than just providing either a TRUE or FALSE return.<\/p>\n
Firstly let\u2019s determine which of the sales team members are eligible for commission using a formula containing IF,OR and NOT.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula-\u2013-3.png” alt=”NOT function 3″ title_text=”NOT formula \u2013 3″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
To determine which salespeople receives a commission, I must use the following formula:<\/p>\n
=IF(OR(NOT(B11<$B$2),NOT(C11<$B$5)),B11*$B$3,0)<\/b><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- If a salesperson has more than $12,500 in sales, they receive a 1.5% commission<\/li>\n
- OR, if a salesperson has more than 10 accounts, they receive a 1.5% commission<\/li>\n
- If they have neither, the value returns as 0.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here are the results:<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula-\u2013-4.png” alt=”NOT function 4″ title_text=”NOT formula \u2013 4″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]As you can see, the salespeople that have either exceeded the sales goal or the accounts goal have received their commission.<\/p>\n
Now let\u2019s determine which salespeople can receive a bonus. To do this, we need to incorporate the AND formula:<\/p>\n
=IF(AND(NOT(B11<$B$2),NOT(C11< B5)),B6,0)<\/strong><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- If a salesperson has more than $12,500 in sales AND they have more than 10 accounts, they receive the $750 bonus<\/li>\n
- If they do not fulfill both, the value returns as 0.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Here are the results:<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/NOT-formula-\u2013-5.png” alt=”NOT function 5″ title_text=”NOT formula \u2013 5″ align=”center” _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
As you can see here, only those who have both exceeded the sales AND account goals will receive their bonus.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
NOT function in Google Sheets<\/h3>\n
And there you have it! The NOT function can be extremely helpful in negating logical values or expressions, especially when combined with other spreadsheet formulas.<\/p>\n
If you would like to learn more about different formulas and functions in Google Sheets<\/a> and also in Excel, take a look at our related blog posts below!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.4.8″ background_color=”#f9f9ff” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n
\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
There are scenarios when using Google Sheets where we may need a tool to negate a logical value or expression. The NOT function does exactly that. It returns FALSE if the input argument evaluates to TRUE and returns TRUE if the input argument evaluates to FALSE. Usually, the NOT function is used in conjunction with […]<\/p>\n","protected":false},"author":41,"featured_media":37736,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"At times in Google Sheets we may need a tool to negate a logical value or expression. The NOT<\/a> formula does exactly that. It returns FALSE if the input argument evaluates to TRUE and returns TRUE if the input argument evaluates to FALSE.\n
Syntax<\/h3>\nNOT(logical_expression)<\/strong><\/span>\n\nlogical_expression<\/strong><\/span> - is an expression that evaluates to a logical TRUE or FALSE. This can be a direct expression, or a reference to the cell that represents a logical expression\n\nPlease note that the NOT formula accepts only one input argument, and rightly so. Because, there is no logical way of negating two or more logical values together.\n
Usage: NOT Formula<\/h3>\nBy and large, there are only two possible variations of the NOT formula. Either it takes in a logical TRUE as input and returns a FALSE, or it consumes a logical FALSE for input and returns a TRUE.\n\n
![\"NOT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/not1.png\")
\n\nIt is interesting to note that the NOT formula works even when we provide numbers as the input arguments. What happens when the Google Sheets application encounters a number when it is expecting a logical TRUE or FALSE? It simply converts them to a logical TRUE or FALSE. A zero is converted to FALSE and a non-zero to TRUE. Doesn't really matter if the numbers contain decimals. Please see the examples in the snapshot below.\n\n![\"NOT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/not2.png\")
\n\nIt can not only take singular logical values as input arguments, but it also accepts logical expressions as shown in the snapshot below.\n\n![\"NOT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/not3.png\")
\n\nWhile it is hard to deny the utility of the NOT formula in the real world, probably it has a limited application as a standalone formula. However, it can get very handy if we use it in conjunction with other formulas like OR, AND and IF etc. Please consider the examples in the following snapshot - using NOT formula will flip the output of the IF formula as it is inverting the logical value.\n\n![\"NOT](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/not4.png\")
","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-3008","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3008","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=3008"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3008\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/37736"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=3008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=3008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=3008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}