在这篇文章中,我们将向您展示如何在Microsoft Excel中使用(Microsoft Excel)INT和LCM 函数(LCM Functions)。INT函数将数字向下舍入到最接近的整数。如果数字是负数,它将从零四舍五入。INT函数的公式是INT (number)。LCM函数返回整数的最小公倍数。LCM函数的公式是LCM (number1, [number2] ...)。 INT 和 LCM 都是数学和(Math and Trig)三角函数。
Excel INT和LCM 函数(LCM Functions)的语法
INT
Number:要向下舍入的数字。号码是必需的。
液晶模组
Number1, [number2]:第一个(Number one)是必需的,第二个是可选的。LCM函数可让您找到最小公因数的值。
如何在Excel中使用(Excel)INT 函数(INT Function)
在本教程中,我们将把表格中的小数转换为整数。
单击(Click)要查看结果的单元格,然后键入=INT(A2)。
将光标放在单元格的末尾。您将看到一个加号;把它拖下来。您将在另一个单元格中看到其他结果。
还有其他两个选项可以将INT函数放入单元格中。
选项一是点击fx;将出现插入函数(Insert Function)对话框。
在“插入函数(Insert Function)”对话框中,您可以选择所需的函数类别。选择类别Math and Trig。
在选择(Select)函数列表中,选择INT。
将出现一个函数参数(Function Arguments)对话框。在对话框中,您会看到数字(Number )类型A2或单击单元格A2,它将自动出现在输入框中。
现在,单击确定(OK),您将看到结果。
单击(Click)底部边缘并拖动以查看其他结果。
选项二是转到“公式(Formulas)”选项卡。在函数(Function)和库(Library)组中,单击数学和(Math and Trig)三角函数;在其下拉列表中选择INT 。将出现函数参数(Functions Arguments)对话框。
在Functions Argument对话框的 Number中,键入A2或单击单元格A2,该单元格会自动出现在输入框中。
选择确定(Select OK);你会看到你的结果。
阅读:(Read:) 如何在 Excel 中使用 EDATE 和 EOMONTH 函数(How to use EDATE and EOMONTH Function in Excel)?
如何在Excel中使用(Excel)LCM 函数(LCM Function)
在本教程中,我们要在表格中找到两个数字的LCM。
单击(Click)要放置结果的单元格。类型= LCM,然后是括号。
在括号内,键入A2, B2,然后关闭括号。
按Enter,您将看到结果。
单击(Click)底部边缘并拖动以查看其他结果。
还有两个选项可以将LCM功能放入单元格中。
选项一是点击fx;将出现插入函数(Insert Function)对话框。
在“插入函数(Insert Function)(Insert Function)”对话框中,您可以选择所需的函数类别。选择类别Math and Trig。
在Select , a function 列表中,单击LCM。
将出现一个函数参数(Function Arguments)对话框。在对话框中,您会看到Number 1类型A2或单击单元格A2,它将出现在输入框中。
在number2处,键入B2或单击单元格B2,它将自动出现在输入框中。
现在,单击确定(OK ),您将看到结果。
单击(Click)底部边缘并拖动以查看其他结果。
选项二是去公式(Formulas)。在函数和库组(Function and Library group)中,单击数学和(Math and Trig)三角函数;在其下拉列表中选择LCM 。将出现函数参数(Function Arguments)对话框。
在Functions Arguments对话框中,您会看到Number 1类型A2或单击单元格A2,它将出现在输入框中。
在Number 2处,键入B2或单击单元格B2,它将自动出现在输入框中。
选择确定(O);你会看到你的结果。
我希望这是有帮助的; 如果您有任何问题,请在下方发表评论。
How to use INT and LCM Functions in Excel
In this рost, we will show you how to use INT and LCM Functions in Microsoft Excel. Thе INT function rounds a number down to the nearest integer. If the number is negative, it will round away from zero. The formula for The INT function is INT (number). The LCM function returns the least common multiple of integers. The formula for the LCM function is LCM (number1, [number2] …). Both INT and LCM are Math and Trig Functions.
The syntax for Excel INT and LCM Functions
INT
Number: The number in which you want to round down. The number is required.
LCM
Number1, [number2]: Number one is required, number two is optional. LCM functions let you find values for the least common factor.
How to use the INT Function in Excel
In this tutorial, we are going to turn the decimal inside the table into integers.
Click the cell where you want to see the result, then type =INT(A2).
Place the cursor at the end of the cell. You will see a plus symbol; drag it down. You will see the other results in the other cell.
There are two other options that you can place the INT function into the cell.
Option number one is to click on fx; an Insert Function dialog box will appear.
In the Insert Function dialog box, you can select the category of function you want. Select the category Math and Trig.
In the Select a function list, select INT.
A Function Arguments dialog box will appear. In the dialog box, where you see Number type A2 or click the cell A2, it will automatically appear in the entry box.
Now, click OK you will see your result.
Click on the bottom edge and drag to see other results.
Option Two is to go to the Formulas tab. In the Function and Library group, click Math and Trig; select INT in its drop-down list. Functions Arguments dialog box will appear.
In the Functions Argument dialog box, at Number, type A2 or click the cell A2, which automatically appears in the entry box.
Select OK; you will see your results.
Read: How to use EDATE and EOMONTH Function in Excel?
How to use the LCM Function in Excel
In this tutorial, we want to find the LCM of two numbers in our table.
Click the cell where you want to place the result. Type = LCM then bracket.
Inside the bracket, type A2, B2, then close the bracket.
Press Enter, you will see your result.
Click on the bottom edge and drag to see the other results.
There are two more options that you can place the LCM function into the cell.
Option number one is to click on fx; an Insert Function dialog box will appear.
In the Insert Function dialog box, you can select the category of function you want. Select the category Math and Trig.
In the Select, a function list, click LCM.
A Function Arguments dialog box will appear. In the dialog box, where you see Number 1 type A2 or click the cell A2, it will appear in the entry box.
At number2, type B2 or click the cell B2, which will automatically appear in the entry box.
Now, click OK you will see your result.
Click on the bottom edge and drag to see other results.
Option Two is to go to the Formulas. In the Function and Library group, click Math and Trig; select LCM in its drop-down list. Function Arguments dialog box will appear.
In the Functions Arguments dialog box, where you see Number 1 type A2or click the cell A2, it will appear in the entry box.
At Number 2, type B2 or click the cell B2, which will automatically appear in the entry box.
Select OK; you will see your results.
I hope this is helpful; if you have questions, please comment below.