{"id":6421,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/bitdecalg\/"},"modified":"2021-02-26T08:02:41","modified_gmt":"2021-02-26T08:02:41","slug":"bitlshift","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/bitlshift\/","title":{"rendered":"BITDECALG"},"content":{"rendered":"

La fonction BITDECALG<\/strong>, \u00e9galement connue sous le nom de BITLSHIFT en anglais, est utilis\u00e9e pour d\u00e9caler les bits d’un nombre entier vers la gauche. Effectuer ce d\u00e9calage \u00e9quivaut \u00e0 multiplier le nombre d’origine par deux \u00e9lev\u00e9 \u00e0 la puissance du d\u00e9calage sp\u00e9cifi\u00e9. Cette fonction est particuli\u00e8rement utile dans le domaine de l’informatique et de l’ing\u00e9nierie, o\u00f9 la manipulation directe de bits et de masques de bits est fr\u00e9quente.<\/p>\n

Fonctionnement et Syntaxe de la Fonction<\/h2>\n

La syntaxe de la fonction BITDECALG<\/strong> dans Excel est la suivante :<\/p>\n

BITDECALG(nombre, d\u00e9calage)<\/code><\/pre>\n
Les param\u00e8tres sont d\u00e9finis comme suit :<\/p>\n
    \n
  • nombre<\/b> : le nombre entier positif \u00e0 d\u00e9caler.<\/li>\n
  • d\u00e9calage<\/b> : le nombre de positions que les bits du nombre doivent \u00eatre d\u00e9cal\u00e9s vers la gauche.<\/li>\n<\/ul>\n
    Exemple d’utilisation :<\/p>\n
    =BITDECALG(5, 1)<\/code><\/pre>\n
    Cette formule renvoie 10, car en d\u00e9calant d’un bit vers la gauche le nombre 5 (qui correspond \u00e0 101 en binaire), on obtient 1010 en binaire, soit 10 en base d\u00e9cimale.<\/p>\n
    Applications Pratiques de BITDECALG<\/h2>\n
    Calcul de l’augmentation des capacit\u00e9s de stockage<\/h2>\n
    Par exemple, consid\u00e9rons une entreprise qui souhaite doubler la capacit\u00e9 de stockage de ses dispositifs chaque ann\u00e9e. La fonction BITDECALG peut \u00eatre utilis\u00e9e pour estimer la capacit\u00e9 apr\u00e8s plusieurs ann\u00e9es :<\/p>\n
    =BITDECALG(1, Nombre_d_ann\u00e9es)<\/code><\/pre>\n
    Si l’entreprise part avec 1 Go de stockage et souhaite calculer la capacit\u00e9 de stockage disponible apr\u00e8s 5 ans, on utiliserait :<\/p>\n
    =BITDECALG(1, 5)<\/code><\/pre>\n
    Ce calcul donnera un r\u00e9sultat de 32, indiquant que la capacit\u00e9 de stockage serait de 32 Go apr\u00e8s 5 ans.<\/p>\n
    Cr\u00e9ation de masques de bits pour la programmation de syst\u00e8mes<\/h2>\n
    Les programmeurs de syst\u00e8mes embarqu\u00e9s ou de logiciels bas-niveau utilisent souvent des masques de bits pour configurer des registres de p\u00e9riph\u00e9riques. Pour cr\u00e9er un masque o\u00f9 les trois bits les plus bas sont activ\u00e9s (par exemple, pour configurer les trois premiers param\u00e8tres d’un p\u00e9riph\u00e9rique), on peut utiliser :<\/p>\n
    =BITDECALG(1, 3) - 1<\/code><\/pre>\n
    Cette op\u00e9ration d\u00e9cale le bit 1 de trois positions vers la gauche pour obtenir 1000 en binaire, puis soustrait 1 pour finir avec 111 en binaire, qui correspond \u00e0 7 en d\u00e9cimal.<\/p>\n
    En conclusion, la fonction BITDECALG est un outil essentiel dans Excel et Google Sheets pour les t\u00e2ches n\u00e9cessitant des manipulations pr\u00e9cises de valeurs binaires, que ce soit pour des calculs de d\u00e9calage de bits ou pour des applications en informatique et ing\u00e9nierie n\u00e9cessitant une manipulation bas-niveau des donn\u00e9es num\u00e9riques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie un num\u00e9ro de valeur d\u00e9cal\u00e9 vers la gauche de montant_d\u00e9calage bits<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[],"class_list":["post-6421","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\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\/fr\/bitlshift\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/bitlshift\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:02:41+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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\/fr\/bitlshift\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/bitlshift\/\",\"name\":\"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:02:41+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/bitlshift\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/bitlshift\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/bitlshift\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ing\u00e9nierie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/ingenierie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"BITDECALG\"}]},{\"@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\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@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\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","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\/fr\/bitlshift\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/bitlshift\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:02:41+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/bitlshift\/","url":"https:\/\/functiontranslator.com\/fr\/bitlshift\/","name":"Fonction BITLSHIFT (BITDECALG) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:02:41+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction BITLSHIFT (BITDECALG) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/bitlshift\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/bitlshift\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/bitlshift\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Ing\u00e9nierie","item":"https:\/\/functiontranslator.com\/fr\/ingenierie\/"},{"@type":"ListItem","position":3,"name":"BITDECALG"}]},{"@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":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@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\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6421","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6421"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6421\/revisions"}],"predecessor-version":[{"id":29433,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6421\/revisions\/29433"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6421"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6421"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6421"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}