Int() Function

-

Int() Function



The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note the INT function rounds down, so negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns -11.


Syntax

The syntax for the INT function in Microsoft Excel is:

=INT( expression )

Parameters or Arguments

expression

A numeric expression whose integer portion is returned.

Excel Int Function Examples

The following spreadsheets show the Excel Int function applied to different numbers:

Formulas:


A
B
1

=INT(100.9)
2
5.22
=INT( A2 )
3
5.99
=INT( A3 )
4
99.5
=INT( A4 )
5
-6.1
=INT( A5 )
6
-100.9
=INT( A6 )

Results:


A
B
1

100
2
5.22
5
3
5.99
5
4
99.5
99
5
-6.1
-7
6
-100.9
-101

The above examples show how the Int function always rounds down. Even with negative numbers, the function rounds down (away from zero).

Comments

Post a Comment

Popular posts from this blog

Using INDEX MATCH MATCH

-
Image
Using INDEX MATCH MATCH If you use  INDEX MATCH  frequently in your worksheets, you may be surprised to learn about an even more powerful version of the formula:  INDEX MATCH MATCH . This variant allows you to look up values across rows and columns simultaneously. Let's take a look at how this new construction works.  Proficiency with the basic  INDEX MATCH  formulation is a prerequisite for this tutorial. If you don't already have a solid grasp of it, check out our basic  INDEX MATCH tutorial first. Defining the problem The following spreadsheet lists two metrics —  Cookie packs sold  and  Revenue  — for SnackWorld by month from January through May. We know how to run an  INDEX MATCH  on either one of these columns to pull a specific metric by month, using the standard formula: = INDEX ( range , MATCH ( lookup_value , lookup_range , match_type )) But, what if we also want to add a flexible input ...
Read more

Trunc() Function

-
Image
Trunc() Function The Excel TRUNC function returns a truncated number based on a given number of digits. For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3. The TRUNC function does no rounding, it simply truncates as specified. Syntax The syntax for the TRUNC function in Microsoft Excel is: =TRUNC( number, [digits] ) Parameters or Arguments number The number to truncate. digits Optional. It is the number of decimal places to display in the resulting truncated number. If this parameter is omitted, the TRUNC function will assume 0. Trunc Function Examples The following spreadsheet shows several examples of the Excel Trunc function: Formulas: A B 1 99.999 =TRUNC( A1, 1 ) 2 99.999 =TRUNC( A2, 2 ) 3 99.999 =TRUNC( A3 ) 4 99.999 =TRUNC( A4, -1 ) 5 -99.999 =TRUNC( A5, 2 ) 6 -99.999 =TRUNC( A6, -1 ) Results: A B 1 99.999 99.9 2 99.999 99.99 ...
Read more

Match() function

-
Image
Match() function MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and  wildcards  (* ?) for partial matches. Often, the  INDEX function  is combined with MATCH to retrieve the value at the position returned by MATCH. Syntax The syntax for the MATCH function in Microsoft Excel is: =MATCH (lookup_value, lookup_array, [match_type]) Parameters or Arguments lookup_value The value to search for in the array. lookup_array A range of cells that contains the value that you are searching for. match_type Optional. It the type of match that the function will perform. The possible values are: Match_type Explanation 1 (default) The MATCH function will find the largest value that is less than or equal to value. You should be sure to sort your array in ascending order. If the match_type parame...
Read more