Maqaalkan, waxaan ku tusi doonaa sida loo isticmaalo INT iyo Functions LCM^{(LCM Functions)} gudaha Microsoft Excel . Shaqada INT waxay hoos u dhigtaa lambar ilaa inta ugu dhow. Haddii nambarku uu taban yahay, wuxuu ka wareegi doonaa eber. Qaabka shaqada INT waa INT (lambar)^{(INT (number))} . Shaqada LCM waxay soo celisaa isku dhufashada ugu yar ee caadiga ah. Qaabka shaqada LCM waa LCM (lambar1, [lambar2] …). ^{(LCM (number1, [number2] …). )}Labaduba INT iyo LCM waa Xisaabta iyo^{(Math and Trig)} Functions Trig.

Ereyga macnaha guud ee Excel INT iyo LCM Functions

INT

Number : Lambarka aad rabto inaad hoos u dhigto. Lambarka ayaa loo baahan yahay.

LCM

Number1, [number2] : Nambarka koowaad^{(Number one)} ayaa loo baahan yahay, nambarka labaad waa ikhtiyaari. Hawlaha LCM^(LCM) waxay kuu oggolaanayaan inaad u hesho qiyamka qodobka ugu yar.

Sida loo isticmaalo shaqada INT^{(INT Function)} ee Excel

Casharradan, waxaanu u rogi doonaa tobanlaha miiska dhexdiisa oo ka dhigaya tirooyin.

Guji^(Click) unugga meesha aad rabto inaad ku aragto natiijada, dabadeed ku qor =INT(A2) .

Dhig curcurka meesha ugu dambeysa ee unugga. Waxaad arki doontaa calaamad lagu daray; hoos u jiid. Natiijooyinka kale waxaad ku arki doontaa unugga kale.

Waxaa jira laba ikhtiyaar oo kale oo aad ku dhejin karto shaqada INT unugga.

Ikhtiyaarka koowaad waa inaad gujiso fx ; sanduuqa wada hadalka Gelida Function^{(Insert Function)} ayaa soo bixi doona.

Insert Function sanduuqa wada hadalka, waxaad dooran kartaa qaybta shaqada aad rabto. Dooro qaybta Xisaabta iyo Trig^{(Math and Trig)(Math and Trig)} .

Xulo^(Select) liiska shaqada, dooro INT .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona. Sanduuqa wada-hadalka, oo aad ku aragto lambarka^{(Number )} nooca A2 ama guji unugyada A2 , waxay si toos ah uga muuqan doontaa sanduuqa gelitaanka.

Hadda, guji OK waxaad arki doontaa natiijadaada.

Guji^(Click) cidhifka hoose oo jiid si aad u aragto natiijooyin kale.

Ikhtiyaarka Labaad waa in aad tagtid tab Formulas . Kooxda Function iyo Library , dhagsii Xisaab iyo Trig^{(Math and Trig)} ; ka dooro INT liiska hoos u dhaca. Functions Arguments sanduuqa wada hadalka ayaa soo bixi doona.

In sanduuqa wada hadalka doodaha Functions^{(Functions Argument)} , at  Number , ku qor A2 ama dhagsii unugga A2 , kaas oo si toos ah uga muuqda sanduuqa gelitaanka.

Dooro OK^{(Select OK)} ; waxaad arki doontaa natiijadaada.

Akhri: ^(Read:) Sida loo isticmaalo EDATE iyo Function EOMONTH gudaha Excel^{(How to use EDATE and EOMONTH Function in Excel)} ?

Sida loo isticmaalo Shaqada LCM^{(LCM Function)} ee Excel

Casharradan, waxaan rabnaa inaan ka helno LCM ee laba lambar ee miiskayaga.

Guji^(Click) unugga meesha aad rabto inaad natiijada dhigto. Nooca = LCM ka dibna garabka.

Gudaha bracket-ka, ku qor A2, B2 , ka dibna xidh xidhidhka.

Riix Gelida^(Enter) , waxaad arki doontaa natiijadaada.

Guji^(Click) cidhifka hoose oo jiid si aad u aragto natiijooyinka kale.

Waxaa jira laba ikhtiyaar oo kale oo aad ku dhejin karto shaqada LCM unugga.

Ikhtiyaarka koowaad waa inaad gujiso fx ; sanduuqa wada hadalka Gelida Function^{(Insert Function)} ayaa soo bixi doona.

Insert Function sanduuqa wada hadalka, waxaad dooran kartaa qaybta shaqada aad rabto. Dooro qaybta Xisaabta iyo Trig^{(Math and Trig)} .

Xulo^(Select) , liiska shaqada, dhagsii LCM .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona. Sanduuqa wada-hadalka, oo aad ku aragto Number 1 nooca A2 ama guji unugyada A2 , waxay ka muuqan doontaa sanduuqa gelitaanka.

Nambarka 2^(number2) , ku qor B2 ama dhagsii unugga B2 , kaas oo si toos ah uga soo bixi doona sanduuqa gelitaanka.

Hadda, guji OK waxaad arki doontaa natiijadaada.

Guji^(Click) cidhifka hoose oo jiid si aad u aragto natiijooyin kale.

Ikhtiyaarka labaad waa in la aado foomamka^(Formulas) . Kooxda Function and Library^{(Function and Library group)} , dhagsii Xisaab iyo Trig^{(Math and Trig)} ; ka dooro LCM liiska hoos u dhaca. Sanduuqa wada hadalka doodaha shaqada ayaa soo bixi doona.^{(Function Arguments)}

Sanduuqa wadahadalka doodaha Functions^{(Functions Arguments)} , halkaas oo aad ku aragto Number 1 nooca A2 ama guji unugga A2 , waxay ka muuqan doontaa sanduuqa gelitaanka.

Nambarka 2^{(Number 2)} , ku qor B2 ama dhagsii unugga B2 , kaas oo si toos ah uga soo bixi doona sanduuqa gelitaanka.

Dooro O K; waxaad arki doontaa natiijadaada.

Waxaan rajeynayaa in tani ay tahay mid waxtar leh; haddii aad wax su'aalo ah qabtid, fadlan faallo ka bixi hoos.

How to use INT and LCM Functions in Excel

In thiѕ post, 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.

Related posts

• Sida loo isticmaalo EDATE iyo EOMONTH Functions gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Excel

• Sida loo isticmaalo MIN, Max, iyo AVERAGE Functions gudaha Excel

• Sida loo isticmaalo Beddelka iyo Bedelka Hawlaha gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada DGET gudaha Excel

• Sidee loo xisaabiyaa korodhka ama hoos u dhaca boqolkiiba ee Excel?

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows