FUNCTION CATALOGUE / MATH & TRIGONOMETRY
INT Excel function
Rounds a number down to the nearest integer.
Correct sentence to use
Round [cell] down to an integer.
Modify this query in PlainFormula →Example formula
=INT(A2)
Rounds a number down toward negative infinity to an integer.
Syntax
INT(number)
Argument signature: number
Compatibility: Commonly available in current Excel; verify platform and locale-specific behaviour.