Which number function returns the largest integer value that is equal to or less than a number floor () Celi () trunc () MOD ()?
Removes the fractional part of a number and it to an integer Show
What is the TRUNC Function?The TRUNC Function[1] is an Excel Math and Trigonometry function. It removes the fractional part of a number and, thus, truncates a number to an integer. It was introduced in MS Excel 2007. In financial analysis, the function can be used to truncate a number to a given precision. It is also useful for extracting dates from date and time values. Formula=TRUNC(number,[num_digits]) The TRUNC function uses the following arguments:
Now, if the num_digits argument is:
How to use the TRUNC Function in Excel?To understand the uses of the TRUNC function, let’s consider a few examples: Example 1Suppose we are given the following data: We get the results below: The TRUNC function does not round off but simply truncates a number as specified. The function can also be used to return a set number of decimal places without rounding off using the num_digits argument. For example, =TRUNC(PI(),2) will return Pi value truncated to two decimal digits, which is 3.14, and =TRUNC(PI(),3) will return Pi value truncated to three decimal places, which is 3.141. Example 2Suppose we are given the following dates and time from an external source: The formula to extract the date is: We get the result below: Things to remember about the TRUNC Function
However, for positive numbers, as well as when TRUNC uses 0 as the default for num_digits, both functions will return the same results. With negative numbers, the results can be different. =INT(-2.1) returns -3, because INT rounds down to the lower integer. =TRUNC(-2.1) returns -2. Click here to download the sample Excel file Additional ResourcesThanks for reading CFI’s guide to the Excel TRUNC function. By taking the time to learn and master these Excel functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Article Sources
Which number function returns the largest integer value that is equal to or less than a number in SQL?MySQL FLOOR() Function
The FLOOR() function returns the largest integer value that is smaller than or equal to a number.
Which function returns the largest integer that is less than or equal to its argument?Java - floor() Method
The method floor gives the largest integer that is less than or equal to the argument.
Which of the following number method returns the largest integer?Java Math. min() method with Example. Which method returns the next integer greater than or equal to a given number?ceil() The Math. ceil() function always rounds up and returns the smaller integer greater than or equal to a given number.
|