{"id":6521,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/erf\/"},"modified":"2021-02-26T08:05:44","modified_gmt":"2021-02-26T08:05:44","slug":"erf","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/erf\/","title":{"rendered":"ERF"},"content":{"rendered":"

Description et Syntaxe<\/h2>\n

La fonction ERF permet de calculer l’int\u00e9grale de la fonction d’erreur de Gauss, \u00e9galement connue sous le nom de fonction d’erreur, entre deux valeurs sp\u00e9cifi\u00e9es. Cette fonction est largement utilis\u00e9e en statistiques et en analyse de probabilit\u00e9s pour mod\u00e9liser des ph\u00e9nom\u00e8nes vari\u00e9s, notamment en sciences et en ing\u00e9nierie o\u00f9 elle aide \u00e0 r\u00e9soudre les probl\u00e8mes reli\u00e9s aux distributions normales.<\/p>\n

Syntaxe dans Excel :<\/p>\n

ERF(limite_inf\u00e9rieure, [limite_sup\u00e9rieure])<\/code><\/pre>\n
Syntaxe dans Google Sheets :<\/p>\n
ERF(limite_inf\u00e9rieure, limite_sup\u00e9rieure)<\/code><\/pre>\n
Le param\u00e8tre limite_inf\u00e9rieure<\/code> repr\u00e9sente la borne inf\u00e9rieure de l’int\u00e9gration. Le param\u00e8tre limite_sup\u00e9rieure<\/code>, facultatif dans Excel mais obligatoire dans Google Sheets, d\u00e9signe la borne sup\u00e9rieure de l’int\u00e9gration. Si la limite sup\u00e9rieure n’est pas fournie dans Excel, la borne de 0 est automatiquement assum\u00e9e.<\/p>\n
Exemples Pratiques<\/h2>\n
Exemple 1 :<\/strong> Calcul de l’erreur fonctionnelle entre les valeurs 0 et 1.<\/p>\n
    \n
  • Dans Excel : =ERF(0, 1)<\/li>\n
  • Dans Google Sheets : =ERF(0, 1)<\/li>\n<\/ul>\n
    Cette formule calcule la probabilit\u00e9 qu’une variable al\u00e9atoire suivant une distribution normale standard se trouve entre 0 et 1.<\/p>\n
    Exemple 2 :<\/strong> Utilisation de la fonction ERF dans Excel sans sp\u00e9cifier la borne sup\u00e9rieure.<\/p>\n
      \n
    • =ERF(1) – Cette formule calcule l’erreur fonctionnelle de Gauss de 0 \u00e0 1.<\/li>\n<\/ul>\n
      Cette formule sp\u00e9cifique n’est valide que dans Excel, car il requiert la sp\u00e9cification des deux bornes dans Google Sheets, par exemple : =ERF(0,1).<\/p>\n
      Applications Pratiques<\/h2>\n
      Application 1 : Calcul de probabilit\u00e9 pour une distribution normale<\/strong><\/p>\n
      Considerons une distribution normale standard. Pour trouver la probabilit\u00e9 qu’une observation se situe entre -1 et 1, vous pouvez utiliser :<\/p>\n
      =ERF(-1, 1)<\/code><\/pre>\n
      Ce calcul vous montre la probabilit\u00e9 que l’observation se situe dans cet intervalle sp\u00e9cifique.<\/p>\n
      Application 2 : Mod\u00e9lisation de la diffusion<\/strong><\/p>\n
      Les ing\u00e9nieurs se servent de la fonction ERF pour mod\u00e9liser des ph\u00e9nom\u00e8nes tels que la diffusion de chaleur ou la dispersion de substances chimiques dans diff\u00e9rents milieux. La progression de la temp\u00e9rature ou des concentrations peut \u00eatre estim\u00e9e \u00e0 l’aide de la fonction d’erreur.<\/p>\n
      =ERF(0, X) \/\/ X \u00e9tant la limite sup\u00e9rieure d'int\u00e9gration<\/code><\/pre>\n
      Cette formule peut \u00eatre utilis\u00e9e pour estimer la diffusion de chaleur ou de substances chimiques \u00e0 travers un milieu sur une certaine distance X.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie la valeuR de la fonction d\u2019eRReuR<\/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-6521","post","type-post","status-publish","format-standard","hentry","category-ingenierie"],"acf":[],"yoast_head":"\nFonction ERF dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ERF 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\/erf\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ERF dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ERF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/erf\/\" \/>\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:05:44+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ERF 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\/erf\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/erf\/\",\"name\":\"Fonction ERF 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:05:44+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ERF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/erf\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/erf\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/erf\/#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\":\"ERF\"}]},{\"@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 ERF dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ERF 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\/erf\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ERF dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ERF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/erf\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:05:44+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ERF 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\/erf\/","url":"https:\/\/functiontranslator.com\/fr\/erf\/","name":"Fonction ERF 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:05:44+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ERF d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/erf\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/erf\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/erf\/#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":"ERF"}]},{"@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\/6521","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=6521"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6521\/revisions"}],"predecessor-version":[{"id":29533,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6521\/revisions\/29533"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6521"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6521"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6521"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}