TRUNC

TRUNC(number [,num_digits])

Returns the number truncated to a number of decimal places.

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

REMARKS

* This function performs no rounding, it just removes unwanted digits.
* If the "num_digits" is left blank then 0 is used.
* If "num_digits" < 0, then the digits to the left of a decimal point are changed to zero. Example 12.
* If "num_digits" is greater than the number of digits, then "number" is returned without any modification.
* You can use the INT function to return a number rounded down to the nearest integer.
* You can use the CEILING.MATH function to round up to the nearest integer or significant figure.
* You can use the FLOOR.MATH function to round down to the nearest integer or significant figure.
* You can use the MROUND function to round to a desired multiple.
* You can use the ROUND function to round to a specified number of digits.
* You can use the ROUNDDOWN function to round down to a specified number of digits.
* You can use the ROUNDUP function to round up to a specified number of digits.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=TRUNC(18.978) = 18
2	=TRUNC(200000.34) = 200000
3	=TRUNC(8.9) = 8
4	=TRUNC(8.9, 0) = 8
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(12.345, 1) = 12.3
12	=TRUNC(1234.5678, -2) = 1200.0
13	=TRUNC(PI()) = 3
14	=TRUNC(PI(), 3) = 3.141
15	=TRUNC(1234.5678, -5) = 0.000
16	=TRUNC("some text") = #VALUE!