Maqaalkani wuxuu ka hadlayaa #DIV/0! qaladka Microsoft Excel iyo sida loo hagaajiyo. The # DIV/0 ! qaladku wuxuu yimaadaa marka nambar loo qaybiyo 0 gudaha Excel . Waxa kale oo ay soo baxdaa marka unuggu aanu wax qiimo ah ku jirin ama uu faaruq yahay oo aad codsatay habka qaybinta.

Hadda, waxaa jiri kara 0 qiime oo unugyo kala duwan ku jira diiwaanka. Haddii aad ku dabooshay qaacido qaybinta tiir dhan oo tiro gaar ah ay tahay in si toos ah loo qaybiyo 0, waxaad heli doontaa tan # DIV/0 ! qalad Waxay ka dhigaysaa buugaag shaqo mid aan habaysanayn oo aan habaysanayn. Haddii aad la kulanto dhibaato isku mid ah, ma jirto wax welwel ah oo aan ku daboolnay. Casharradan, waxaan ku tusi doonaa tillaabooyinka aad iskaga ilaalin lahayd khaladkan MS Excel . Aan eegno sida aad uga saari karto # DIV/0 ! qalad ka yimid buuggaaga shaqada ee Excel .

Sida loo saaro # DIV/0 ! qaladka Excel

Ciladaan waxaa lagu hagaajin karaa iyadoo la isticmaalayo shaqada IFERROR ee Excel . Waa kuwan tillaabooyinka saxda ah ee lagu hagaajinayo # DIV/0 ! Cilad ku jirta Microsoft Excel :

Fur Excel oo fur buugga shaqada meesha aad ka helayso ciladan.

Hadda, ka soo qaad inaad u qaybiso qiyamka unugyada tiirarka B adigoo isticmaalaya qiyamka unugga tiirka C oo aad isticmaashay qaacidada =B2/C2Kaliya^(Simply) dhagsii unugga muujinaya # DIV/0 ! qalad ka dibna tag sanduuqa hawlaha. Hadda waa inaad ku darto qaacidada soo socota:

• Haddii aad rabto inaad soo celiso qiime maran haddii ay dhacdo qalad, isticmaal=IFERROR(B2/C2,“”)
• Si aad u muujiso qiimaha 0 ee meesha qaladka, isticmaal=IFERROR(B2/C2,0)
• Waxa kale oo aad isticmaali kartaa IF bayaan sida =IF(C2=0,0,B2/C2)in aad hesho 0 soo celinta qiimaha haddii C2 ay ku jirto eber.

Kaliya geli mid ka mid ah hababka kor ku xusan unugga siinaya # DIV/0 ! khalad sidaad door bidayso qaladkana kama soo bixi doono qolka.

Hadda, si aad khaladkan uga saarto tiirka oo dhan, waa inaad isla qaacido isku mid ah ku koobiyso tiirka oo dhan. Taas awgeed, waxaad dooran kartaa unugga, dhig calaamadeeyaha dhanka hoose ee midig ee unugga, ka dibna qabo oo u jiid dhanka dhamaadka tiirka. Tani waxay ku dabaqi doontaa qaaciidadan tiirka oo dhan mana heli doontid #DIV/0! mid ka mid ah unugyada tiirka.

Si la mid ah, waxaad sidoo kale isticmaali kartaa shaqada ISERROR . Shaqadani waxay asal ahaan soo celisaa qiimaha RUNTA^(TRUE) ah marka uu khalad jiro, waxayna soo celisaa qiimaha BEENTA^(FALSE) marka aanu khalad jirin. Si loo muujiyo RUN^(TRUE) haddii ay dhacdo # DIV/0 ! qalad, waxaad isticmaali kartaa =ISERROR(B2/C2)  qaacidada.

Waxaan rajeyneynaa in maqaalkani uu kaa caawin doono inaad ka saarto # DIV/0 ! qaladka Microsoft Excel .

Bal hadda u fiirso qoraaladan:^{(Now take a look at these posts:)}

• Sida loo isticmaalo shaqada ROMN gudaha Excel^{(How to use ROMAN function in Excel)}
• Saddex-xagalka Jaallaha ah oo leh Barta Dhawaaqa ee Excel ama Word.^{(Yellow Triangle with Exclamation Point in Excel or Word.)}

How to remove #DIV/0! error in Excel

This article talks about #DIV/0! error in Microsoft Excel and how to fix it up. The #DIV/0! error occurs when a number is divided by 0 in Excel. It also shows up when a cell contains no value or is empty and you have applied a division formula.

Now, there can be 0 value in various cells in a record. If you have applied a division formula to an entire column and a certain number has to be automatically divided by 0, you will receive this #DIV/0! error. It makes your workbook look very untidy and disorganized. If you are facing the same problem, no worries we got you covered. In this tutorial, I will be showing you the steps to avoid this error in MS Excel. Let us check out how you can remove #DIV/0! error from your Excel workbook.

How to remove #DIV/0! error in Excel

This error can be fixed by using the IFERROR function in Excel. Here are the exact steps to fix #DIV/0! error in Microsoft Excel:

Launch Excel and open the workbook where you are getting this error.

Now, suppose you have to divide cell values in the B column by the cell values in the C column and you have used the =B2/C2 formula. Simply click on the cell that shows #DIV/0! error and then go to the functions box. You now have to add the following formula:

• If you want to return a blank value in case of error, use =IFERROR(B2/C2,“”)
• For showing a 0 value in place of error, use =IFERROR(B2/C2,0)
• You can also use an IF statement like =IF(C2=0,0,B2/C2) to get 0 return value in case C2 contains a zero.

Just enter any of the above formulae to the cell giving #DIV/0! error as you prefer and this error won’t show up in the cell.

Now, to remove this error from an entire column, you will have to copy the same formula to the whole column. For that, you can select the cell, place the cursor at the bottom right of the cell, and then hold and drag it towards the end of the column. This will apply this formula to the whole column and you won’t receive a #DIV/0! in any of the cells in a column.

In a similar manner, you can also use the ISERROR function. This function basically returns TRUE value when there is an error, and it returns FALSE value when there is no error. To show TRUE in case of #DIV/0! error, you can use the =ISERROR(B2/C2) formula.

Hope this article helps you remove the #DIV/0! error in Microsoft Excel.

Now take a look at these posts:

• How to use ROMAN function in Excel
• Yellow Triangle with Exclamation Point in Excel or Word.

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

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

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

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

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

• Sida waqti loogu daro ama loogu daro Microsoft Excel

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10