TRUNC(number [,num_digits])

Returns the number with any decimal places removed.

numberThe number you want to truncate.
num_digits(Optional) The number specifying the precision of the truncation.

Remarks

* This function is similar to the INT function.
* If the "num_digits" is left blank then 0 is used.
* You can use the INT function to return a number rounded down to the nearest integer.
* For the Microsoft documentation refer to support.office.com

 A
1=TRUNC(18.978) = 18
2=TRUNC(12.345,1) = 12.3
3=TRUNC(8.9) = 8
4=TRUNC(PI()) = 3
5=TRUNC(-4.3,1) = -4.3
6=TRUNC(-4.9) = -4
7=TRUNC(-4.3) = -4
8=TRUNC(4.3) = 4
9=TRUNC(4.9) = 4
10=TRUNC(-4.3,2) = -4.3
11=TRUNC("some text") = #VALUE!


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top