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

La fonction IMREAL<\/strong> dans MS Excel et COMPLEXE.REEL<\/strong> dans Google Sheets est utilis\u00e9e pour extraire la partie r\u00e9elle d’un nombre complexe format\u00e9 sous forme de texte. Cette fonction est particuli\u00e8rement utile dans le domaine des nombres complexes, notamment en ing\u00e9nierie, en physique et autres sciences appliqu\u00e9es.<\/p>\n

Description et syntaxe<\/h2>\n

Cette fonction calcule la partie r\u00e9elle d’un nombre complexe exprim\u00e9 en tant que texte. Voici comment vous devriez l’utiliser dans MS Excel :<\/p>\n

=IMREAL(\"nombre_complexe\")<\/code><\/pre>\n
Pour Google Sheets, la syntaxe est l\u00e9g\u00e8rement diff\u00e9rente :<\/p>\n
=COMPLEXE.REEL(\"nombre_complexe\")<\/code><\/pre>\n
Dans les deux cas, \u00ab\u00a0nombre_complexe\u00a0\u00bb repr\u00e9sente le nombre complexe en question, tel que \u00ab\u00a03+4i\u00a0\u00bb.<\/p>\n
Utilisations pratiques de la fonction<\/h2>\n
Exemple 1 : Extraction de la partie r\u00e9elle d’un nombre complexe<\/h2>\n
Imaginez que vous disposiez d’une s\u00e9rie de nombres complexes dans une colonne d’un classeur Excel ou Google Sheets, et que vous ayez besoin d’en extraire les parties r\u00e9elles.<\/p>\n
    \n
  • Dans MS Excel : Supposons que \u00ab\u00a03+2i\u00a0\u00bb se trouve dans la cellule A1; pour obtenir la partie r\u00e9elle \u00ab\u00a03\u00a0\u00bb, votre formule sera :<\/li>\n
    =IMREAL(A1)<\/code><\/pre>\n
  • Dans Google Sheets : Pour le m\u00eame nombre complexe dans la cellule A1, utilisez la fonction :<\/li>\n
    =COMPLEXE.REEL(A1)<\/code><\/pre>\n<\/ul>\n
    Cette formule peut \u00eatre copi\u00e9e le long d’une colonne enti\u00e8re pour extraire la partie r\u00e9elle de chaque nombre complexe list\u00e9.<\/p>\n
    Exemple 2 : Calculs complexes bas\u00e9s sur les valeurs r\u00e9elles<\/h2>\n
    Consid\u00e9rant le cas o\u00f9 vous travaillez avec des imp\u00e9dances dans un circuit \u00e9lectrique, souvent not\u00e9es \u00ab\u00a0R + Xi\u00a0\u00bb (o\u00f9 \u00ab\u00a0R\u00a0\u00bb est la r\u00e9sistance et \u00ab\u00a0X\u00a0\u00bb la r\u00e9actance), et que vous avez besoin de calculer uniquement la r\u00e9sistance totale. Vous pourriez alors utiliser cette fonction pour isoler les parties r\u00e9elles des imp\u00e9dances et les additionner.<\/p>\n
      \n
    • Par exemple, avec \u00ab\u00a05+3i\u00a0\u00bb dans A1 et \u00ab\u00a04+2i\u00a0\u00bb dans A2, pour calculer la r\u00e9sistance totale, vous pourriez entrer :<\/li>\n
      =IMREAL(A1) + IMREAL(A2)<\/code><\/pre>\n
    • Dans Google Sheets, cela se traduirait par :<\/li>\n
      =COMPLEXE.REEL(A1) + COMPLEXE.REEL(A2)<\/code><\/pre>\n<\/ul>\n
      Vous pouvez \u00e9tendre cette m\u00e9thode \u00e0 plusieurs cellules pour obtenir la r\u00e9sistance totale pour un ensemble de composants connect\u00e9s en s\u00e9rie.<\/p>\n
      Ma\u00eetriser IMREAL (COMPLEXE.REEL) est crucial pour les analystes et ing\u00e9nieurs qui manipulent fr\u00e9quemment des nombres complexes dans des contextes scientifiques ou techniques. Les exemples ci-dessus illustrent comment exploiter ces fonctions pour aborder des probl\u00e8mes allant du plus simple au plus complexe. Une bonne compr\u00e9hension du format d’entr\u00e9e de ces nombres complexes assure l’efficacit\u00e9 de la fonction, tout en facilitant la manipulation des donn\u00e9es analytiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le coefficient R\u00e9el 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-6604","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction IMREAL (COMPLEXE.REEL) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) 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\/imreal\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction IMREAL (COMPLEXE.REEL) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/imreal\/\" \/>\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:14+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction IMREAL (COMPLEXE.REEL) 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\/imreal\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/imreal\/\",\"name\":\"Fonction IMREAL (COMPLEXE.REEL) 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:14+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/imreal\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/imreal\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/imreal\/#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.REEL\"}]},{\"@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 IMREAL (COMPLEXE.REEL) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) 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\/imreal\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction IMREAL (COMPLEXE.REEL) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/imreal\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:08:14+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction IMREAL (COMPLEXE.REEL) 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\/imreal\/","url":"https:\/\/functiontranslator.com\/fr\/imreal\/","name":"Fonction IMREAL (COMPLEXE.REEL) 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:14+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction IMREAL (COMPLEXE.REEL) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/imreal\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/imreal\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/imreal\/#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.REEL"}]},{"@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\/6604","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=6604"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6604\/revisions"}],"predecessor-version":[{"id":29615,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6604\/revisions\/29615"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6604"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6604"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6604"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}