{"id":11168,"date":"2025-07-15T13:34:51","date_gmt":"2025-07-15T13:34:51","guid":{"rendered":"https:\/\/functiontranslator.com\/truncar\/"},"modified":"2021-02-25T17:32:12","modified_gmt":"2021-02-25T17:32:12","slug":"trunc","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/","title":{"rendered":"TRUNCAR"},"content":{"rendered":"

Introdu\u00e7\u00e3o \u00e0 Fun\u00e7\u00e3o de Truncamento<\/h2>\n

A fun\u00e7\u00e3o TRUNCAR, dispon\u00edvel tanto no Excel quanto no Google Planilhas, \u00e9 empregada para eliminar os d\u00edgitos fracion\u00e1rios de um n\u00famero, resultando em um valor inteiro sem arredondamento. Essa funcionalidade \u00e9 extremamente \u00fatil em contextos financeiros e matem\u00e1ticos que demandam precis\u00e3o em n\u00fameros inteiros, mantendo os valores originais inalterados.<\/p>\n

Sintaxe e Exemplos<\/h2>\n

A sintaxe para a fun\u00e7\u00e3o TRUNCAR \u00e9 a seguinte:<\/p>\n

=TRUNCAR(n\u00famero; [n\u00fam_d\u00edgitos])<\/code><\/pre>\n
    \n
  • n\u00famero:<\/strong> O n\u00famero que deseja truncar.<\/li>\n
  • n\u00fam_d\u00edgitos (opcional):<\/strong> A quantidade de d\u00edgitos decimais para os quais o n\u00famero ser\u00e1 truncado. Se omitido, o valor padr\u00e3o \u00e9 0.<\/li>\n<\/ul>\n
    Exemplo 1:<\/p>\n
    =TRUNCAR(8.9)<\/code><\/pre>\n
    Resultado: 8<\/strong><\/p>\n
    Exemplo 2:<\/p>\n
    =TRUNCAR(-3.1459, 2)<\/code><\/pre>\n
    Resultado: -3.14<\/strong><\/p>\n
    Casos Pr\u00e1ticos de Uso<\/h2>\n
    Segue uma descri\u00e7\u00e3o de dois cen\u00e1rios pr\u00e1ticos onde a fun\u00e7\u00e3o TRUNCAR pode ser particularmente valiosa:<\/p>\n
    1. Prepara\u00e7\u00e3o de Dados Financeiros<\/h2>\n
    Considere a prepara\u00e7\u00e3o de um relat\u00f3rio financeiro onde \u00e9 necess\u00e1rio que todos os valores monet\u00e1rios sejam representados como n\u00fameros inteiros, em conformidade com normas cont\u00e1beis que excluem centavos.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =TRUNCAR(123.567)<\/code><\/pre>\n
    Esta f\u00f3rmula converte 123.567<\/strong> em 123<\/strong>, removendo as fra\u00e7\u00f5es decimais.<\/p>\n
    2. An\u00e1lise de Dados Cient\u00edficos<\/h2>\n
    Em an\u00e1lises cient\u00edficas, pode ser necess\u00e1rio utilizar somente a parte inteira de uma medida para garantir consist\u00eancia com outros dados coletados.<\/p>\n
    Solu\u00e7\u00e3o:<\/p>\n
    =TRUNCAR(5.991, 1)<\/code><\/pre>\n
    Isso truncar\u00e1 5.991<\/strong> para 5.9<\/strong>, mantendo apenas o primeiro d\u00edgito decimal e descartando os demais, algo crucial para certos tipos de an\u00e1lise precisa.<\/p>\n
    Conclus\u00e3o<\/h2>\n
    A fun\u00e7\u00e3o TRUNCAR prova ser uma ferramenta indispens\u00e1vel no Excel e no Google Planilhas para simplifica\u00e7\u00e3o do tratamento de dados num\u00e9ricos, permitindo manter a precis\u00e3o de n\u00fameros inteiros ou a exatid\u00e3o decimal requerida sem efetuar arredondamentos.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Trunca um n\u00famero para um n\u00famero inteiro<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[437],"tags":[],"class_list":["post-11168","post","type-post","status-publish","format-standard","hentry","category-matematica-e-trigonometria"],"acf":[],"yoast_head":"\nFun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe<\/title>\n<meta name=\"description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\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\/pt-pt\/trunc\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta property=\"og:description\" content=\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-25T17:32:12+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/\",\"url\":\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/\",\"name\":\"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:51+00:00\",\"dateModified\":\"2021-02-25T17:32:12+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/pt-pt\/trunc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fun\u00e7\u00f5es do Excel\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Matem\u00e1tica e trigonometria\",\"item\":\"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"TRUNCAR\"}]},{\"@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\":\"pt-PT\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@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\/pt-pt\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe","description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","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\/pt-pt\/trunc\/","og_locale":"pt_PT","og_type":"article","og_title":"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe","og_description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","og_url":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:51+00:00","article_modified_time":"2021-02-25T17:32:12+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe","twitter_misc":{"Escrito por":"glavadmin","Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/","url":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/","name":"Fun\u00e7\u00e3o TRUNC (TRUNCAR) no Excel \u2013 como funciona, exemplos e sintaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:51+00:00","dateModified":"2021-02-25T17:32:12+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Breve descri\u00e7\u00e3o da fun\u00e7\u00e3o TRUNC (TRUNCAR) do Excel. Sintaxe, par\u00e2metros e exemplos pr\u00e1ticos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/pt-pt\/trunc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/pt-pt\/trunc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fun\u00e7\u00f5es do Excel","item":"https:\/\/functiontranslator.com\/pt-pt\/"},{"@type":"ListItem","position":2,"name":"Matem\u00e1tica e trigonometria","item":"https:\/\/functiontranslator.com\/pt-pt\/matematica-e-trigonometria\/"},{"@type":"ListItem","position":3,"name":"TRUNCAR"}]},{"@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":"pt-PT"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"pt-PT","@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\/pt-pt\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11168","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/comments?post=11168"}],"version-history":[{"count":1,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11168\/revisions"}],"predecessor-version":[{"id":25997,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/posts\/11168\/revisions\/25997"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/media?parent=11168"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/categories?post=11168"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/pt-pt\/wp-json\/wp\/v2\/tags?post=11168"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}