TRUNC function


Truncate a number to a given precision.



=TRUNC( number[num_digits] )


required arguments:

number The number to truncate.


optional arguments:

[num_digits] The precision of the truncation.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.