{"id":3420,"date":"2014-03-04T15:09:47","date_gmt":"2014-03-04T09:39:47","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3420"},"modified":"2024-04-17T08:31:54","modified_gmt":"2024-04-17T03:01:54","slug":"excel-int-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-int-function\/","title":{"rendered":"How to Use Excel INT Function (Examples + Video)"},"content":{"rendered":"<p>In this tutorial, you&#8217;ll learn how to use the INT function in Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">This Tutorial Covers:<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Excel-INT-Function-Overview\" >Excel INT Function Overview<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#When-to-use-Excel-INT-Function\" >When to use Excel INT Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#What-it-Returns\" >What it Returns<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Syntax\" >Syntax<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Input-Arguments\" >Input Arguments<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Excel-INT-Function-Examples\" >Excel INT Function Examples<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Example-1-%E2%80%93-Getting-the-Integer-Part-from-a-Positive-number\" >Example 1 &#8211; Getting the Integer Part from a Positive number<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Example-2-%E2%80%93-Getting-the-Integer-Part-from-a-Negative-number\" >Example 2 &#8211; Getting the Integer Part from a Negative number<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Example-3-%E2%80%93-Getting-the-Age-using-Date-of-Birth\" >Example 3 &#8211; Getting the Age using Date of Birth<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#Video-Tutorial\" >Video Tutorial<\/a><\/li><\/ul><\/nav><\/div>\n\n<h2><span class=\"ez-toc-section\" id=\"Excel-INT-Function-Overview\"><\/span><span style=\"color: #800000;\">Excel INT Function Overview<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-3261 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/INT-FORMULA-EXCEL.png\" alt=\"Excel INT Function\" width=\"450\" height=\"330\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/INT-FORMULA-EXCEL.png 752w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/INT-FORMULA-EXCEL-409x300.png 409w\" sizes=\"(max-width: 450px) 100vw, 450px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"When-to-use-Excel-INT-Function\"><\/span><span style=\"color: #800000;\">When to use Excel INT Function<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>INT Function is used when you want to get the integer portion of a number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"What-it-Returns\"><\/span><span style=\"color: #800000;\">What it Returns<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>It returns an integer\u00a0number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Syntax\"><\/span><span style=\"color: #800000;\">Syntax<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>=INT(number)<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Input-Arguments\"><\/span><span style=\"color: #800000;\">Input Arguments<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><b>number &#8211; <\/b>the number for which you want\u00a0to get the integer value.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Excel-INT-Function-Examples\"><\/span><span style=\"color: #800000;\">Excel INT Function Examples<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Below are three examples of using the INT function in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example-1-%E2%80%93-Getting-the-Integer-Part-from-a-Positive-number\"><\/span>Example 1 &#8211; Getting the Integer Part from a Positive number<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When you use INT function with a positive integer, it\u00a0discards the decimal part and gives you the integer part of the number.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-25953 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1.png\" alt=\"Excel INT Function - Example 1\" width=\"556\" height=\"124\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1.png 556w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1-50x11.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1-250x56.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1-400x89.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-1-350x78.png 350w\" sizes=\"(max-width: 556px) 100vw, 556px\" \/><\/p>\n<p>For example, in the above example, it returns 4 as the function <a href=\"https:\/\/trumpexcel.com\/round-to-nearest-integer\/\">rounds down<\/a> the value in cell A2.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example-2-%E2%80%93-Getting-the-Integer-Part-from-a-Negative-number\"><\/span>Example 2 &#8211; Getting the Integer Part from a Negative number<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>When you use the INT function with a negative number, it rounds down the number. This means that you get the number which is lower that the given number.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-25952 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2.png\" alt=\"Excel INT Function - Example 2\" width=\"539\" height=\"112\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2.png 539w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2-50x10.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2-250x52.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2-400x83.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-2-350x73.png 350w\" sizes=\"(max-width: 539px) 100vw, 539px\" \/><\/p>\n<p>In the above example, the result is -5, which is lower than -4.89.<\/p>\n<p>So instead of giving you the integer part (as it did in Example 1), it gives you the number which is an integer and lower than the given number.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Example-3-%E2%80%93-Getting-the-Age-using-Date-of-Birth\"><\/span>Example 3 &#8211; Getting the Age using Date of Birth<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can use the INT function to get the <a href=\"https:\/\/trumpexcel.com\/calculate-age-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">age of a person using their date of birth<\/a>.<\/p>\n<p>To do this, you need to use it along with TODAY and YEARFRAC functions.<\/p>\n<p>Suppose the date of birth is 14 May 1988, then you can use the below formula to calculate the age in Excel:<\/p>\n<pre>=INT(YEARFRAC(A2,TODAY()))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-25956 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3.png\" alt=\"Excel INT Function - Example 3\" width=\"766\" height=\"111\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3.png 766w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3-600x87.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3-50x7.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3-250x36.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3-400x58.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2014\/03\/Excel-INT-Function-Example-3-350x51.png 350w\" sizes=\"(max-width: 766px) 100vw, 766px\" \/><\/p>\n<p>YEARFRAC formula takes the date of birth and the current date (which is given by the <a href=\"https:\/\/trumpexcel.com\/excel-today-function\/\" target=\"_blank\" rel=\"noopener\">TODAY function<\/a>) and returns the age in years. It has the integer as well as the <a href=\"https:\/\/trumpexcel.com\/display-numbers-as-fractions-excel\/\" target=\"_blank\" rel=\"noopener\">fraction<\/a> part.<\/p>\n<p>Then the INT function returns only the integer part from it.<\/p>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Video-Tutorial\"><\/span><span style=\"text-decoration: underline;\"><span style=\"color: #800000; text-decoration: underline;\">Video Tutorial<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><iframe title=\"INT Formula in Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/1XLjvkL2VZA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<p><strong><span style=\"color: #800000;\">Related Excel Functions:<\/span><\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-mod-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MOD Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rand-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RAND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-randbetween-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RANDBETWEEN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-round-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel ROUND Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-rank-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel RANK Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-large-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel LARGE Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-max-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MAX Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-min-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel MIN Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-small-function\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel SMALL Function<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-functions\/ln-natural-log\/\">Excel LN Function &#8211; Calculating Natural Log in Excel<\/a><\/li>\n<\/ul>\n<p><strong>Related Excel Tutorials:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/remove-time-from-date-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">How to Remove Time from Date in Excel<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you&#8217;ll learn how to use the INT function in Excel. Excel INT Function Overview When to use Excel INT Function INT Function is used when you want to get the integer portion of a number. What it Returns It returns an integer\u00a0number. Syntax =INT(number) Input Arguments number &#8211; the number for which &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Use Excel INT Function (Examples + Video)\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/excel-int-function\/#more-3420\" aria-label=\"Read more about How to Use Excel INT Function (Examples + Video)\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[153],"tags":[19],"class_list":["post-3420","post","type-post","status-publish","format-standard","hentry","category-excel-functions","tag-excel-how-tos"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=3420"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/3420\/revisions"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=3420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=3420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=3420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}