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

Description et Syntaxe<\/h2>\n

La fonction TRONQUE<\/strong> dans Microsoft Excel et Google Sheets est utilis\u00e9e pour tronquer un nombre \u00e0 un nombre sp\u00e9cifi\u00e9 de d\u00e9cimales, supprimant ainsi toutes les d\u00e9cimales exc\u00e9dentaires sans arrondir. Cette fonction est particuli\u00e8rement utile pour la pr\u00e9paration des donn\u00e9es avant leur analyse ou pr\u00e9sentation, en \u00e9liminant les fractions d\u00e9cimales non n\u00e9cessaires.<\/p>\n

La syntaxe de la fonction est la suivante :<\/p>\n

 TRONQUE(nombre; [nombre_chiffres])<\/code> <\/pre>\n
    \n
  • nombre<\/strong> – Le nombre \u00e0 tronquer.<\/li>\n
  • nombre_chiffres<\/strong> (facultatif) – Le nombre de d\u00e9cimales \u00e0 conserver. Si ce param\u00e8tre n’est pas sp\u00e9cifi\u00e9, le nombre sera tronqu\u00e9 \u00e0 l’entier le plus proche.<\/li>\n<\/ul>\n
    Exemple Basique<\/h2>\n
    Consid\u00e9rons le nombre 8.789, que l\u2019on souhaite tronquer \u00e0 une d\u00e9cimale :<\/p>\n
     =TRONQUE(8.789; 1)<\/code> <\/pre>\n
    Cette formule retournera 8.7<\/strong>. Contrairement \u00e0 un arrondi, la fonction TRONQUE \u00e9limine simplement les d\u00e9cimales suppl\u00e9mentaires.<\/p>\n
    Sc\u00e9narios Pratiques d’Application<\/h2>\n
    La fonction TRONQUE<\/strong> est tr\u00e8s utile dans divers contextes, tels que la gestion financi\u00e8re et l’ing\u00e9nierie. Voici deux exemples pratiques :<\/p>\n
    Premier Cas – Pr\u00e9paration de donn\u00e9es financi\u00e8res<\/h2>\n
    Dans les domaines de la comptabilit\u00e9 et de la finance, il est souvent n\u00e9cessaire de tronquer des montants pour se conformer \u00e0 des normes de reporting pr\u00e9cises. Prenons l’exemple du tableau suivant :<\/p>\n\n\n\n\n
    Date<\/th>\nMontant (\u20ac)<\/th>\n<\/tr>\n
    2023-01-01<\/td>\n123.456<\/td>\n<\/tr>\n
    2023-02-01<\/td>\n789.123<\/td>\n<\/tr>\n<\/table>\n
    Pour tronquer ces montants \u00e0 2 d\u00e9cimales, vous utiliserez la formule suivante :<\/p>\n
     =TRONQUE(A2; 2)<\/code> <\/pre>\n
    Ce qui transformera 123.456 en 123.45 et 789.123 en 789.12.<\/p>\n
    Deuxi\u00e8me Cas – Analyse Scientifique<\/h2>\n
    Dans un contexte scientifique, les chercheurs peuvent avoir besoin de tronquer les valeurs pour respecter certaines normes de pr\u00e9cision lors de l’enregistrement de leurs donn\u00e9es. Prenons cet exemple :<\/p>\n\n\n\n\n
    Exp\u00e9rience<\/th>\nTemp\u00e9rature (\u00b0C)<\/th>\n<\/tr>\n
    1<\/td>\n22.34567<\/td>\n<\/tr>\n
    2<\/td>\n24.76543<\/td>\n<\/tr>\n<\/table>\n
    Pour standardiser les temp\u00e9ratures \u00e0 trois d\u00e9cimales, l’application de la formule suivante est n\u00e9cessaire :<\/p>\n
     =TRONQUE(B2; 3)<\/code> <\/pre>\n
    Ce qui donnera 22.345 pour la premi\u00e8re mesure et 24.765 pour la seconde.<\/p>\n
    Ainsi, la fonction TRONQUE<\/strong> est primordiale pour ma\u00eetriser la pr\u00e9cision des donn\u00e9es dans de nombreuses applications, garantissant que les nombres sont simplifi\u00e9s \u00e0 un nombre sp\u00e9cifique de d\u00e9cimales sans arrondissement.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Renvoie la paRtie enti\u00e8Re 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-6821","post","type-post","status-publish","format-standard","hentry","category-mathematiques-et-trigonometrie"],"acf":[],"yoast_head":"\nFonction TRUNC (TRONQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) 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\/trunc\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction TRUNC (TRONQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/trunc\/\" \/>\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:15: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 TRUNC (TRONQUE) 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\/trunc\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/trunc\/\",\"name\":\"Fonction TRUNC (TRONQUE) 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:15:39+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/trunc\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/trunc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/trunc\/#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\":\"TRONQUE\"}]},{\"@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 TRUNC (TRONQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) 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\/trunc\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction TRUNC (TRONQUE) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/trunc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:15:39+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction TRUNC (TRONQUE) 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\/trunc\/","url":"https:\/\/functiontranslator.com\/fr\/trunc\/","name":"Fonction TRUNC (TRONQUE) 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:15:39+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction TRUNC (TRONQUE) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/trunc\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/trunc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/trunc\/#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":"TRONQUE"}]},{"@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\/6821","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=6821"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6821\/revisions"}],"predecessor-version":[{"id":29830,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6821\/revisions\/29830"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6821"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6821"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6821"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}