Excel TRUNC Function Syntax and Example

Excel TRUNC Function

TRUNC is numerical function which truncates a number to an integer by removing the specified no.of digits in decimal, fraction portion.

Syntax:

=TRUNC (Value, No.of Digits)

Here:

VALUE which should be a number that you can truncate.

No. Of Digits refers to the size to truncate, if you don’t mention or specifies as zero this ,then the function will truncate entire decimal portion.

Examples:

NUMBER	No.of Digits	TRUNC  Function	Result
1123.6789		=TRUNC(A3)	1123
1123.6789	1	=TRUNC(A3,B3)	1123.6
1123.6789	3	=TRUNC(A4,B4)	1123.678
1123.6789	2	=TRUNC(A5,B5)	1123.67
1123.6789	0	=TRUNC(A6,B6)	1123
TamaTam		=TRUNC(A3)	#VALUE!

Thanks,
TAMATAM