Goal: Convert a decimal to an integer.
INT rounds a number down to the nearest integer.
Ready...
💻 Formula Structure
=INT(number)
- 1. Number: The real number you want to round down to an integer.
-- Round down to nearest Integer
=INT( 5.8 )
⚠️ Common Pitfalls
🚫 INT vs TRUNC
TRUNC removes the decimal (-5.8 ➝ -5).
INT rounds down (-5.8 ➝ -6).
Be careful with negative numbers!