All functions / Math
TRUNC
Cuts off the decimal part of a number.
Syntax
=TRUNC(number, [num_digits])
Arguments
number: The number to use.num_digits(optional): Digits to keep (default 0).
Example
=TRUNC(-7.9) → -7
All functions / Math
Cuts off the decimal part of a number.
=TRUNC(number, [num_digits])
number: The number to use.num_digits (optional): Digits to keep (default 0).=TRUNC(-7.9) → -7