TRUNC Function

The TRUNC () is a math and trig function which takes ‘number,num_digits’ as argument and truncates a number to an integer value by removing the fractional part of the number.

Formula:


=TRUNC(number,num_digits)
In the above syntax, "number" denotes the number which we want to truncate, "num_digits" denotes the number which specifies the precision of the truncation.

Video Tutorial:


Let us see how this trunc function truncates the values using the below video.

Learn MS Excel


Ask Questions

Ask Question