In this article, we will learn about how to use the INT function in Excel.The INT function returns the Integer part of the value. Syntax:=INT (number)The function returns a value error if any text is input as argument.Let’s understand this function using it an example. Use the ...
number – the number for which you want to get the integer value.Excel INT Function ExamplesBelow are three examples of using the INT function in Excel.Example 1 – Getting the Integer Part from a Positive numberWhen you use INT function with a positive integer, it discards the decimal part...
Method 5– Use the INT Function and the YEARFRAC Functions in Excel To calculate the Employee’s age in Integers. Step 1: Select F5 and enter the following formula: =INT(YEARFRAC(C5, D5)) Press Enter. John’s age is 22. Step 2: Drag down the Fill Handle to see the result in the...
=INT(A2)Result:2 =INT(A3)Result:-3 =INT(-4.5)Result:-5 Example (as VBA Function) The INT function can also be used in VBA code in Microsoft Excel. Let's look at some Excel INT function examples and explore how to use the INT function in Excel VBA code: Dim LNumber As Double ...
IF(FALSE,"Text", INT(B3)) Step 3 - Evaluate the INT function INT(B3) becomes INT(1.9) and returns 1. Back to top 8. Split date from a date and time value The INT function removes the decimals from a number which is useful while manipulating Excel dates. An Excel date and time ...
=B5-(INT(B5/C5)*C5) ➤ After pressingEnterand auto-filling the entire column with theFill Handle, you’ll find all the remainder at once. Things to Keep in Mind MODfunction always returns a similar+/-sign as the divisor. The divisor must be an integer value in the MOD function. Ot...
Even though the INT function is also used for returning the integer part, it has a drawback. When the INT function in excel is used for negative numbers, it rounds the value to a lower number instead of the resulting integer. The present article explains the use of the TRUNC function in...
Examples of TODAY function This section is talking about how to use the TODAY function in Excel. Example 1: Return current date in Excel If you want to return the current system date in a cell, please click on it, enter=TODAY()into the Formula Bar and press theEnterkey. ...
How to Use Trunc in Excel? The Trunc function is similar to the INT function in Excel because both functions give us the result for the integer part of the number. The Trunc function has two arguments where one is mandatory, and one is optional. The mandatory argument is the integer input...
The MOD function can also be represented in terms of the INT function: MOD(n, d)=n-d*INT(n/d) Where n=number, d=divisor Recommended Articles This has been a guide to the Excel MOD function. Here we discuss the MOD Formula and how to use the MOD function, along with practical exam...