{"id":453523,"date":"2022-05-26T18:00:54","date_gmt":"2022-05-26T15:00:54","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-comparison-operators-in-google-sheets\/"},"modified":"2022-05-26T18:00:54","modified_gmt":"2022-05-26T15:00:54","slug":"how-to-use-comparison-operators-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-comparison-operators-in-google-sheets\/","title":{"rendered":"#How to Use Comparison Operators in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2719b8dfd06\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2719b8dfd06\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-comparison-operators-in-google-sheets\/#%E2%80%9CHow_to_Use_Comparison_Operators_in_Google_Sheets%E2%80%9D\" >&#8220;How to Use Comparison Operators in Google Sheets&#8221;<\/a><ul class='ez-toc-list-level-2' ><li class='ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-comparison-operators-in-google-sheets\/#Comparison_Operators_in_Google_Sheets\" >Comparison Operators in Google Sheets<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-use-comparison-operators-in-google-sheets\/#Comparison_Operators_With_Functions\" >Comparison Operators With Functions<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h1><span class=\"ez-toc-section\" id=\"%E2%80%9CHow_to_Use_Comparison_Operators_in_Google_Sheets%E2%80%9D\"><\/span>&#8220;How to Use Comparison Operators in Google Sheets&#8221;<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" data-pagespeed-lazy-srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you need to compare values in a spreadsheet, Google Sheets gives you the standard operators to do so. You can use functions if you prefer, but if the regular symbols are for you, here\u2019s how to use them.<\/p>\n<p>You might want to see if a value is greater than, less than, or equal to another. This is especially helpful if you change your data often and need to keep track of these types of comparisons. Let\u2019s look at how to use comparison operators in Google Sheets for constants, cell references, and in mixed formulas.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>The Fastest Way to Update Data in Google Sheets<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Comparison_Operators_in_Google_Sheets\"><\/span>Comparison Operators in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Think back to math class in elementary or middle school and those comparison symbols should pop into your mind. These same symbols are available for comparing values in Google Sheets.<\/p>\n<ul>\n<li><strong>Equal To<\/strong>: =, equivalent to the EQ function<\/li>\n<li><strong>Not Equal To<\/strong>: &lt;&gt;, equivalent to the NE function<\/li>\n<li><strong>Greater Than<\/strong>: &gt;, equivalent to the GT function<\/li>\n<li><strong>Greater Than or Equal To<\/strong>: &gt;=, equivalent to the GTE function<\/li>\n<li><strong>Less Than<\/strong>: &lt;, equivalent to the LT function<\/li>\n<li><strong>Less Than or Equal To<\/strong>: &lt;=, equivalent to the GTE function<\/li>\n<\/ul>\n<p>When you compare values using these operators, the result is either True or False. And like any other formula in Google Sheets, you\u2019ll start with an equal sign.<\/p>\n<p>Here are several examples.<\/p>\n<p>To see if the value in cell A1 is equal to the value in cell B1, you can use this formula:<\/p>\n<pre>=A1=B1<\/pre>\n<p>To see if those same values are not equal to each other, you\u2019d use this formula:<\/p>\n<pre>=A1&lt;&gt;B1<\/pre>\n<p>To see if the value in cell A1 is greater than 150, you can use this formula:<\/p>\n<pre>=A1&gt;150<\/pre>\n<p>For one final example, to see if 200 is less than or equal to that in cell B1, use this formula:<\/p>\n<pre>=200&lt;=B1<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-800553\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/BasicFormulas-GoogleSheetsComparisonOperators.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Comparison operator formulas in Google Sheets\" width=\"440\" height=\"114\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>As you can see, the formulas are basic and easy to assemble. The structure is equal sign, value one, comparison operator, value two (without the commas).<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Comparison_Operators_With_Functions\"><\/span>Comparison Operators With Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can use comparison operators in Google Sheets for more than comparing two values. You\u2019ll find that they come in handy when using functions and other types of formulas as well.<\/p>\n<p>For instance, you might use COUNTIF in Google Sheets to count the number of cells that meet criteria. This is a perfect example of including a comparison operator.<\/p>\n<p>With this formula, we can count the number of cells containing values greater than 10 in the cell range A1 through A5:<\/p>\n<pre>=COUNTIF(A1:A5,\"&gt;10\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-800551\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/COUNTIF-GoogleSheetsComparisonOperators.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"COUNTIF function in Google Sheets\" width=\"400\" height=\"244\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Using another criteria-based function, SUMIF, we can add the values in that same cell range if they are less than 10 with this formula:<\/p>\n<pre>=SUMIF(A1:A5,\"&lt;10\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-800552\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/SUMIF-GoogleSheetsComparisonOperators.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"SUMIF function in Google Sheets\" width=\"400\" height=\"264\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Another function where you\u2019ll see comparison operators used is with the logical IF function. With this formula, we\u2019ll display the number 1 if the value in cell A1 is equal to No and the number 2 if it\u2019s not.<\/p>\n<pre>=IF(A1=\"No\",\"1\",\"2\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-800550\" data-pagespeed-lazy-src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2022\/04\/IF-GoogleSheetsComparisonOperators.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"IF function in Google Sheets\" width=\"420\" height=\"120\" src=\"\/pagespeed_static\/1.JiBnMqyl6S.gif\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Comparison operators in Google Sheets give you a quick and easy way to compare values. If you prefer to use the comparison functions instead, check out our how-to for those.<\/p>\n<p>And for working with other symbols in Google Sheets, look at how to use the ampersand (&amp;) for adding text or for concatenating data.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/800546\/google-sheets-comparison-operators\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;How to Use Comparison Operators in Google Sheets&#8221; When you need to compare values in a spreadsheet, Google Sheets gives you the standard operators to do so. You can use functions if you prefer, but if the regular symbols are for you, here\u2019s how to use them. You might want to see if a value&#8230;<\/p>\n","protected":false},"author":1,"featured_media":453524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-453523","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/453523","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=453523"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/453523\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/453524"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=453523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=453523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=453523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}