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

La fonction SQRT<\/strong> dans Microsoft Excel et RACINE<\/strong> dans Google Sheets sont con\u00e7ues pour calculer la racine carr\u00e9e d’un nombre sp\u00e9cifi\u00e9. Ces fonctions sont extr\u00eamement utiles dans des domaines tels que la statistique, la finance et l’ing\u00e9nierie, o\u00f9 elles permettent de r\u00e9aliser des calculs comprenant des mesures de dispersion telles que l’\u00e9cart-type.<\/p>\n

Pr\u00e9sentation de la Syntaxe<\/h2>\n

Dans Microsoft Excel:<\/p>\n

=SQRT(nombre)<\/code><\/pre>\n
Dans Google Sheets:<\/p>\n
=RACINE(nombre)<\/code><\/pre>\n
Le terme nombre<\/em> d\u00e9signe le nombre dont vous souhaitez calculer la racine carr\u00e9e. Il est important de noter que ce nombre doit \u00eatre positif, car la racine carr\u00e9e d’un nombre n\u00e9gatif est ind\u00e9finie dans le domaine des nombres r\u00e9els.<\/p>\n
Exemples d’Utilisation<\/h2>\n
    \n
  • Calcul de la racine carr\u00e9e d’un nombre : en entrant =SQRT(16)<\/code> dans Excel ou =RACINE(16)<\/code> dans Google Sheets, le r\u00e9sultat obtenu sera 4.<\/li>\n
  • Utilisation dans une formule : si une cellule A1 contient une variance de 25, pour trouver l’\u00e9cart-type, vous pouvez entrer =SQRT(A1)<\/code> dans Excel ou =RACINE(A1)<\/code> dans Google Sheets, ce qui donnera 5.<\/li>\n<\/ul>\n
    Cas Pratiques<\/h2>\n
    Voici deux sc\u00e9narios illustrant l’utilit\u00e9 des fonctions SQRT\/RACINE.<\/p>\n
    Sc\u00e9nario 1 : Calcul de l’\u00e9cart-type<\/strong><\/p>\n
    L’\u00e9cart-type est une mesure indiquant le degr\u00e9 de dispersion ou de variation d’un ensemble de valeurs. Une variance \u00e9lev\u00e9e sugg\u00e8re une grande dispersion des valeurs par rapport \u00e0 la moyenne et vice versa. Imaginons que nous disposons des r\u00e9sultats d’un test dans une \u00e9cole et que nous souhaitons calculer l’\u00e9cart-type des scores :<\/p>\n
     Scores : 81, 89, 94, 68, 74 <\/code><\/pre>\n
    \u00c9tape 1 : Calculez la moyenne des scores.<\/p>\n
     Moyenne = (81 + 89 + 94 + 68 + 74) \/ 5 = 81.2 <\/code><\/pre>\n
    \u00c9tape 2 : Calculez la variance, qui repr\u00e9sente la moyenne des carr\u00e9s des \u00e9carts entre chaque score et la moyenne.<\/p>\n
     Variance = ((81-81.2)\u00b2 + (89-81.2)\u00b2 + (94-81.2)\u00b2 + (68-81.2)\u00b2 + (74-81.2)\u00b2) \/ 4 = 107.2 <\/code><\/pre>\n
    \u00c9tape 3 : Utilisez SQRT ou RACINE pour calculer l’\u00e9cart-type.<\/p>\n
     \u00c9cart-type = SQRT(107.2) = 10.35 (Excel) \u00c9cart-type = RACINE(107.2) = 10.35 (Google Sheets) <\/code><\/pre>\n
    Sc\u00e9nario 2 : Calcul de la diagonale d’une t\u00e9l\u00e9vision<\/strong><\/p>\n
    La taille d’une t\u00e9l\u00e9vision est souvent exprim\u00e9e en diagonale. Si vous connaissez la largeur et la hauteur de l’\u00e9cran, vous pouvez utiliser SQRT ou RACINE pour calculer la taille de la diagonale :<\/p>\n
     Largeur = 40 pouces, Hauteur = 22 pouces <\/code><\/pre>\n
    Calcul de la diagonale :<\/p>\n
     Diagonale = SQRT(40\u00b2 + 22\u00b2) = SQRT(1600 + 484) = SQRT(2084) = 45.65 pouces (Excel) Diagonale = RACINE(40\u00b2 + 22\u00b2) = RACINE(1600 + 484) = RACINE(2084) = 45.65 pouces (Google Sheets) <\/code><\/pre>\n
    En conclusion, les fonctions SQRT dans Excel et RACINE dans Google Sheets offrent des m\u00e9thodes simples et efficaces pour effectuer des calculs de racines carr\u00e9es, facilitant ainsi la r\u00e9alisation de diverses op\u00e9rations math\u00e9matiques et statistiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la Racine caRR\u00e9e d\u2019un nombRe<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[310],"tags":[],"class_list":["post-6776","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SQRT (RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SQRT (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\/sqrt\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SQRT (RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SQRT (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\/sqrt\/\" \/>\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:13:56+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SQRT (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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sqrt\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sqrt\/\",\"name\":\"Fonction SQRT (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:13:56+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SQRT (RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sqrt\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sqrt\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sqrt\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Math\u00e9matiques et trigonom\u00e9trie\",\"item\":\"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"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 SQRT (RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SQRT (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\/sqrt\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SQRT (RACINE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SQRT (RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sqrt\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:56+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SQRT (RACINE) 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\/sqrt\/","url":"https:\/\/functiontranslator.com\/fr\/sqrt\/","name":"Fonction SQRT (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:13:56+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SQRT (RACINE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sqrt\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sqrt\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sqrt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Math\u00e9matiques et trigonom\u00e9trie","item":"https:\/\/functiontranslator.com\/fr\/mathematiques-et-trigonometrie\/"},{"@type":"ListItem","position":3,"name":"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\/6776","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=6776"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6776\/revisions"}],"predecessor-version":[{"id":29785,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6776\/revisions\/29785"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6776"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}