INT
Rounds a number down to the nearest integer.
Math & TrigonometryMath Basics
What it does
Rounds a number down to the nearest integer (always toward negative infinity).
Syntax
INT(number)
Arguments
number(number) — Value to round.
Examples
Integer Part
Round 5.8 down.
FORMULA
=INT(5.8)
RESULT
5
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 5.8 |