Shaqada DEC2BIN ee Microsoft Excel waa shaqo Injineer ah, ujeeddadeeduna waa in lambar jajab tobanle loo beddelo binary. Qaaciddada DEC2BIN waa DEC2BIN( Number, [Places]).

Erayga shaqada DEC2Bin ^(Syntax)waa^(DEC2Bin) :

• Lambarka^(Numbe) r: jajab tobanle ee aad rabto inaad beddesho. Waa loo baahan yahay.
• Goobaha^(Places) : Tirada jilayaasha aad rabto inaad isticmaasho; tani waa ikhtiyaari.

Sida loo isticmaalo DEC2Bin gudaha Excel

Si loogu beddelo nambarka jajab tobanle ee binary iyadoo la adeegsanayo DEC2Bin ee Excel :

1. Fur Excel
2. Samee miis ama isticmaal mid jira
3. Geli qaacidada DEC2BIN (Lambar, [Meelaha])^{(DEC2BIN( Number, [Places]))} unugga aad rabto in natiijadu noqoto.
4. Riix furaha Gelida.

Daahfurka Excel .

Samee miis ama isticmaal mid jira.

Ku qor =DEC2BIN(A2, B2) unugga aad rabto inaad natiijada dhigto.

Kadib taabo furaha Gelida^(Enter) si aad u aragto natiijada.

Si aad u aragto natiijooyinka kale ee shaxda, hoos u jiid gacanta buuxinta.

Waxaa jira laba hab oo kale oo loo isticmaalo shaqada DEC2BIN gudaha Excel.^{(There are two other methods to use the DEC2BIN function in Excel.)}

1] Guji badhanka fx ee bidix ee sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada hadalka ee qaybta, Dooro Qaybta^{(Select a Category)} , ka dooro Injineerinka^{(Engineering)} sanduuqa liiska.

Qaybta Dooro Shaqo^{(Select a Function)} , ka dooro hawsha  DEC2BIN   liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Qaybta lambarka^(Number) , geli 1 sanduuqa.

Qaybta Meelaha^(Places) , geli 3 sanduuqa.

Kadib riix OK si aad u aragto natiijada.

2] Guji tabka Formulas oo dhagsii badhanka Functions More ee kooxda ^{(More Functions)}Maktabadda Shaqada^{(Function Library)} .

Liiska ku jira, dul heehaab barraha Injineerinka^{(Engineering)} .

Waxaad arki doontaa liiska shaqooyinka Injineerinka^{(Engineering)} ; guji hawsha DEC2BIN ee liiska

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Raac tillaabooyinka habka koowaad ee  Doodaha Shaqada^{(Function Arguments)} .

Waxaan rajeyneynaa in casharkan uu kaa caawinayo inaad fahamto sida loo isticmaalo shaqada Dec2Bin ee Microsoft Excel .

Hadda akhri^{(Now read)} :  Sida loo sameeyo Barcode gudaha Excel^{(How to create Barcode in Excel)} .

How to use DEC2Bin in Excel to convert a decimal number to binary

The DEC2BIN function in Microsoft Excel is an Engineering function, and its purpose is to convert a decimal number to binary. The formula for the DEC2BIN is DEC2BIN( Number, [Places]).

The Syntax for the DEC2Bin function is:

• Number: the decimal integer you want to convert. It is required.
• Places: The number of characters you want to use; this is optional.

How to use DEC2Bin in Excel

To convert a decimal number to binary using DEC2Bin function in Excel:

1. Launch Excel
2. Create a table or use an existing one
3. Enter the formula DEC2BIN( Number, [Places]) into the cell you want the result to be.
4. Press the Enter key.

Launch Excel.

Create a table or use an existing one.

Type =DEC2BIN(A2, B2) into the cell you want to place the result.

Then press the Enter key to see the result.

To see the other results in the table, drag the fill handle down.

There are two other methods to use the DEC2BIN function in Excel.

1] Click the fx button on the top left of the excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Engineering from the list box.

In the section Select a Function, choose the  DEC2BIN  function from the list.

Then click OK.

A Function Arguments dialog box will open.

In the Number section, input 1 into the box.

In the Places section, input 3 into the box.

Then click OK to see the result.

2] Click the Formulas tab and click the More Functions button in the Function Library group.

In the list, hover the cursor over Engineering.

You will see a list of Engineering functions; click the DEC2BIN function from the list

A Function Arguments dialog box will appear.

Follow the steps in method one for  Function Arguments.

We hope this tutorial helps you understand how to use the Dec2Bin function in Microsoft Excel.

Now read: How to create Barcode in Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

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

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sidee looga saaraa Akhri kaliya dukumeenti Excel ah?

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

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

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo isticmaalo shaqada Mode ee Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo abuuro Jaantuska Ururka gudaha Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sida loo isticmaalo shaqada ISODD ee Excel