TRUNC Function Explained
The TRUNC function in Microsoft Excel is used to truncate a number to a specified number of decimal places. It removes all digits after the specified decimal place, leaving the rest of the number unchanged. It takes two arguments: the number to be truncated and the number of decimal places to which it should be truncated.
TRUNC Function Syntax
TRUNC(number, [num_digits])
- number: The number that you want to truncate.
- num_digits: (optional) The number of digits that you want to keep in the number after the decimal point. If omitted, Excel truncates the number to an integer.