How to use INT and LCM Functions in Excel
In this postal service, we will bear witness y'all how to use INT and LCM Functions in Microsoft Excel. The INT role rounds a number downwards to the nearest integer. If the number is negative, it volition circular abroad from zero. The formula for The INT function is INT (number). The LCM function returns the least mutual multiple of integers. The formula for the LCM part 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 i is required, number two is optional. LCM functions allow y'all discover values for the to the lowest degree common factor.
How to use the INT Function in Excel
In this tutorial, nosotros are going to turn the decimal inside the table into integers.
Click the cell where yous want to see the result, and then blazon =INT(A2).
Identify the cursor at the finish of the jail 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 lot can place the INT role into the cell.
Choice number one is to click on fx; an Insert Function dialog box volition appear.
In the Insert Function dialog box, yous can select the category of function yous want. Select the category Math and Trig.
In the Select a part 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.
At present, click OK y'all will see your result.
Click on the bottom edge and elevate to meet other results.
Option 2 is to go to the Formulas tab. In the Function and Library group, click Math and Trig; select INT in its drop-downwards listing. Functions Arguments dialog box will appear.
In the Functions Argument dialog box, at Number, type A2 or click the jail cell A2, which automatically appears in the entry box.
Select OK; you volition see your results.
Read: How to employ EDATE and EOMONTH Part in Excel?
How to use the LCM Function in Excel
In this tutorial, nosotros desire to find the LCM of ii numbers in our table.
Click the cell where you want to identify the result. Type = LCM and then bracket.
Within the bracket, type A2, B2, then shut the bracket.
Press Enter, you will meet your result.
Click on the bottom edge and drag to see the other results.
There are 2 more options that yous can identify the LCM function into the prison cell.
Pick number one is to click on fx; an Insert Part dialog box will appear.
In the Insert Function dialog box, yous can select the category of role 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 run across Number i type A2 or click the cell A2, it will announced in the entry box.
At number2, blazon B2 or click the jail cell B2, which volition automatically announced in the entry box.
Now, click OK you lot will run into your result.
Click on the lesser edge and drag to see other results.
Selection Two is to go to the Formulas. In the Function and Library group, click Math and Trig; select LCM in its drop-down listing. Function Arguments dialog box will appear.
In the Functions Arguments dialog box, where you see Number ane type A2or click the cell A2, information technology will announced in the entry box.
At Number 2, type B2 or click the jail cell B2, which will automatically appear in the entry box.
Select OK; yous will see your results.
I hope this is helpful; if you have questions, please comment beneath.
Source: https://www.thewindowsclub.com/how-to-use-int-and-lcm-functions-in-excel
Posted by: moorethentlyst.blogspot.com
0 Response to "How to use INT and LCM Functions in Excel"
Post a Comment