Syntax<\/h3>\n
OR(logical_expression1, [logical_expression2, \u2026])<\/strong><\/span><\/p>\n logical_expression1<\/strong><\/span>\u00a0<\/span>\u2013 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.<\/p>\n [logical_expression2, \u2026]<\/strong><\/span>\u00a0<\/span>\u2013 these are optional and additional expressions that return a logical TRUE or FALSE.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Let us try\u00a0<\/span>various combinations\u00a0<\/span>of input arguments within the OR formula and examine the results. You may have already guessed that the first two variations of the formula with a single input argument, aren\u2019t that useful to us.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/OR-formula-in-google-sheets-1.png” alt=”OR formula google sheets 1″ title_text=”OR formula in google sheets 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.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n It is interesting to note that the OR formula works even when we provide\u00a0<\/span>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\u2019t really matter if the numbers contain decimals. Please see the examples in the snapshot below.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/OR-formula-in-google-sheets-2-1.png” alt=”OR formula in google sheets 2″ title_text=”OR formula in google sheets 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.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The OR formula also takes\u00a0<\/span>a range of cells as an input argument, as illustrated in the image below.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/OR-formula-in-google-sheets-3.png” alt=”OR formula in google sheets 3″ title_text=”OR formula in google sheets 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.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n While it is hard to deny the utility of the OR formula in the real world, probably it has a limited application as a standalone formula. However, when it is used\u00a0<\/span>in conjunction with other formulas\u00a0like\u00a0<\/span>IF<\/a>, 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 OR instead of multi-level IF formula nesting.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/OR-formula-in-google-sheets-4.png” alt=”OR formula in google sheets 4″ title_text=”OR formula in google sheets 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.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! Use the OR formula in Google Sheets to evaluate logical expressions.<\/span><\/p>\n If you\u2019d like to learn more about the various formulas of Google Sheets, why not take a look at our blog post on the AND formula in Google Sheets<\/a>.<\/span><\/p>\n Alternatively, check out related blog posts below!<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" The\u00a0OR\u00a0formula in Google Sheets accepts\u00a0logical expressions as input arguments,\u00a0evaluates them to either a logical TRUE or FALSE. If all of the input arguments evaluate to FALSE, then the formula returns FALSE as the end result. However, if any of the input arguments evaluate to TRUE, the formula returns TRUE as an output. Syntax OR(logical_expression1, [logical_expression2, […]<\/p>\n","protected":false},"author":40,"featured_media":254715,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"The OR<\/a> formula in Google Sheets accepts logical expressions as input arguments, evaluates them to either a logical TRUE or FALSE. If all of the input arguments evaluate to FALSE, then the formula returns FALSE as the end result. However, if any of the input arguments evaluate to TRUE, the formula returns TRUE as an output.\nUsage: OR Formula in Google Sheets<\/h3>\n
OR formula<\/h3>\n
Syntax<\/h3>\nOR(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: OR Formula<\/h3>\nLet us try various combinations of input arguments within the OR 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
![\"OR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/OR1.png\")
\n\nIt is interesting to note that the OR 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![\"OR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/OR2.png\")
\n\nThe OR formula also takes a range of cells as an input argument, as illustrated in the image below.\n\n![\"OR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/or3.png\")
\n\nWhile it is hard to deny the utility of the OR 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 OR instead of multi-level IF formula nesting.\n\n![\"OR](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/or4.png\")
\n\n\u00a0\n\n\u00a0","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-2995","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\/es\/wp-json\/wp\/v2\/posts\/2995","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=2995"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/2995\/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=2995"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=2995"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=2995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}