>   >   >

# INT Function

## Rounds a number down to the nearest integer

 by Charley Kyd, MBAMicrosoft Excel MVP, 2005-2014 The Father of Spreadsheet Dashboard Reports

Syntax

INT(number)

• number  Required.

Applies To

Excel 2003 and above.

In Excel, numbers can "round" in two ways.

First, they can round up or down. With this type of rounding, numbers get larger when they are rounded up, and smaller when they are rounded down.

Second, numbers can round towards zero or away from zero. When positive numbers are rounded towards zero, they get smaller; when negative numbers are rounded towards zero, they get larger.

Although Microsoft uses "round up" and "round down" to describe both types of rounding, we use "round up" or "round down" to describe the first type of rounding. And we use "round towards zero" or "round away from zero" to describe the second type.

Examples

You can download this example workbook here, along with all other example workbooks I've completed for this Excel help area.

Other ExcelUser Information

Other Help