{"id":3638,"date":"2018-12-12T18:12:06","date_gmt":"2018-12-12T18:12:06","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3638"},"modified":"2024-03-29T14:12:05","modified_gmt":"2024-03-29T14:12:05","slug":"check-if-a-value-is-between-two-numbers","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/","title":{"rendered":"Check if a Value Is Between Two Numbers in Excel"},"content":{"rendered":"\n
Check-if-a-Value-Is-Between-Two-Numbers<\/a>Download File<\/a><\/div>\n\n\n\n

You can use the IF function to check if a value is between two values. You can also combine IF<\/a> and AND<\/a> functions in order to set multiple ranges.<\/p>\n\n\n\n

This is the formula we are going to use in our example.<\/p>\n\n\n\n

=IF(A1>3,IF(A1<6,TRUE,FALSE),FALSE)<\/pre>\n\n\n\n
This is how this formula works. It returns TRUE<\/strong> if the number is bigger than 3 and smaller than 6, otherwise, it returns FALSE<\/strong>. In our case, only two numbers: 4 and 5 meet this requirement.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
How this formula works<\/h3>\n\n\n\n
    \n
  1. Checks whether the value is bigger than 3.<\/li>\n\n\n\n
  2. If the value is bigger, check if the value is smaller than 6.<\/li>\n\n\n\n
  3. If it\u2019s smaller return TRUE<\/strong>, otherwise return FALSE<\/strong>.<\/li>\n<\/ol>\n\n\n\n
    Check if a value is between using the AND function<\/h2>\n\n\n\n
    In the previous example, we used two if functions, but we can write this formula in a different way. This time we are going to use one IF and one AND function.<\/p>\n\n\n\n
    This is what our formula looks like.<\/p>\n\n\n\n
    =IF(AND(A1>3,A1<6),TRUE,FALSE)<\/pre>\n\n\n\n
    You can even make this code shorter by using only the AND function.<\/p>\n\n\n\n
    =AND(A1>3,A1<6)<\/pre>\n\n\n\n
    This formula is much cleaner and more readable than the last one.<\/p>\n\n\n\n
    Check if a value is between multiple ranges<\/h2>\n\n\n\n
    So far, in both examples, we created formulas that check whether the value is between two numbers. Now, let\u2019s try to create a formula that will check whether a value exists in more than one range.<\/p>\n\n\n\n
    We could create this formula using only the IF function, but it would be much too complicated, that\u2019s why we are going to use both IF and AND functions, as we did in the previous example.<\/p>\n\n\n\n
    This is the formula.<\/p>\n\n\n\n
    =IF(AND(A1>3,A1<6),TRUE,AND(A1>7,A1<10))<\/pre>\n\n\n\n
    And this is the result.<\/p>\n\n\n\n
    \"\"<\/figure>\n\n\n\n
    The numbers that meet this condition are 4, 5, 8, and 9. And this is what we can see inside the worksheet.<\/p>\n\n\n\n
    How this formula works<\/h3>\n\n\n\n
      \n
    1. Checks whether the value is bigger than 3 and smaller than 6. If the value meets this criterion it returns TRUE<\/strong>.<\/li>\n\n\n\n
    2. If the value is not present in the first range, check it for the second range.<\/li>\n\n\n\n
    3. If it\u2019s not present in any of these ranges return FALSE<\/strong>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
      You can use the IF function to check if a value is between two values. You can also combine IF and AND functions…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170,190],"yoast_head":"\nCheck if a Value Is Between Two Numbers in Excel<\/title>\n<meta name=\"description\" content=\"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Check if a Value Is Between Two Numbers in Excel\" \/>\n<meta property=\"og:description\" content=\"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-12-12T18:12:06+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-29T14:12:05+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Check if a Value Is Between Two Numbers in Excel\",\"datePublished\":\"2018-12-12T18:12:06+00:00\",\"dateModified\":\"2024-03-29T14:12:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\"},\"wordCount\":352,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\",\"name\":\"Check if a Value Is Between Two Numbers in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png\",\"datePublished\":\"2018-12-12T18:12:06+00:00\",\"dateModified\":\"2024-03-29T14:12:05+00:00\",\"description\":\"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Check if a Value Is Between Two Numbers in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Check if a Value Is Between Two Numbers in Excel","description":"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/","og_locale":"en_US","og_type":"article","og_title":"Check if a Value Is Between Two Numbers in Excel","og_description":"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/","article_published_time":"2018-12-12T18:12:06+00:00","article_modified_time":"2024-03-29T14:12:05+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Check if a Value Is Between Two Numbers in Excel","datePublished":"2018-12-12T18:12:06+00:00","dateModified":"2024-03-29T14:12:05+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/"},"wordCount":352,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png","keywords":["file","pinterest"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/","url":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/","name":"Check if a Value Is Between Two Numbers in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png","datePublished":"2018-12-12T18:12:06+00:00","dateModified":"2024-03-29T14:12:05+00:00","description":"Check if a value is between two numbers in Excel using the IF and AND functions. Download the example file and learn how to apply the formula.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/12\/formula-value-between-two-numbers.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/check-if-a-value-is-between-two-numbers\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Check if a Value Is Between Two Numbers in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3638"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3638"}],"version-history":[{"count":5,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3638\/revisions"}],"predecessor-version":[{"id":13297,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3638\/revisions\/13297"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3638"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3638"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3638"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}