Iimpazamo eziqhelekileyo kwiimfomula ze-Excel kunye nendlela yokuzilungisa
Ukuba i-Excel ayikwazi ukuvavanya ngokufanelekileyo ifom yesicelo okanye umsebenzi; iya kubonisa ixabiso lesiphene - njenge #REF !, #NULL !, # DIV / 0! - kwiseli apho ifom efumaneka khona.
Iphutha lixabisa ngokwabo kunye nekhenketho leenketho, okubonakaliswa kwiiseli ngeefomula iimpahla, kunika uncedo ekuboneni ingxaki malunga neengxaki.
Izilwanyana ezihlaza kunye neeDayimane ezimnyama
I-Excel iya kubonisa unxantathu oluhlaza obuncantsi ekhoneni eliphezulu elingasekhohlo yamaseli anemiqobo yeefayile - iiseli D2 ukuya kwi-D9 kumfanekiso ongentla. Ubunxantathu obuluhlaza lubonisa ukuba okuqukethwe kweeseli kwephula enye yephutha lika-Excel ukujonga imithetho.
Ukuqakraza iseli elinexantathu eluhlaza kuyo kubangela ukuba iqhosha elenziwe ngombala obomvu libonakaliswe ngaphaya kwantantathu. Idayimani ephuzi yinkinobho yokukhethwa kweefayile ze-Excel kwaye iqulethe iindlela zokulungisa isiphoso esicatshulwayo.
Ukuhambisa i-pointer ye mouse kwiqhosha lokukhethwa kwephutha liza kubonisa umyalezo wombhalo - owaziwa ngokuba yi- hover text - ichaza isizathu sokuba ixabiso lephutha.
Ngezantsi zidweliswe iimpazamo eziqhelekileyo ezibonakaliswe yi-Excel, kunye nezinye izizathu eziqhelekileyo nezisombululo zokuncedisa ingxaki.
#NAME! Iimpazamo - Iingcamango zeeNgcaciso ezingekho ngokuchanekileyo
#NAME! Iimpazamo zephutha zivela xa kuboniswe izikhombisi ezimbini okanye ngaphezulu zecala ngokungenakulungile okanye ngokungazenzisiyo ngesithuba kwifom - imigca 2 kuya ku-5 kumfanekiso ongentla.
Kwiifomula ze-Excel, umgca wendawo usetyenziswa njengomqhubi we-intersect, oku kuthetha ukuba isetyenziswe xa ubhala uluhlu oluninzi okanye oluninzi oludibeneyo lweedatha, njenge-A1: A5 A3: C3 (i-cell reference A3 yinxalenye yamabini omabini , ngoko ke amacandelo adibanisa).
#NAME! i mpazamo ukuba:
- Iingxelo ezininzi zeeseli kwifom zihlukaniswe ngendawo esikhundleni somqhubi weemathematika ezifana nesibonakaliso ( + ). Umzekelo: = A1 A3 + A5;
- Amanqaku okuqala kunye neyokuphela kwezigaba zeeseli ahlukaniswe ngendawo esikhundleni somqhubi webalawuli - ikholoni (:). Umzekelo: = I-SUM (A1 A5);
- Iingxelo zeeseli ngamanye kwifom ehlukaniswe yithuba endaweni yomqhubi womanyano - i-comma (,). Umzekelo: = I-SUM (A1 A3, A5);
- Umqhubi we-intersect (umgca wendawo) usetyenziselwa ngokuzithandela, kodwa iindawo ezichaziweyo azidibanisi. Umzekelo: = I-SUM (A1: A5 B1: B5)
Iisombululo: Iingqamaniso zesisele ezahlukileyo ngokuchanekileyo.
- iinkcukacha zeefenethi ezahlukileyo kwifomu kunye nomqhubi weemathematika. Umzekelo: = A1 + A3 + A5;
- ukwahlula iindawo zokuqala kunye neyokugqibela kwimiba ekholoni (:). Umzekelo: = I-SUM (A1: A5);
- iinkcukacha ezihlukeneyo zeeseli nganye kwifomu nge-comma. Umzekelo: = ISUM (A1, A3, A5);
- qinisekisa ukuba iindawo ezihlukeneyo ngendawo zidibanisa. Umzekelo: = I-SUM (A1: A5 A3: C3).
#REF! Iimpazamo - Iimferensi zeSeli ezingavumelekanga
Iphutha leeferensi yesalathisi engavumelekanga lwenzeka xa ifomula iqulethe iingxelo zeselunganga ezingafanelekanga - imiqolo 6 no-7 kumzekelo ongentla. Oku kwenzeka rhoqo xa:
- iiseli ngamanye okanye iikholomu ezipheleleyo okanye imigqa equkethe idatha echazwe kwindlela ifakwe ngengozi;
- Idatha evela kwelinye iseli ifakwe (isebenzise kwaye unamathisele okanye udibanise uphonononge) kwisisele esichazwe ngumhlathi;
- ifom iqulethe umnxibelelwano-usebenzisa i-OLE (Ukuxhuma kunye nokuFakelwa kwezinto) - kwinkqubo engasebenzi ngoku.
I zi mbululo:
- sebenzisa i- Excel yokuhlenga isici sokufumana idatha elahlekileyo kwiiseli ezisusiweyo, iikholomu okanye imigqa;
- ukuba idatha ayinakubuyiselwa kwakhona, faka kwakhona idatha kwaye uhlengahlengise iinkcukacha zeseli xa kuyimfuneko;
- iiprogram ezivulekileyo eziqulethe ii-OLE kunye nokuhlaziya iphepha lokusebenzela eliqulethe i- #REF! mpazamo.
# DIV / O! - Hlukanisa ngeZero Error
Ukwahlula ngamaphutha a-0 kwenzeka xa umhlathi uzama ukwahlula ngemigangatho engu-8 no-9 kumfanekiso ongentla. Oku kungabangela xa:
- umcebisi okanye i-denominator ekusebenziseni ulwahlulo lilingana ne-zero - ngokucacileyo - njenge = A5 / 0 okanye njengesiphumo sokubala kwesibini esineziphumo;
- ifomula ibonisa iseli esingenanto.
I zi mbululo:
- Khangela ukuba unedatha echanekileyo kwiiseli ezichazwe kwifom.
- Khangela ukuba idatha yakho iiseli ezichanekileyo.
- Khangela ukuba iiferensi ezichanekileyo zesetyenzisiwe zisetyenziswe kwifom.
##### Iphutha - Ukufometha kweSeli
Isalathisi ezaliswe uluhlu lwee- hashtag , iimpawu zeenombolo, okanye iimpawu zamapounds njengoko zibizwa ngokuba, azibhekiselwe njengexabiso lempazamo yiMicrosoft kodwa kuthiwa kubangelwa ubude beenkcukacha ezifakwe kwiselfom efomathiweyo.
Ngako oko, umgca we ##### uvela kwiimeko ezahlukeneyo, ezifana nokuba nini:
- Ixabiso elithengiweyo libanzi kunokuba ububanzi beeseli bukhoyo iseli efomelwe imihla okanye amaxesha - umqolo 10 kumfanekiso ongentla.
- ifom yangena kwiselfom efomathiweyo ukuba iinombolo zivelise umphumo obanzi ngaphezu kweseli.
- inombolo okanye idatha yombhalo, ngokungaphezu kwamahlamvu angama-253, ingeniswa kwifom efomathiweyo yamanani, amaxesha, okanye ingxelo.
- Inombolo engalunganga ihlala kwiseli efomathiweyo ngemihla okanye ngamaxesha. Imihla kunye namaxesha e-Excel kufuneka abe namaxabiso abonakalisiweyo njengoko kuboniswe kumgca 11 kumfanekiso ongentla.
I zi mbululo:
- Yandisa i-cell echaphazelekayo ngokukhulisa ikholomu (iiseli ngalinye alinakwandiswa ngaphandle kokukhulisa lonke ikholomu).
- Ukunciphisa ubude beenkcukacha kwiseli xa kunokwenzeka okanye ukhethe ifomathi eyahlukileyo kweseli njengeGenerari .
- Lungisa umhla okanye ixabiso lexesha kwiseli echaphazelekayo ukwenzela ukuba isiphumo asibi.
- Yilungisa ifom ephumela kwixesha elibi okanye ixabiso lexesha eliza kuboniswa kwiseli elichaphazelekayo.