{"id":1468,"date":"2018-07-04T15:05:59","date_gmt":"2018-07-04T15:05:59","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1468"},"modified":"2023-11-03T10:04:21","modified_gmt":"2023-11-03T10:04:21","slug":"isblank","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/isblank\/","title":{"rendered":"ISBLANK function"},"content":{"rendered":"\n

Excel ISBLANK Function checks if a cell is empty or blank. It returns TRUE if the cell is empty and FALSE if it contains any data. This function is useful for various tasks like data validation and conditional formatting.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

ISBLANK(value)<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n
value<\/strong><\/td>The cell or range of cells you want to check for emptiness.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to use<\/h2>\n\n\n\n

You can use the ISBLANK function in Excel to check whether a cell is empty. Here are some examples:<\/p>\n\n\n\n

=ISBLANK(A1)<\/code><\/pre>\n\n\n\n
This formula checks if cell A1 is empty. It will return TRUE if A1 is empty and FALSE if it contains any data.<\/p>\n\n\n\n
=ISBLANK(B2:B5)<\/code><\/pre>\n\n\n\n
Here, we check if all cells in the range B2 to B5 are empty. The formula will return TRUE only if all the cells are blank; otherwise, it will return FALSE.<\/p>\n\n\n\n
=IF(ISBLANK(C3), \"Cell is empty\", \"Cell is not empty\")<\/code><\/pre>\n\n\n\n
This example uses the ISBLANK function within an IF function to provide a custom message based on whether cell C3 is empty or not.<\/p>\n\n\n\n
Examples<\/h2>\n\n\n\n
Let’s look at some practical examples of using the ISBLANK function:<\/p>\n\n\n\n
Data<\/strong><\/td>Formula<\/strong><\/td>Result<\/strong><\/td><\/tr>
42<\/td>=ISBLANK(A1)<\/td>FALSE<\/td><\/tr>
 <\/td>=ISBLANK(A2)<\/td>TRUE<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
In the first example, ISBLANK(A1) returns FALSE because cell A1 contains the number 42. In the second example, ISBLANK(A2) returns TRUE because cell A2 is empty.<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
If you want to check if a cell contains a specific type of data (e.g., text, numbers, errors), you can use other Excel functions like ISTEXT, ISNUMBER, or ISERROR in combination with ISBLANK.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel ISBLANK Function checks if a cell is empty or blank. It returns TRUE if the cell is empty and FALSE if it…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nISBLANK function<\/title>\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\/functions\/isblank\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ISBLANK function\" \/>\n<meta property=\"og:description\" content=\"Excel ISBLANK Function checks if a cell is empty or blank. It returns TRUE if the cell is empty and FALSE if it...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T15:05:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T10:04:21+00:00\" \/>\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\/functions\/isblank\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ISBLANK function\",\"datePublished\":\"2018-07-04T15:05:59+00:00\",\"dateModified\":\"2023-11-03T10:04:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\"},\"wordCount\":244,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\",\"name\":\"ISBLANK function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T15:05:59+00:00\",\"dateModified\":\"2023-11-03T10:04:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/isblank\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/isblank\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ISBLANK function\"}]},{\"@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":"ISBLANK function","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\/functions\/isblank\/","og_locale":"en_US","og_type":"article","og_title":"ISBLANK function","og_description":"Excel ISBLANK Function checks if a cell is empty or blank. It returns TRUE if the cell is empty and FALSE if it...","og_url":"https:\/\/officetuts.net\/excel\/functions\/isblank\/","article_published_time":"2018-07-04T15:05:59+00:00","article_modified_time":"2023-11-03T10:04:21+00:00","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\/functions\/isblank\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/isblank\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ISBLANK function","datePublished":"2018-07-04T15:05:59+00:00","dateModified":"2023-11-03T10:04:21+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/isblank\/"},"wordCount":244,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/isblank\/","url":"https:\/\/officetuts.net\/excel\/functions\/isblank\/","name":"ISBLANK function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T15:05:59+00:00","dateModified":"2023-11-03T10:04:21+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/isblank\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/isblank\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/isblank\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ISBLANK function"}]},{"@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\/1468"}],"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=1468"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1468\/revisions"}],"predecessor-version":[{"id":16485,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1468\/revisions\/16485"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}