{"id":6766,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/signe\/"},"modified":"2021-02-26T08:13:39","modified_gmt":"2021-02-26T08:13:39","slug":"sign","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/sign\/","title":{"rendered":"SIGNE"},"content":{"rendered":"

Introduction \u00e0 la fonction SIGNE<\/h2>\n

La fonction SIGNE, disponible dans MS Excel et Google Sheets, permet de d\u00e9terminer le signe d’un nombre sp\u00e9cifique. Elle renvoie 1 si le nombre est positif, 0 si le nombre est nul et -1 si le nombre est n\u00e9gatif. Cette fonction est particuli\u00e8rement pratique pour classifier des nombres selon leur signe lors de l’analyse de donn\u00e9es.<\/p>\n

Syntaxe de la fonction<\/h2>\n

La syntaxe de la fonction SIGNE est la suivante dans MS Excel et Google Sheets :<\/p>\n

=SIGNE(nombre)<\/code><\/pre>\n
O\u00f9 nombre<\/i> est le nombre dont vous voulez d\u00e9terminer le signe.<\/p>\n
Exemples simples :<\/p>\n
    \n
  • =SIGNE(10)<\/code> renvoie 1.<\/li>\n
  • =SIGNE(-5)<\/code> renvoie -1.<\/li>\n
  • =SIGNE(0)<\/code> renvoie 0.<\/li>\n<\/ul>\n
    Exemples pratiques d’utilisation<\/h2>\n
    Classification de donn\u00e9es en fonction de leur signe<\/h2>\n
    Imaginez que vous poss\u00e9diez une liste de variations de prix (positives et n\u00e9gatives) dans la colonne A et que vous souhaitiez les classifier.<\/p>\n
    A B 10 =SIGNE(A2) -20 =SIGNE(A3) 15 =SIGNE(A4) -5 =SIGNE(A5) 0 =SIGNE(A6)<\/code><\/pre>\n
    Cette formule permet d’identifier rapidement si une variation repr\u00e9sente une augmentation (1), une diminution (-1), ou une stabilit\u00e9 (0).<\/p>\n
    Analyse de sentiment des commentaires<\/h2>\n
    Consid\u00e9rons une situation o\u00f9 vous analysez des scores de sentiment des commentaires des clients, lesquels varient de -100 \u00e0 100. La fonction SIGNE peut \u00eatre utilis\u00e9e pour cat\u00e9goriser rapidement ces scores en tant que positifs, n\u00e9gatifs ou neutres.<\/p>\n\n\n\n\n\n
    Score<\/th>\nSentiment<\/th>\n<\/tr>\n
    45<\/td>\n=SIGNE(B2)<\/code><\/td>\n<\/tr>\n
    -30<\/td>\n=SIGNE(B3)<\/code><\/td>\n<\/tr>\n
    0<\/td>\n=SIGNE(B4)<\/code><\/td>\n<\/tr>\n<\/table>\n
    Dans ce sc\u00e9nario, les valeurs retourn\u00e9es r\u00e9v\u00e8lent si les commentaires sont majoritairement positifs (1), n\u00e9gatifs (-1), ou neutres (0), ce qui s’av\u00e8re extr\u00eamement utile pour des analyses automatis\u00e9es.<\/p>\n
    Conclusion<\/h2>\n
    La fonction SIGNE est un outil extr\u00eamement pr\u00e9cieux pour manipuler et analyser des donn\u00e9es num\u00e9riques, en fonction de leur valeur positive, n\u00e9gative, ou nulle. Elle est largement utilis\u00e9e dans des contextes vari\u00e9s tels que l’analyse financi\u00e8re, les \u00e9tudes de march\u00e9, ou pour structurer simplement des donn\u00e9es, gr\u00e2ce \u00e0 son application directe et sa facilit\u00e9 d’utilisation.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie le signe 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-6766","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction SIGN (SIGNE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction SIGN (SIGNE) 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\/sign\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction SIGN (SIGNE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction SIGN (SIGNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/sign\/\" \/>\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:39+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction SIGN (SIGNE) 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\/sign\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/sign\/\",\"name\":\"Fonction SIGN (SIGNE) 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:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction SIGN (SIGNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/sign\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/sign\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/sign\/#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\":\"SIGNE\"}]},{\"@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 SIGN (SIGNE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction SIGN (SIGNE) 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\/sign\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction SIGN (SIGNE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction SIGN (SIGNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/sign\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction SIGN (SIGNE) 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\/sign\/","url":"https:\/\/functiontranslator.com\/fr\/sign\/","name":"Fonction SIGN (SIGNE) 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:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction SIGN (SIGNE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/sign\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/sign\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/sign\/#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":"SIGNE"}]},{"@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\/6766","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=6766"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6766\/revisions"}],"predecessor-version":[{"id":29776,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6766\/revisions\/29776"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6766"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6766"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6766"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}