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 |
|
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top