INT Function Examples – Excel, VBA, & Google Sheets

This tutorial demonstrates how to use the Excel INT Function in Excel to round a number down to the nearest integer (truncate the number).

INT Function Overview

The INT Function Rounds a number down to the nearest integer.

To use the INT Excel Worksheet Function, select a cell and type:
int formula syntax

(Notice how the formula inputs appear)

INT Function Syntax and Inputs:

=INT(number)

number – A number.

AutoMacro - VBA Code Generator

INT in Google Sheets

The INT Function works exactly the same in Google Sheets as in Excel:

 

INT Examples in VBA

You can also use the INT function in VBA. Type:
application.worksheetfunction.int(number)
For the function arguments (number, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel

Excel Practice Worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!