{"id":6609,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/complexe-racine\/"},"modified":"2021-02-26T08:08:23","modified_gmt":"2021-02-26T08:08:23","slug":"imsqrt","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/imsqrt\/","title":{"rendered":"COMPLEXE.RACINE"},"content":{"rendered":"

Introduction \u00e0 la fonction IMSQRT (COMPLEXE.RACINE) dans Excel et Google Sheets<\/strong><\/p>\n

Cette fonction est con\u00e7ue pour calculer la racine carr\u00e9e d’un nombre complexe. Elle est particuli\u00e8rement pertinente dans les domaines de l’ing\u00e9nierie, de la physique et autres disciplines n\u00e9cessitant des calculs complexes.<\/p>\n

Description de la syntaxe<\/h2>\n

La syntaxe de la fonction dans MS Excel est :<\/p>\n

IMSQRT(complexe)<\/code><\/pre>\n
O\u00f9 complexe<\/code> d\u00e9signe le nombre complexe dont la racine carr\u00e9e est \u00e0 calculer. Les nombres complexes sont typiquement exprim\u00e9s sous la forme \u00ab\u00a0x + yi\u00a0\u00bb ou \u00ab\u00a0x + yj\u00a0\u00bb, avec x et y \u00e9tant des nombres r\u00e9els.<\/p>\n
Exemple d’utilisation :<\/p>\n
=IMSQRT(\"4+3i\")<\/code><\/pre>\n
Cette formule renvoie \u00ab\u00a02+1.5i\u00a0\u00bb, qui est la racine carr\u00e9e de \u00ab\u00a04+3i\u00a0\u00bb.<\/p>\n
Sc\u00e9narios d’utilisation<\/h2>\n
Exemple 1: Application en \u00e9lectricit\u00e9<\/strong><\/p>\n
Imaginez que vous g\u00e9rez des imp\u00e9dances dans un circuit \u00e9lectrique, repr\u00e9sent\u00e9es par des nombres complexes.<\/p>\n
Imp\u00e9dance = \"5+12i\"<\/code><\/pre>\n
Pour calculer l’imp\u00e9dance de base lorsque vous manipulez deux imp\u00e9dances du m\u00eame type en parall\u00e8le, vous pourriez avoir besoin de prendre la racine carr\u00e9e de l’imp\u00e9dance :<\/p>\n
=IMSQRT(\"5+12i\")<\/code><\/pre>\n
Le r\u00e9sultat, \u00ab\u00a03.60555+1.66132i\u00a0\u00bb, indique l’imp\u00e9dance de base n\u00e9cessaire pour les calculs avanc\u00e9s.<\/p>\n
Exemple 2: Analyse des fr\u00e9quences<\/strong><\/p>\n
Dans l’analyse de signaux, il peut \u00eatre n\u00e9cessaire de d\u00e9composer un signal en ses composantes fr\u00e9quentielles. Si l’analyse produit des valeurs complexes, utiliser IMSQRT peut simplifier ces composantes.<\/p>\n
Signal = \"9+16i\"<\/code><\/pre>\n
Calcul de la racine carr\u00e9e du composant complexe du signal :<\/p>\n
=IMSQRT(\"9+16i\")<\/code><\/pre>\n
Cela donne \u00ab\u00a03.93649+2.03101i\u00a0\u00bb, qui pourrait \u00eatre interpr\u00e9t\u00e9 en termes d’amplitude et de phase dans le contexte du traitement du signal.<\/p>\n
En conclusion, la fonction IMSQRT<\/code> ou COMPLEXE.RACINE<\/code> s’av\u00e8re \u00eatre un outil essentiel dans de nombreux contextes scientifiques et d’ing\u00e9nierie pour le traitement de donn\u00e9es complexes.<\/p>\n","protected":false},"excerpt":{"rendered":"
Renvoie la Racine caRR\u00e9e d\u2019un nombRe complexe<\/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-6609","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction IMSQRT (COMPLEXE.RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) 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\/imsqrt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IMSQRT (COMPLEXE.RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/imsqrt\/\" \/>\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:08:23+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IMSQRT (COMPLEXE.RACINE) 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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/imsqrt\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/imsqrt\/\",\"name\":\"Fonction IMSQRT (COMPLEXE.RACINE) 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:08:23+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/imsqrt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/imsqrt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/imsqrt\/#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\":\"COMPLEXE.RACINE\"}]},{\"@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 IMSQRT (COMPLEXE.RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) 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\/imsqrt\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IMSQRT (COMPLEXE.RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/imsqrt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:23+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IMSQRT (COMPLEXE.RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/imsqrt\/","url":"https:\/\/functiontranslator.com\/fr\/imsqrt\/","name":"Fonction IMSQRT (COMPLEXE.RACINE) 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:08:23+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IMSQRT (COMPLEXE.RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/imsqrt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/imsqrt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/imsqrt\/#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":"COMPLEXE.RACINE"}]},{"@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\/6609","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=6609"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6609\/revisions"}],"predecessor-version":[{"id":29620,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6609\/revisions\/29620"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}