# TRUNC

TRUNC(number [,num_digits])

Returns the number with any decimal places removed.

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

 REMARKS
 * 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.* 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 of.* 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(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!