Supress, Hide or Remove #DIV/0! Zatiranje, ali Skrij Odstrani # DIV / 0! Error in Microsoft Office Excel Napaka v programu Microsoft Office Excel
In Microsoft Excel or Microsoft Office Excel spreadsheet program, when a value is divided by zero (0) or a blank cell in the formula, the cell that displays the result will show the error value #DIV/0! as the result of the calculation. V Microsoft Excelu ali Microsoft Office Excel programa, pri katerih vrednost se deli z nič (0) ali prazno celico v formulo, v celici, da se prikaľe rezultat bo pokazal na vrednost napake # DIV / 0! Kot rezultat izračuna .
The error value may give wrong impression to readers especially when the workbook or worksheet is still in preparation. Je vrednost napake lahko dajo napačen vtis, da bralce še posebej, če delovni zvezek ali delovni list je še vedno v pripravi. And it’s not a professional or nice look when the same formula is applied to multiple cells by dragging or copying and all these rows or columns return an “#DIV/0!” error value. In to ni poklicna ali lepo videti, ko je ista formula se uporablja za več celic, ki jih povlečete ali kopirate in vse te vrstice ali stolpce vrnitev "# DIV / 0!" Vrednost napake.
The error value is valid though, as it’s impossible to divide any value with 0. Napako vrednost je veljavna, čeprav, kot je to nemogoče, da vrednost katerega koli deljenje z 0. However, it’s possible to suppress, hide or remove the #DIV/0! Vendar pa je možno, da bodo, skrijete ali odstranite # DIV / 0! error value in the cell for unsupported or invalid division formula by using IF worksheet function. vrednost napake v celično nepodprte ali neveljavni za delitev formulo, ki jo uporabljate funkcijo delovnega lista IF.
To suppress #DIV/0 error value or keep #DIV/0! Za zatiranje # DIV / 0 vrednost napake ali voditi # DIV / 0! from appearing when there is an error, use the following formula in place of the standard division formula: pojavili, ko gre za napako, uporabite naslednjo formulo namesto standardne delitve formuli:
=IF(denominator=0,"",numerator/denominator)
“Numerator” refers to the cell to be divided. "Števec" se nanaša na celico, ki jih je treba razdeliti. “Denominator” refers to the cell that is the divisor. "Imenovalec" se nanaša na celico, ki je delitelj.
For example, for formula of “A1/A2″ (cell A1 devided by cell A2), the formula to enter into the result cell is as below: Na primer, za formulo "A1/A2" v celici (A1, deljena s celico A2), formule za vstop v celico je rezultat kot spodaj:
=IF(A2=0,"",A1/A2)
The formula above checks to see if the denominator equals zero (or is blank); if so, a blank cell is displayed. Formulo zgoraj preglede, da vidim, če je imenovalec enak nič (ali prazno); če je tako, prazno celico, je prikazan znak. Otherwise, the cell that contains the function will display the result of the formula expression after calculating. Drugače pa je celica, ki vsebuje funkcijo, se bo prikazal rezultat formule izražanja po izračunu.
Note: To display other information in the cell if the divisor is blank or zero, type the necessary information in the formula where the quotation marks (”") appear. If you want to display text, type it between these quotation marks. If you want to display anything else (values), type it instead of the quotation marks. Opomba: Če ľelite prikazati druge informacije v celici, če je delitelj je prazno ali nič, vnesite potrebne podatke v formulo, kjer je navednicah ( "") prikazal. Če želite prikazati besedilo, tip je med temi narekovaji. Če ľelite prikazati kaj drugega (vrednosti), tip je namesto v narekovajih.
Another IF worksheet formula that works utilizing the ISERROR condition. Drugi delovni ČE formulo, ki deluje z uporabo ISERROR pogoj. The syntax for the formula portion is: Sintaksa za formulo del:
=IF(ISERROR(numerator/denominator),"",numerator/denominator)
For example, Na primer,
=IF(ISERROR(A1/A2),"",A1/A2)
Again, to display other information on the cell if the calculation result is erroneous, change the value of the middle parameter (text string requires quotation marks). Ponovimo, da se prikažejo druge informacije o celici, če je rezultat izračuna je napačen, spremenite vrednost na sredini parameter (besedilnega niza zahteva narekovajih).
After entering the error handling formula as above, users can drag to copy the formula to apply to other cells, and the similar formula will be applied automatically. Po vstopu v obravnavanje napak formulo, kot je navedeno zgoraj, bodo uporabniki lahko povlečete, da bi kopirali formulo, ki se uporabljajo za druge celice, in podobno formulo bodo avtomatično uporabili.
IMPORTANT : This is a machine translated page which is provided "as is" without warranty. POMEMBNO: To je stroj prevede stran, ki je ponujena "kot je" brez garancije. Machine translation may be difficult to understand. Strojno prevajanje je lahko težko razumljiva. Please refer to Prosimo, glejte original English article Originalno angleško članek whenever possible. kadar je to mogoče.
Share and contribute or get technical support and help at Deliti in prispevati ali dobiti tehnično podporo in pomoč pri My Digital Life Forums Moje digitalno življenje Forumi .
Related Articles Sorodni članki
- Remove and Uninstall Microsoft Office Activation Assistant - Fix Office Must Be Installed Error Odstranite in odstranite Microsoft Office Activation pomočnik - določi urad, mora biti vgrajena napaka
- The Connected State of Office Add-ins Registered in HKEY_LOCAL_MACHINE Cannot Be Changed Error When Enable or Disable in Office Outlook/Word/Excel 2007 Povezana je članica Urad Add-ins Registracijska v HKEY_LOCAL_MACHINE ne morete spremeniti Napaka Ko Omogoči ali Onemogoči v Office Outlook / Word / Excel 2007
- New Microsoft Office 2007 File Formats and Extensions for Word, Excel and PowerPoint Files Novi Microsoft Office 2007 File Extensions in formati za Word, Excel in PowerPoint datotek
- Export and Save Word or Excel Documents as Acrobat PDF or XPS Files Directly from Microsoft Office 2007 with Add-in Izvoz in Shrani Worda ali Excela Listine, kakor Acrobat PDF ali XPS datoteke neposredno iz Microsoft Office 2007 s Dodaj v
- Remove Excel Workbook or Worksheet Lost Password for Free Odstrani Excelov delovni zvezek ali delovni list Ste pozabili geslo za prosti
- Remove and Hide Facebook Ads Odstranite in Facebook skrij oglase
- How to Disable Recent Documents History in Office 2007 Excel, Word and PowerPoint Kako Onemogoči nedavni dokumenti zgodovina v Office Excel 2007, Word in PowerPoint
- How to Hide or Remove Gmail Spam Counter Kako skriti ali odstraniti Gmail spam counter
- Enable and Turn On AutoRecover in Office Word, Excel and PowerPoint for Unsaved File Discovery Omogoči in Turn On samoobnovitveno v Office Word, Excel in PowerPoint za Neshranjene File Discovery
- How to Clear and Delete Recent Documents List in Office 2007 (Word, Excel, PowerPoint) Kako in nato Zbriąi, Zbriąi seznam, v nedavni dokumenti zbirke Office 2007 (Word, Excel, PowerPoint)
