TRUNC
Truncates a number to an integer.
Math & TrigonometryMath Basics
What it does
Removes the fractional part of a number (doesn't round).
Syntax
TRUNC(number, [num_digits])
Arguments
number(number) — Value.num_digits(number) — Precision (default 0).
Examples
Truncate
Truncate 8.9.
FORMULA
=TRUNC(8.9)
RESULT
8
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 | 8.9 |