{"appState":{"pageLoadApiCallsStatus":true},"articleState":{"article":{"headers":{"creationTime":"2018-09-18T18:23:09+00:00","modifiedTime":"2018-09-18T18:23:09+00:00","timestamp":"2022-09-14T18:16:46+00:00"},"data":{"breadcrumbs":[{"name":"Technology","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33512"},"slug":"technology","categoryId":33512},{"name":"Software","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33618"},"slug":"software","categoryId":33618},{"name":"Microsoft Products","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33642"},"slug":"microsoft-products","categoryId":33642},{"name":"Excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"},"slug":"excel","categoryId":33644}],"title":"How to Build Excel Comparison Expressions","strippedTitle":"how to build excel comparison expressions","slug":"how-to-build-excel-comparison-expressions","canonicalUrl":"","seo":{"metaDescription":"A comparison expression — also known as a logical expression or a Boolean expression — is an expression in which you compare the items in a range or table colum","noIndex":0,"noFollow":0},"content":"A <em>comparison</em> <em>expression </em>— also known as a <em>logical expression</em> or a <em>Boolean expression</em> — is an expression in which you compare the items in a range or table column with a value you specify. In Excel, you use comparison expressions to create advanced filters for a table, as well as in functions that require criteria, such as COUNTIF, SUMIF, and AVERAGEIF.\r\n\r\nTo construct a comparison expression, you enter a comparison operator from the following table and then a value used in the comparison.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"92\"><strong>Operator</strong></td>\r\n<td width=\"145\"><strong>Name</strong></td>\r\n<td width=\"98\"><strong>Example</strong></td>\r\n<td width=\"175\"><strong>What It Matches</strong></td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">=</td>\r\n<td width=\"145\">Equals</td>\r\n<td width=\"98\">= 100</td>\r\n<td width=\"175\">Cells that contain the value 100</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><></td>\r\n<td width=\"145\">Not equal to</td>\r\n<td width=\"98\"><> 0</td>\r\n<td width=\"175\">Cells that contain a value other than 0</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">></td>\r\n<td width=\"145\">Greater than</td>\r\n<td width=\"98\">> 1000</td>\r\n<td width=\"175\">Cells that contain a value greater than 1,000</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">>=</td>\r\n<td width=\"145\">Greater than or equal to</td>\r\n<td width=\"98\">>= 25</td>\r\n<td width=\"175\">Cells that contain a value that’s equal to or greater than 25</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><</td>\r\n<td width=\"145\">Less than</td>\r\n<td width=\"98\">< 0</td>\r\n<td width=\"175\">Cells that contain a negative value</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><=</td>\r\n<td width=\"145\">Less than or equal to</td>\r\n<td width=\"98\"><= 927</td>\r\n<td width=\"175\">Cells that contain a value that’s equal to or less than 927</td>\r\n</tr>\r\n</tbody>\r\n</table>","description":"A <em>comparison</em> <em>expression </em>— also known as a <em>logical expression</em> or a <em>Boolean expression</em> — is an expression in which you compare the items in a range or table column with a value you specify. In Excel, you use comparison expressions to create advanced filters for a table, as well as in functions that require criteria, such as COUNTIF, SUMIF, and AVERAGEIF.\r\n\r\nTo construct a comparison expression, you enter a comparison operator from the following table and then a value used in the comparison.\r\n<table>\r\n<tbody>\r\n<tr>\r\n<td width=\"92\"><strong>Operator</strong></td>\r\n<td width=\"145\"><strong>Name</strong></td>\r\n<td width=\"98\"><strong>Example</strong></td>\r\n<td width=\"175\"><strong>What It Matches</strong></td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">=</td>\r\n<td width=\"145\">Equals</td>\r\n<td width=\"98\">= 100</td>\r\n<td width=\"175\">Cells that contain the value 100</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><></td>\r\n<td width=\"145\">Not equal to</td>\r\n<td width=\"98\"><> 0</td>\r\n<td width=\"175\">Cells that contain a value other than 0</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">></td>\r\n<td width=\"145\">Greater than</td>\r\n<td width=\"98\">> 1000</td>\r\n<td width=\"175\">Cells that contain a value greater than 1,000</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">>=</td>\r\n<td width=\"145\">Greater than or equal to</td>\r\n<td width=\"98\">>= 25</td>\r\n<td width=\"175\">Cells that contain a value that’s equal to or greater than 25</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><</td>\r\n<td width=\"145\">Less than</td>\r\n<td width=\"98\">< 0</td>\r\n<td width=\"175\">Cells that contain a negative value</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\"><=</td>\r\n<td width=\"145\">Less than or equal to</td>\r\n<td width=\"98\"><= 927</td>\r\n<td width=\"175\">Cells that contain a value that’s equal to or less than 927</td>\r\n</tr>\r\n</tbody>\r\n</table>","blurb":"","authors":[{"authorId":11290,"name":"Paul McFedries","slug":"paul-mcfedries","description":" <p><b>Paul McFedries</b> is a technical writer who has been authoring computer books since 1991 and has over 100 books to his credit. These books include <i>Alexa For Dummies, Amazon Fire TV For Dummies</i>, and <i>Cord Cutting For Dummies</i>. You can visit Paul on the web at www.mcfedries.com.</p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/11290"}}],"primaryCategoryTaxonomy":{"categoryId":33644,"title":"Excel","slug":"excel","_links":{"self":"https://dummies-api.dummies.com/v2/categories/33644"}},"secondaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"tertiaryCategoryTaxonomy":{"categoryId":0,"title":null,"slug":null,"_links":null},"trendingArticles":null,"inThisArticle":[],"relatedArticles":{"fromBook":[{"articleId":260049,"title":"10 Ways to Raise Your Excel PivotTable Game","slug":"10-ways-to-raise-your-excel-pivottable-game","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260049"}},{"articleId":260046,"title":"10 Ways to Analyze Financial Data Using Excel","slug":"10-ways-to-analyze-financial-data-using-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260046"}},{"articleId":260038,"title":"Plotting Trend Lines in Excel","slug":"plotting-trend-lines-in-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260038"}},{"articleId":260033,"title":"Working with Excel PivotTable Subtotals","slug":"working-with-excel-pivottable-subtotals","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260033"}},{"articleId":260028,"title":"Grouping PivotTable Values in Excel","slug":"grouping-pivottable-values-in-excel","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/260028"}}],"fromCategory":[{"articleId":288828,"title":"Excel 2021 All-in-One For Dummies Cheat Sheet","slug":"excel-2021-all-in-one-for-dummies-cheat-sheet","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/288828"}},{"articleId":265521,"title":"How to Use the XLOOKUP Function in Excel 2016","slug":"how-to-use-the-xlookup-function-in-excel-2016","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/265521"}},{"articleId":263475,"title":"Notes and File Sharing features in Excel 2016 Update","slug":"notes-and-coauthoring-features-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263475"}},{"articleId":263466,"title":"New Chart & Graphics features on Excel 2016 update","slug":"new-chart-graphics-features-on-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263466"}},{"articleId":263453,"title":"New Formulas and Functions in Excel 2016","slug":"how-to-use-new-formula-and-functions-in-excel-2016-update","categoryList":["technology","software","microsoft-products","excel"],"_links":{"self":"https://dummies-api.dummies.com/v2/articles/263453"}}]},"hasRelatedBookFromSearch":false,"relatedBook":{"bookId":281711,"slug":"excel-data-analysis-for-dummies","isbn":"9781119844426","categoryList":["technology","software","microsoft-products","excel"],"amazon":{"default":"https://www.amazon.com/gp/product/1119844428/ref=as_li_tl?ie=UTF8&tag=wiley01-20","ca":"https://www.amazon.ca/gp/product/1119844428/ref=as_li_tl?ie=UTF8&tag=wiley01-20","indigo_ca":"http://www.tkqlhce.com/click-9208661-13710633?url=https://www.chapters.indigo.ca/en-ca/books/product/1119844428-item.html&cjsku=978111945484","gb":"https://www.amazon.co.uk/gp/product/1119844428/ref=as_li_tl?ie=UTF8&tag=wiley01-20","de":"https://www.amazon.de/gp/product/1119844428/ref=as_li_tl?ie=UTF8&tag=wiley01-20"},"image":{"src":"https://www.dummies.com/wp-content/uploads/9781119844426-203x255.jpg","width":203,"height":255},"title":"Excel Data Analysis For Dummies","testBankPinActivationLink":"","bookOutOfPrint":true,"authorsInfo":"<p><b><b data-author-id=\"11290\">Paul McFedries</b></b> is a technical writer who has been authoring computer books since 1991 and has over 100 books to his credit. These books include <i>Alexa For Dummies, Amazon Fire TV For Dummies</i>, and <i>Cord Cutting For Dummies</i>. You can visit Paul on the web at www.mcfedries.com.</p>","authors":[{"authorId":11290,"name":"Paul McFedries","slug":"paul-mcfedries","description":" <p><b>Paul McFedries</b> is a technical writer who has been authoring computer books since 1991 and has over 100 books to his credit. These books include <i>Alexa For Dummies, Amazon Fire TV For Dummies</i>, and <i>Cord Cutting For Dummies</i>. You can visit Paul on the web at www.mcfedries.com.</p> ","hasArticle":false,"_links":{"self":"https://dummies-api.dummies.com/v2/authors/11290"}}],"_links":{"self":"https://dummies-api.dummies.com/v2/books/"}},"collections":[],"articleAds":{"footerAd":"<div class=\"du-ad-region row\" id=\"article_page_adhesion_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_adhesion_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844426"]}]\" id=\"du-slot-63221a8eee5f2\"></div></div>","rightAd":"<div class=\"du-ad-region row\" id=\"article_page_right_ad\"><div class=\"du-ad-unit col-md-12\" data-slot-id=\"article_page_right_ad\" data-refreshed=\"false\" \r\n data-target = \"[{"key":"cat","values":["technology","software","microsoft-products","excel"]},{"key":"isbn","values":["9781119844426"]}]\" id=\"du-slot-63221a8eeee5e\"></div></div>"},"articleType":{"articleType":"Articles","articleList":null,"content":null,"videoInfo":{"videoId":null,"name":null,"accountId":null,"playerId":null,"thumbnailUrl":null,"description":null,"uploadDate":null}},"sponsorship":{"sponsorshipPage":false,"backgroundImage":{"src":null,"width":0,"height":0},"brandingLine":"","brandingLink":"","brandingLogo":{"src":null,"width":0,"height":0},"sponsorAd":"","sponsorEbookTitle":"","sponsorEbookLink":"","sponsorEbookImage":{"src":null,"width":0,"height":0}},"primaryLearningPath":"Advance","lifeExpectancy":null,"lifeExpectancySetFrom":null,"dummiesForKids":"no","sponsoredContent":"no","adInfo":"","adPairKey":[]},"status":"publish","visibility":"public","articleId":255628},"articleLoadedStatus":"success"},"listState":{"list":{},"objectTitle":"","status":"initial","pageType":null,"objectId":null,"page":1,"sortField":"time","sortOrder":1,"categoriesIds":[],"articleTypes":[],"filterData":{},"filterDataLoadedStatus":"initial","pageSize":10},"adsState":{"pageScripts":{"headers":{"timestamp":"2024-03-04T05:50:01+00:00"},"adsId":0,"data":{"scripts":[{"pages":["all"],"location":"header","script":"\r\n<script src=\"https://cdn.optimizely.com/js/10563184655.js\"></script>","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>var _comscore = _comscore || [];_comscore.push({ c1: \"2\", c2: \"15097263\" });(function() {var s = document.createElement(\"script\"), el = document.getElementsByTagName(\"script\")[0]; s.async = true;s.src = (document.location.protocol == \"https:\" ? \"https://sb\" : \"http://b\") + \".scorecardresearch.com/beacon.js\";el.parentNode.insertBefore(s, el);})();</script><noscript><img src=\"https://sb.scorecardresearch.com/p?c1=2&c2=15097263&cv=2.0&cj=1\" /></noscript>\r\n","enabled":true},{"pages":["all"],"location":"footer","script":"\r\n<script type='text/javascript'>\r\n(function(){var g=function(e,h,f,g){\r\nthis.get=function(a){for(var a=a+\"=\",c=document.cookie.split(\";\"),b=0,e=c.length;b<e;b++){for(var d=c[b];\" \"==d.charAt(0);)d=d.substring(1,d.length);if(0==d.indexOf(a))return d.substring(a.length,d.length)}return null};\r\nthis.set=function(a,c){var b=\"\",b=new Date;b.setTime(b.getTime()+6048E5);b=\"; expires=\"+b.toGMTString();document.cookie=a+\"=\"+c+b+\"; path=/; \"};\r\nthis.check=function(){var a=this.get(f);if(a)a=a.split(\":\");else if(100!=e)\"v\"==h&&(e=Math.random()>=e/100?0:100),a=[h,e,0],this.set(f,a.join(\":\"));else return!0;var c=a[1];if(100==c)return!0;switch(a[0]){case \"v\":return!1;case \"r\":return c=a[2]%Math.floor(100/c),a[2]++,this.set(f,a.join(\":\")),!c}return!0};\r\nthis.go=function(){if(this.check()){var a=document.createElement(\"script\");a.type=\"text/javascript\";a.src=g;document.body&&document.body.appendChild(a)}};\r\nthis.start=function(){var t=this;\"complete\"!==document.readyState?window.addEventListener?window.addEventListener(\"load\",function(){t.go()},!1):window.attachEvent&&window.attachEvent(\"onload\",function(){t.go()}):t.go()};};\r\ntry{(new g(100,\"r\",\"QSI_S_ZN_5o5yqpvMVjgDOuN\",\"https://zn5o5yqpvmvjgdoun-wiley.siteintercept.qualtrics.com/SIE/?Q_ZID=ZN_5o5yqpvMVjgDOuN\")).start()}catch(i){}})();\r\n</script><div id='ZN_5o5yqpvMVjgDOuN'></div>\r\n","enabled":false},{"pages":["all"],"location":"header","script":"\r\n<script>\r\n (function(h,o,t,j,a,r){\r\n h.hj=h.hj||function(){(h.hj.q=h.hj.q||[]).push(arguments)};\r\n h._hjSettings={hjid:257151,hjsv:6};\r\n a=o.getElementsByTagName('head')[0];\r\n r=o.createElement('script');r.async=1;\r\n r.src=t+h._hjSettings.hjid+j+h._hjSettings.hjsv;\r\n a.appendChild(r);\r\n })(window,document,'https://static.hotjar.com/c/hotjar-','.js?sv=');\r\n</script>","enabled":false},{"pages":["article"],"location":"header","script":" <script src=\"//get.s-onetag.com/bffe21a1-6bb8-4928-9449-7beadb468dae/tag.min.js\" async defer></script>","enabled":true},{"pages":["homepage"],"location":"header","script":"<meta name=\"facebook-domain-verification\" content=\"irk8y0irxf718trg3uwwuexg6xpva0\" />","enabled":true},{"pages":["homepage","article","category","search"],"location":"footer","script":"\r\n<noscript>\r\n<img height=\"1\" width=\"1\" src=\"https://www.facebook.com/tr?id=256338321977984&ev=PageView&noscript=1\"/>\r\n</noscript>\r\n","enabled":true}]}},"pageScriptsLoadedStatus":"success"},"navigationState":{"navigationCollections":[{"collectionId":287568,"title":"BYOB (Be Your Own Boss)","hasSubCategories":false,"url":"/collection/for-the-entry-level-entrepreneur-287568"},{"collectionId":293237,"title":"Be a Rad Dad","hasSubCategories":false,"url":"/collection/be-the-best-dad-293237"},{"collectionId":295890,"title":"Career Shifting","hasSubCategories":false,"url":"/collection/career-shifting-295890"},{"collectionId":294090,"title":"Contemplating the Cosmos","hasSubCategories":false,"url":"/collection/theres-something-about-space-294090"},{"collectionId":287563,"title":"For Those Seeking Peace of Mind","hasSubCategories":false,"url":"/collection/for-those-seeking-peace-of-mind-287563"},{"collectionId":287570,"title":"For the Aspiring Aficionado","hasSubCategories":false,"url":"/collection/for-the-bougielicious-287570"},{"collectionId":291903,"title":"For the Budding Cannabis Enthusiast","hasSubCategories":false,"url":"/collection/for-the-budding-cannabis-enthusiast-291903"},{"collectionId":299891,"title":"For the College Bound","hasSubCategories":false,"url":"/collection/for-the-college-bound-299891"},{"collectionId":291934,"title":"For the Exam-Season Crammer","hasSubCategories":false,"url":"/collection/for-the-exam-season-crammer-291934"},{"collectionId":301547,"title":"For the Game Day Prepper","hasSubCategories":false,"url":"/collection/big-game-day-prep-made-easy-301547"}],"navigationCollectionsLoadedStatus":"success","navigationCategories":{"books":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/books/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/books/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/books/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/books/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/books/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/books/level-0-category-0"}},"articles":{"0":{"data":[{"categoryId":33512,"title":"Technology","hasSubCategories":true,"url":"/category/articles/technology-33512"},{"categoryId":33662,"title":"Academics & The Arts","hasSubCategories":true,"url":"/category/articles/academics-the-arts-33662"},{"categoryId":33809,"title":"Home, Auto, & Hobbies","hasSubCategories":true,"url":"/category/articles/home-auto-hobbies-33809"},{"categoryId":34038,"title":"Body, Mind, & Spirit","hasSubCategories":true,"url":"/category/articles/body-mind-spirit-34038"},{"categoryId":34224,"title":"Business, Careers, & Money","hasSubCategories":true,"url":"/category/articles/business-careers-money-34224"}],"breadcrumbs":[],"categoryTitle":"Level 0 Category","mainCategoryUrl":"/category/articles/level-0-category-0"}}},"navigationCategoriesLoadedStatus":"success"},"searchState":{"searchList":[],"searchStatus":"initial","relatedArticlesList":[],"relatedArticlesStatus":"initial"},"routeState":{"name":"Article4","path":"/article/technology/software/microsoft-products/excel/how-to-build-excel-comparison-expressions-255628/","hash":"","query":{},"params":{"category1":"technology","category2":"software","category3":"microsoft-products","category4":"excel","article":"how-to-build-excel-comparison-expressions-255628"},"fullPath":"/article/technology/software/microsoft-products/excel/how-to-build-excel-comparison-expressions-255628/","meta":{"routeType":"article","breadcrumbInfo":{"suffix":"Articles","baseRoute":"/category/articles"},"prerenderWithAsyncData":true},"from":{"name":null,"path":"/","hash":"","query":{},"params":{},"fullPath":"/","meta":{}}},"dropsState":{"submitEmailResponse":false,"status":"initial"},"profileState":{"auth":{},"userOptions":{},"status":"success"}}

How to Build Excel Comparison Expressions

By: Paul McFedries and

Updated: 09-18-2018

From The Book: Excel Data Analysis For Dummies

Excel Data Analysis For Dummies

Explore Book Buy On Amazon

A comparison expression — also known as a logical expression or a Boolean expression — is an expression in which you compare the items in a range or table column with a value you specify. In Excel, you use comparison expressions to create advanced filters for a table, as well as in functions that require criteria, such as COUNTIF, SUMIF, and AVERAGEIF.

To construct a comparison expression, you enter a comparison operator from the following table and then a value used in the comparison.

Operator	Name	Example	What It Matches
=	Equals	= 100	Cells that contain the value 100
<>	Not equal to	<> 0	Cells that contain a value other than 0
>	Greater than	> 1000	Cells that contain a value greater than 1,000
>=	Greater than or equal to	>= 25	Cells that contain a value that’s equal to or greater than 25
<	Less than	< 0	Cells that contain a negative value
<=	Less than or equal to	<= 927	Cells that contain a value that’s equal to or less than 927

About This Article

This article is from the book:

Excel Data Analysis For Dummies ,

About the book author:

Paul McFedries is a technical writer who has been authoring computer books since 1991 and has over 100 books to his credit. These books include Alexa For Dummies, Amazon Fire TV For Dummies, and Cord Cutting For Dummies. You can visit Paul on the web at www.mcfedries.com.

This article can be found in the category:

Excel ,

Article Categories

Book Categories

Collections