trunc函数使⽤⽅法_如何在Excel中使⽤TRUNC函数
trunc函数使⽤⽅法
辣椒炒土豆片There are a variety of ways in Excel to remove decimal points and shortening number values. In this article, we explain how to u the TRUNC function and what makes it different from other techniques.
Excel中有多种删除⼩数点和缩短数字值的⽅法。 在本⽂中，我们解释了如何使⽤TRUNC函数以及它与其他技术的不同之处。
什么是TRUNC函数？ (What Is the TRUNC Function?)
The TRUNC function truncates a number to a specified number of decimal places. The key factor that makes TRUNC different from other functions that remove decimal places is that the TRUNC function does not round values. If you u TRUNC to remove all the decimals from the value 4.68, the result is 4.
TRUNC函数将数字截断为指定的⼩数位数。 使TRUNC与其他删除⼩数位的函数不同的关键因素是TRUNC函数不会舍⼊值。 如果使⽤TRUNC从值4.68中删除所有⼩数，则结果为4。
杜威的著作
The TRUNC function requires two pieces of information:
TRUNC函数需要两条信息：
=TRUNC(number, [digits])
The number is the value you want to truncate. Digits are the number of numerals you want to truncate the value to. The digits portion is optional, and if not answered, TRUNC will remove all decimal places.
该数字是您要截断的值。 数字是您要将值截断到的数字数量。 数字部分是可选的，如果未回答，则TRUNC将删除所有⼩数位。
如何使⽤TRUNC功能 (How to U the TRUNC Function)
Let’s look at examples of the TRUNC function with some sample data. The below example us the following TRUNC function.
让我们看⼀下带有⼀些样本数据的TRUNC函数的⽰例。 下⾯的⽰例使⽤以下TRUNC函数。壮阳汤
=TRUNC(A2)
If you do not specify how many digits to truncate, all decimal places will be removed.
如果未指定截断位数，则将删除所有⼩数位。
You can e with the value in cell A2 that the TRUNC function does not apply any rounding. It simply truncates the number to 411.
从单元格A2中的值可以看到TRUNC函数不应⽤任何舍⼊。 它只是将数字截断为411。
Let’s e another example. This time we will reduce the values to two decimal places.
让我们来看另⼀个例⼦。 这次我们将值减少到两位⼩数。
大商场=TRUNC(A2,2)
The TRUNC function will not display extra decimals if you ask it to show more than you have.我心爱的宝贝
如果您要求TRUNC函数显⽰的⼩数位数过多，将不会显⽰该位数。
Take the following example, and let’s truncate it to two decimal places.
以下⾯的⽰例为例，让我们将其截断为两位⼩数。
=TRUNC(A2,2)
The value in cell A4 is reduced to two decimal places, but the values in A2 and A3 stay as they are becau they have less than two decimal places already.
单元格A4中的值减少到两位⼩数，但A2和A3中的值保持原样，因为它们已经少于两位⼩数了。
If you want to display the two decimals, the cells will need to be formatted to be forced to show them.
如果要显⽰两个⼩数，则需要格式化单元格以强制显⽰它们。
从⽇期时间戳中删除时间 (Remove the Time from a Date-Time Stamp)
A uful example of TRUNC is to remove the time from a date and time stamp in Excel.
TRUNC的⼀个有⽤⽰例是从Excel中的⽇期和时间戳中删除时间。
Imagine having the following date and time stamps, but we just want the date in a column for analysis.假设有以下⽇期和时间戳，但我们只希望将⽇期放在⼀列中进⾏分析。顶级发型师
机箱跳线接法图解The following formula will work to remove the time.
中国最长的名字下⾯的公式将节省时间。
=TRUNC(A2)
Although the time is removed, the resulting cells will still need to be formatted as a date only.
尽管删除了时间，但仍然需要将⽣成的单元格仅格式化为⽇期。
使⽤TRUNC缩短数字 (U TRUNC to Shorten Numbers)
This is a rare technique, but it is worth knowing that the TRUNC function will also accept negative numbers for the digits argument. When you u a negative number, the formula truncates the numbers to the left of the decimal point. However, it does not change the number of digits. It will replace them with zeroes.
这是⼀种罕见的技术，但值得⼀提的是，TRUNC函数还将为digits参数接受负数。 当您使⽤负数时，该公式将截断⼩数点左边的数字。 但是，它不会更改位数。 它将⽤零代替它们。
Let’s look at the following example.
让我们看下⾯的例⼦。
=TRUNC(A2,-1)
You can e in each example that zero was ud to replace the number that was removed from the left of the decimal point.
您可以在每个⽰例中看到⽤零代替从⼩数点左侧删除的数字。
There are multiple ways in Excel to remove decimal places, however, most of the will apply a rounding of some nature. The strength of the TRUNC function is that it does not round values and simply shortens them to the specified decimal place amount.
Excel中有多种删除⼩数位的⽅法，但是，其中⼤多数将采⽤某种舍⼊⽅式。 TRUNC函数的优势在于它不会四舍五⼊，⽽只是将它们缩短到指定的⼩数位数。
trunc函数使⽤⽅法
