{"id":1215,"date":"2018-07-02T17:09:42","date_gmt":"2018-07-02T17:09:42","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1215"},"modified":"2023-11-03T10:06:30","modified_gmt":"2023-11-03T10:06:30","slug":"int","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/int\/","title":{"rendered":"INT function"},"content":{"rendered":"\n<p>Excel INT Function is a simple yet useful mathematical function that helps you round down a number to the nearest integer. In simpler terms, it takes a decimal number and converts it into a whole number by removing the decimal part. This can be handy for scenarios where you need whole numbers and don&#8217;t want to round up or round to the nearest integer.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Syntax<\/h2>\n\n\n\n<p><strong>=INT(number)<\/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 to the nearest integer.<\/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 explore how to use the INT function with a few examples:<\/p>\n\n\n\n<p><strong>Example 1:<\/strong> Basic usage<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INT(7.8)<\/code><\/pre>\n\n\n\n<p>In this case, the INT function will round down 7.8 to the nearest integer, which is 7.<\/p>\n\n\n\n<p><strong>Example 2:<\/strong> Handling negative numbers<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INT(-5.4)<\/code><\/pre>\n\n\n\n<p>Here, the function will round down -5.4 to the nearest integer, which is -6.<\/p>\n\n\n\n<p><strong>Example 3:<\/strong> Rounding a whole number<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INT(42)<\/code><\/pre>\n\n\n\n<p>Even if you provide a whole number, the INT function will not change it. It will return 42 as it is.<\/p>\n\n\n\n<p><strong>Example 4:<\/strong> Using the INT function with other formulas<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INT(SUM(3.5, 4.2))<\/code><\/pre>\n\n\n\n<p>You can also use the INT function in combination with other functions, like SUM. Here, it will first calculate the sum of 3.5 and 4.2, which is 7.7, and then round it down to 7 using the INT function.<\/p>\n\n\n\n<p><strong>Example 5:<\/strong> Handling optional arguments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=INT(&#91;9.9])<\/code><\/pre>\n\n\n\n<p>When an argument is enclosed in square brackets and marked as (Optional), it means you can omit it. In this case, the INT function will still work with just the number provided, rounding down 9.9 to 9.<\/p>\n\n\n\n<p>Excel&#8217;s INT function is a helpful tool for quickly converting decimal numbers to integers. Whether you&#8217;re working with financial data, grades, or any situation where whole numbers matter, INT simplifies the process.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel INT Function is a simple yet useful mathematical function that helps you round down a number to the nearest integer. In simpler&#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>INT 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\/int\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"INT function\" \/>\n<meta property=\"og:description\" content=\"Excel INT Function is a simple yet useful mathematical function that helps you round down a number to the nearest integer. In simpler...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/int\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T17:09:42+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T10:06:30+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\/int\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/int\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"INT function\",\"datePublished\":\"2018-07-02T17:09:42+00:00\",\"dateModified\":\"2023-11-03T10:06:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/int\/\"},\"wordCount\":276,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/int\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/int\/\",\"name\":\"INT function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-02T17:09:42+00:00\",\"dateModified\":\"2023-11-03T10:06:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/int\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/int\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/int\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"INT 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":"INT 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\/int\/","og_locale":"en_US","og_type":"article","og_title":"INT function","og_description":"Excel INT Function is a simple yet useful mathematical function that helps you round down a number to the nearest integer. In simpler...","og_url":"https:\/\/officetuts.net\/excel\/functions\/int\/","article_published_time":"2018-07-02T17:09:42+00:00","article_modified_time":"2023-11-03T10:06:30+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\/int\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/int\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"INT function","datePublished":"2018-07-02T17:09:42+00:00","dateModified":"2023-11-03T10:06:30+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/int\/"},"wordCount":276,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/int\/","url":"https:\/\/officetuts.net\/excel\/functions\/int\/","name":"INT function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-02T17:09:42+00:00","dateModified":"2023-11-03T10:06:30+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/int\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/int\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/int\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"INT 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\/1215"}],"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=1215"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1215\/revisions"}],"predecessor-version":[{"id":16488,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1215\/revisions\/16488"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}