Trunc

Syntax

Trunc(Value[, Precision])

Parameters

Value. The number to truncate.

Precision. Number of decimal position determining truncate accuracy. Positive values truncate fractional part, negative values truncate integer part, zero truncates a value to integer. The default value is 0.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It truncates a number to the specified number of decimal places.

Example

Formula	Result	Description
=Trunc(21.525,1)	21,5	It truncates the 21.525 number to an integer with the precision of one tenth.
=Trunc(21.525,-1)	20	It truncates the integral part of the 21.525 number.
=Trunc(B6)	-4	It truncates the number in the B6 cell to an integer. The B6 cell contains the -4.6 number.