Excel INT function

Function              INT

Description        Excel INT function round down a number and take out the integer part.

Syntax  INT(number)

number  The numerical value to be rounder down.

Example:

=INT(9.54)=9

=INT(-9.54)=10

Usage Note:

  • INT function round down so negative number goes away from zero