{"id":67,"date":"2025-07-15T13:34:46","date_gmt":"2025-07-15T13:34:46","guid":{"rendered":"https:\/\/functiontranslator.com\/2021\/02\/12\/bitrshift\/"},"modified":"2021-02-13T11:32:54","modified_gmt":"2021-02-13T11:32:54","slug":"bitrshift","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/en\/bitrshift\/","title":{"rendered":"BITRSHIFT"},"content":{"rendered":"

Welcome to the comprehensive guide on using the BITRSHIFT function in Microsoft Excel and Google Sheets, a tool designed for performing bitwise right shift operations on the binary forms of numbers. In this guide, you’ll learn about the function\u2019s mechanics, its syntax, practical applications, and how to efficiently implement it in your tasks.<\/p>\n

Function Syntax<\/h2>\n

The syntax for the BITRSHIFT function is consistent across both Excel and Google Sheets and is outlined below:<\/p>\n

=BITRSHIFT(number, shift_amount)<\/code><\/pre>\n
    \n
  • number<\/code>: This argument is the number, or a reference to the cell containing the number, that you want to shift.<\/li>\n
  • shift_amount<\/code>: This specifies the number of bits by which you want to shift the binary representation of number<\/code> rightward.<\/li>\n<\/ul>\n
    Examples<\/h2>\n
    Example 1: Using BITRSHIFT for Right Shifting<\/h2>\n
    Consider you have a binary number 1010, which equals 10 in decimal. To right shift this number by 1 bit using the BITRSHIFT function, the scenario and outcome would look like the following:<\/p>\n\n\n\n
    Formula<\/th>\nResult<\/th>\n<\/tr>\n
    =BITRSHIFT(10,1)<\/td>\n5 (0101 in binary)<\/td>\n<\/tr>\n<\/table>\n
    Example 2: Applying BITRSHIFT to Cell References<\/h2>\n
    The BITRSHIFT function can also interact with cell references. If cell A1 contains the decimal number 6 (0110 in binary), and you wish to shift it right by 2 bits, you would use this formula:<\/p>\n\n\n\n
    Formula<\/th>\nResult<\/th>\n<\/tr>\n
    =BITRSHIFT(A1,2)<\/td>\n1 (0001 in binary)<\/td>\n<\/tr>\n<\/table>\n
    Example 3: Combining BITRSHIFT with Other Functions<\/h2>\n
    Furthermore, BITRSHIFT can be paired with other functions for more elaborate operations. If cell A1 contains the number 15 (1111 in binary), and you need to perform a right shift by 2 bits before conducting a bitwise AND operation with 3 (0011 in binary), your formula would look as follows:<\/p>\n\n\n\n
    Formula<\/th>\nResult<\/th>\n<\/tr>\n
    =BITAND(BITRSHIFT(A1,2),3)<\/td>\n1 (0001 in binary)<\/td>\n<\/tr>\n<\/table>\n
    These examples illustrate the flexibility and utility of the BITRSHIFT function in adapting binary numbers through right shifting operations. By experimenting with different scenarios and combinations, you can explore the full range of functionalities this function offers in Excel and Google Sheets.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Returns a value number shifted right by shift_amount bits<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[204],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-engineering"],"acf":[],"yoast_head":"\nExcel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax<\/title>\n<meta name=\"description\" content=\"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/en\/bitrshift\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta property=\"og:description\" content=\"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/en\/bitrshift\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-13T11:32:54+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/en\/bitrshift\/\",\"url\":\"https:\/\/functiontranslator.com\/en\/bitrshift\/\",\"name\":\"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:46+00:00\",\"dateModified\":\"2021-02-13T11:32:54+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/en\/bitrshift\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/en\/bitrshift\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/en\/bitrshift\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Function Excel\",\"item\":\"https:\/\/functiontranslator.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Engineering\",\"item\":\"https:\/\/functiontranslator.com\/en\/engineering\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BITRSHIFT\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax","description":"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.","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:\/\/functiontranslator.com\/en\/bitrshift\/","og_locale":"en_US","og_type":"article","og_title":"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax","og_description":"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.","og_url":"https:\/\/functiontranslator.com\/en\/bitrshift\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:46+00:00","article_modified_time":"2021-02-13T11:32:54+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax","twitter_misc":{"Written by":"glavadmin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/en\/bitrshift\/","url":"https:\/\/functiontranslator.com\/en\/bitrshift\/","name":"Excel BITRSHIFT Function \u2013 How It Works, Formula Examples and Syntax","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:46+00:00","dateModified":"2021-02-13T11:32:54+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Learn what the Excel BITRSHIFT function does. Clear syntax explanation and useful formula examples.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/en\/bitrshift\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/en\/bitrshift\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/en\/bitrshift\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Function Excel","item":"https:\/\/functiontranslator.com\/en\/"},{"@type":"ListItem","position":2,"name":"Engineering","item":"https:\/\/functiontranslator.com\/en\/engineering\/"},{"@type":"ListItem","position":3,"name":"BITRSHIFT"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/en\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/comments?post=67"}],"version-history":[{"count":3,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":2958,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/posts\/67\/revisions\/2958"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/media?parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/categories?post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/en\/wp-json\/wp\/v2\/tags?post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}