TRUNC function. Truncate a number to the specified number of digits or less.(Microsoft Excel)

Japanese version.

The TRUNC function truncates a number less than a specified digit.

How it works

=TRUNC(Number,Num_digits)
ParameterOmissionDescription
NumberRequired field.Specifies the number to be truncated.
Num_digits0Specifies the number of digits to truncate (see below).
Num_digits...-2-1012...
The digits to be truncated....less than 100 place.less than 10 place.Less than 1 place.To the first decimal place.To two decimal place....
Num_digits

Demonstrate

TRUNC function results by number of digits.

Num_digitsResult
-31000
-21200
-11230
01234
11234.5
21234.56
31234.567
Num_digits and function results.
Num_digits and function results.

Spill

Spill if the parameters is a cell range.

---

Links

Microsoft Excel Functions Math & Trig