{"id":1233,"date":"2018-07-02T17:15:01","date_gmt":"2018-07-02T17:15:01","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1233"},"modified":"2023-11-03T15:06:54","modified_gmt":"2023-11-03T15:06:54","slug":"trunc","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/trunc\/","title":{"rendered":"TRUNC function"},"content":{"rendered":"\n<p>Excel TRUNC function is used to truncate a number to a specified number of decimal places. It simply removes the decimal part of a number and returns the integer portion. This function can be helpful when you want to simplify or round down a number to a specific precision.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>TRUNC(number, [num_digits])<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Arguments<\/h2>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><b>number<\/b><\/td><td>The number you want to truncate. It can be a positive or negative number.<\/td><\/tr><tr><td><b>[num_digits]<\/b><\/td><td>(Optional) The number of decimal places to which you want to truncate the &#8216;number.&#8217; If not provided, it defaults to 0, meaning the number will be truncated to the nearest whole number.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use<\/h2>\n\n\n\n<p>The TRUNC function is quite straightforward. Let&#8217;s look at some examples to understand how to use it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TRUNC(12.345, 2)<\/code><\/pre>\n\n\n\n<p>This formula will truncate the number 12.345 to 2 decimal places, resulting in 12.34.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TRUNC(7.9876, 0)<\/code><\/pre>\n\n\n\n<p>Here, it truncates the number 7.9876 to 0 decimal places, which essentially rounds it down to the nearest whole number, giving you 7.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=TRUNC(-15.789, 1)<\/code><\/pre>\n\n\n\n<p>Even negative numbers can be truncated. This formula truncates -15.789 to 1 decimal place, yielding -15.7.<\/p>\n\n\n\n<p>Remember, if you don&#8217;t specify the [num_digits] argument, it defaults to 0, and the function will remove the decimal part, rounding down to the nearest whole number.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>TRUNC is a simple and useful function for dealing with numbers in Excel. It&#8217;s particularly handy for financial calculations and scenarios where you need to work with specific decimal precision. If you want to round numbers differently (e.g., round to the nearest integer), you may consider using the ROUND function instead.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel TRUNC function is used to truncate a number to a specified number of decimal places. It simply removes the decimal part of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>TRUNC function<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"TRUNC function\" \/>\n<meta property=\"og:description\" content=\"Excel TRUNC function is used to truncate a number to a specified number of decimal places. It simply removes the decimal part of...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:15:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T15:06:54+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"TRUNC function\",\"datePublished\":\"2018-07-02T17:15:01+00:00\",\"dateModified\":\"2023-11-03T15:06:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\"},\"wordCount\":255,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\",\"name\":\"TRUNC function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:15:01+00:00\",\"dateModified\":\"2023-11-03T15:06:54+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/trunc\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/trunc\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"TRUNC function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"TRUNC function","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:\/\/officetuts.net\/excel\/functions\/trunc\/","og_locale":"en_US","og_type":"article","og_title":"TRUNC function","og_description":"Excel TRUNC function is used to truncate a number to a specified number of decimal places. It simply removes the decimal part of...","og_url":"https:\/\/officetuts.net\/excel\/functions\/trunc\/","article_published_time":"2018-07-02T17:15:01+00:00","article_modified_time":"2023-11-03T15:06:54+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"TRUNC function","datePublished":"2018-07-02T17:15:01+00:00","dateModified":"2023-11-03T15:06:54+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/"},"wordCount":255,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/","url":"https:\/\/officetuts.net\/excel\/functions\/trunc\/","name":"TRUNC function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:15:01+00:00","dateModified":"2023-11-03T15:06:54+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/trunc\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/trunc\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"TRUNC function"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1233"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1233"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1233\/revisions"}],"predecessor-version":[{"id":16626,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1233\/revisions\/16626"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}