{"id":1497,"date":"2018-07-04T15:14:23","date_gmt":"2018-07-04T15:14:23","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1497"},"modified":"2023-11-03T13:35:40","modified_gmt":"2023-11-03T13:35:40","slug":"rounddown","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/","title":{"rendered":"ROUNDDOWN function"},"content":{"rendered":"\n<p>Excel ROUNDDOWN Function is a handy tool that helps you round a number down to a specified number of decimal places. This can be useful when you want to truncate a number to a certain precision or simplify calculations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>ROUNDDOWN(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><strong>number<\/strong><\/td><td>The number you want to round down.<\/td><\/tr><tr><td><strong>[num_digits]<\/strong><\/td><td>The number of decimal places to which you want to round down. If this argument is negative, it will round down to the left of the decimal point. (Optional)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to Use<\/h2>\n\n\n\n<p>Let&#8217;s dive into how to use the ROUNDDOWN function with a few examples:<\/p>\n\n\n\n<p><strong>Example 1:<\/strong> Rounding down to a specific number of decimal places<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUNDDOWN(12.3456, 2)<\/code><\/pre>\n\n\n\n<p>In this example, we are rounding the number 12.3456 down to 2 decimal places, resulting in 12.34.<\/p>\n\n\n\n<p><strong>Example 2:<\/strong> Rounding down to the nearest integer<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUNDDOWN(15.789)<\/code><\/pre>\n\n\n\n<p>Here, we are rounding down 15.789 to the nearest whole number, which gives us 15.<\/p>\n\n\n\n<p><strong>Example 3:<\/strong> Rounding down to the left of the decimal point<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUNDDOWN(12345, -2)<\/code><\/pre>\n\n\n\n<p>In this case, we&#8217;re rounding down 12345 to the nearest hundred, resulting in 12300.<\/p>\n\n\n\n<p><strong>Example 4:<\/strong> Using the optional argument<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=ROUNDDOWN(9876.54321, -3)<\/code><\/pre>\n\n\n\n<p>By specifying -3 as the num_digits argument, we&#8217;re rounding down to the thousands, giving us 9000.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Additional Information<\/h2>\n\n\n\n<p>It&#8217;s important to note that the ROUNDDOWN function always rounds down towards negative infinity. This means it will reduce the value of the number, making it less than or equal to the original number, and it does not round up.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel ROUNDDOWN Function is a handy tool that helps you round a number down to a specified number of decimal places. This can&#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>ROUNDDOWN 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\/rounddown\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ROUNDDOWN function\" \/>\n<meta property=\"og:description\" content=\"Excel ROUNDDOWN Function is a handy tool that helps you round a number down to a specified number of decimal places. This can...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T15:14:23+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T13:35:40+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\/rounddown\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"ROUNDDOWN function\",\"datePublished\":\"2018-07-04T15:14:23+00:00\",\"dateModified\":\"2023-11-03T13:35:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\"},\"wordCount\":235,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\",\"name\":\"ROUNDDOWN function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T15:14:23+00:00\",\"dateModified\":\"2023-11-03T13:35:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/rounddown\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ROUNDDOWN 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":"ROUNDDOWN 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\/rounddown\/","og_locale":"en_US","og_type":"article","og_title":"ROUNDDOWN function","og_description":"Excel ROUNDDOWN Function is a handy tool that helps you round a number down to a specified number of decimal places. This can...","og_url":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/","article_published_time":"2018-07-04T15:14:23+00:00","article_modified_time":"2023-11-03T13:35:40+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\/rounddown\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"ROUNDDOWN function","datePublished":"2018-07-04T15:14:23+00:00","dateModified":"2023-11-03T13:35:40+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/"},"wordCount":235,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/","url":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/","name":"ROUNDDOWN function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T15:14:23+00:00","dateModified":"2023-11-03T13:35:40+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/rounddown\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/rounddown\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"ROUNDDOWN 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\/1497"}],"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=1497"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1497\/revisions"}],"predecessor-version":[{"id":16559,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1497\/revisions\/16559"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1497"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1497"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1497"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}