If all of the input arguments evaluate to TRUE, then the formula returns TRUE as the end result. However, if any of the input arguments evaluate to FALSE, the formula returns FALSE as an output.<\/p>\n
In other words, all logical expressions need to be true for AND to return TRUE.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
AND function Syntax<\/h2>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
=AND(logical_expression1, [logical_expression2, \u2026])<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- logical_expression1<\/b> \u2013 an expression that evaluates as TRUE or FALSE. IT can also be a reference to the cell that contains a logical expression.<\/li>\n
- [logical_expression2, \u2026]<\/b> \u2013 these are optional expressions for the function to evaluate.<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to use the AND function<\/h2>\n
Let\u2019s try various combinations of input arguments within the AND formula and examine the results.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-AND-formula-1.png” alt=”google sheets AND formula 1″ title_text=”google sheets AND formula 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You may have already guessed that the first two examples, each with a single expression, aren\u2019t that useful to us.<\/p>\n
It is interesting to note that the AND function works even with numbers as input. In this case, it simply evaluates them as FALSE if they are zero or TRUE for any other value. Check out the examples below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-AND-formula-2.png” alt=”google sheets AND formula 2″ title_text=”google sheets AND formula 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
The AND function also takes a range of cells as an input, as shown below.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-AND-formula-3.png” alt=”google sheets AND formula 3″ title_text=”google sheets AND formula 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
While it is hard to deny the utility of the AND formula in the real world, it has limited applications as a standalone function.<\/p>\n
However, when used in conjunction with other formulas like IF<\/a>, we can see its magic coming to life. In the examples below, look at the first and third formulas. The second and fourth formulas are their alternatives. Notice how simple it gets when we use AND instead of multi-level IF formula nesting.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/11\/google-sheets-AND-formula-4.png” alt=”google sheets AND formula 4″ title_text=”google sheets AND formula 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Combining AND and FILTER functions<\/h2>\n
You can combine FILTER and AND to extract data if it meets multiple conditions.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
=FILTER(A:C, AND(A:A > 50, B:B <100))<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This formula filters the range A1:C10 to include only the rows where the values in column A are greater than 50 and the values in column B are less than 100.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
AND function with conditional formatting<\/h2>\n
Usually you can only set one condition to apply a certain formatting. But with AND you can apply multiple criteria.<\/p>\n
Just follow these simple steps:<\/p>\n
- \n
- Select the range you want to format.<\/li>\n
- Go to Format<\/b> > Conditional formatting<\/b>.<\/li>\n
- In the Custom formula is<\/b> field.<\/li>\n
- Insert the ANDfunction so the condition includes two values.<\/li>\n
- Choose the formatting style and click Done.<\/li>\n<\/ol>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
AND function<\/h3>\n
The AND function in Google Sheets is a versatile tool for evaluating multiple conditions in your data analysis.<\/p>\n
By combining it with other features you can create powerful and complex formulas to meet your specific needs.<\/p>\n
If you want a function that evaluates to TRUE if any of the conditions are met, then you need to learn about the OR function<\/a>.<\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
The AND function in Google Sheets accepts logical expressions as input arguments, then evaluates them as TRUE or FALSE. If all of the input arguments evaluate to TRUE, then the formula returns TRUE as the end result. However, if any of the input arguments evaluate to FALSE, the formula returns FALSE as an output. In […]<\/p>\n","protected":false},"author":40,"featured_media":254715,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The utility of the entire range of formulas in Google Sheets won't be complete without the AND<\/a> formula. It accepts logical expressions as input arguments, evaluates them to either a logical TRUE or FALSE. If all of the input arguments evaluate to TRUE, then the formula returns TRUE as the end result. However, if any of the input arguments evaluate to FALSE, the formula returns FALSE as an output.\n
Syntax<\/h3>\nAND(logical_expression1, [logical_expression2, ...])<\/strong><\/span>\n\nlogical_expression1<\/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\n[logical_expression2, ...]<\/strong><\/span> - these are optional and additional expressions that return a logical TRUE or FALSE.\n
Usage: AND Formula<\/h3>\nLet us try various combinations of input arguments within the AND formula and examine the results. You may have already guessed that the first two variations of the formula with single input argument, aren't that useful to us.\n\n
![\"AND](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/and1.png\")
\n\nIt is interesting to note that the AND 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![\"AND](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/and2.png\")
\n\nThe AND formula also takes a range of cells as an input argument, as illustrated in the image below.\n\n![\"AND](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/and3.png\")
\n\nWhile it is hard to deny the utility of the AND formula in the real world, probably it has a limited application as a standalone formula. However, when it is used in conjunction with other formulas like IF, we can see its magic coming to life. In the snapshot below, consider the first and third formulas. The second and fourth formulas are their alternatives. Notice how simple it gets when we use AND instead of multi-level IF formula nesting.\n\n![\"AND](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/and4.png\")
\n\n\u00a0\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2988","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2988","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=2988"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2988\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/254715"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=2988"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=2988"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=2988"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - In the Custom formula is<\/b> field.<\/li>\n
- [logical_expression2, \u2026]<\/b> \u2013 these are optional expressions for the function to evaluate.<\/li>\n<\/ul>\n