Enye yezinto ezaziwa kakhulu nge-Excel ukusebenzisana namafomula. Ngenxa yalo msebenzi, uhlelo lenza ngokuzimele izinhlobo ezahlukahlukene zokubala kumatafula. Kepha kwesinye isikhathi kuyenzeka ukuthi umsebenzisi afake ifomula esitokisini, kepha ayifezi inhloso yayo eqondile - ukubala umphumela. Ake sibheke ukuthi lokhu kungaxhunyaniswa kanjani nokuthi kungaxazululwa kanjani lenkinga.
Ukuxazulula Izinkinga Zokubalwa
Izimbangela zezinkinga zokubala amafomula ku-Excel zingahluka ngokuphelele. Zingadalwa izilungiselelo zencwadi ethile noma uhla oluhlukile lwamaseli, noma ngamaphutha ahlukahlukene ku-syntax.
Indlela yoku-1: shintsha ukuguqulwa kwamaseli
Isizathu esivame kakhulu esenza ukuthi i-Excel ingabali noma ingawabali kahle amafomula nhlobo yifomathi yeseli engalungile. Uma uhla lunefomethi yombhalo, khona-ke isisho asibalwa nhlobo, okungukuthi, sikhonjiswa njengombhalo osobala. Kwezinye izimo, uma ifomethi ingahambelani nomsuka wedatha ebaliwe, umphumela oboniswe kuseli kungenzeka ungakhonjiswa kahle. Ake sibheke ukuthi singayixazulula kanjani le nkinga.
- Ukuze ubone ukuthi iyiphi iseli noma ibanga elithile linokufomethi, iya kuthebhu "Ikhaya". Kubambo olubekwe ebhokisini lamathuluzi "Inombolo" Kunenkambu yokubonisa yefomethi yamanje. Uma inani likhonjisiwe lapho "Umbhalo", khona-ke ifomula ngeke ibalwe ngokunembile.
- Ukuze uguqule ifomethi, chofoza nje kule nkambu. Uhlu lokukhetha ukufometha luyavula, lapho ungakhetha khona inani elihambelana nomongo wefomula.
- Kepha ukukhethwa kwezinhlobo zamafomethi ngetheyipu akuyona into ebanzi njengokufakelwa iwindi elikhethekile. Ngakho-ke, kungcono ukusebenzisa inketho yokufomatha yesibili. Khetha ibanga eliqondiwe. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha Uhlobo Lweseli. Ungacindezela futhi inhlanganisela yokhiye ngemuva kokuqokomisa ububanzi I-Ctrl + 1.
- Iwindi lokufometha liyavula. Iya kuthebhu "Inombolo". Ebhlokini "Amafomethi ezinombolo" khetha ifomethi esiyidingayo. Ngaphezu kwalokho, engxenyeni efanele yewindi kungenzeka ukuthi ukhethe uhlobo lwe-isethulo lefomethi ethile. Ngemuva kokuthi ukwenziwa kwenziwe, chofoza inkinobho "Kulungile"etholakala ngezansi.
- Khetha amaseli lapho umsebenzi ungazange ubhekwe khona, futhi ulandise futhi, ucindezele ukhiye wokusebenza F2.
Manje ifomula izobalwa ngokulandelana okujwayelekile ngomphumela oboniswe kuseli elicacisiwe.
Indlela 2: Khubaza amafomula we-Show
Kepha mhlawumbe isizathu sokuthi esikhundleni semiphumela yokubala onazo izinkulumo zikhonjisiwe kungenxa yokuthi uhlelo lunayo Khombisa amafomula.
- Ukuze unike amandla ukubonisa amanani, iya kuthebhu Amafomula. Kubambo olubekwe ebhokisini lamathuluzi Ukuncika Kwefomulauma inkinobho Khombisa amafomula esebenzayo, bese uchofoza kukho.
- Ngemuva kwalezi zenzo, amaseli azophinda abonise umphumela esikhundleni se-syntax yokusebenza.
Indlela 3: amaphutha e-syntax alungile
Ifomula nayo ingaboniswa njengombhalo uma kwenziwa amaphutha ku-syntax yayo, ngokwesibonelo, incwadi ilahlekile noma iguquliwe. Uma ulufake ngesandla, hhayi ngokusebenzisa Isici Wizardkhona-ke lokhu kungenzeka. Iphutha elijwayelekile kakhulu elihlotshaniswa nokubonisa isabizwana njengombhalo isikhala phambi komlingiswa "=".
Ezimweni ezinjalo, udinga ukubukeza ngokucophelela i-syntax yalezo amafomula angakhonjiswanga kahle, futhi wenze ushintsho olufanele kuzo.
Indlela 4: nika amandla ukuphindaphinda kwefomula
Kunesimo esinjalo sokuthi ifomula ibonakala ikhombisa ukubaluleka, kepha lapho amangqamuzana ahambisana nayo eshintsha, wona uqobo awuguquki, okungukuthi, umphumela awulandiswa. Lokhu kusho ukuthi uhlele ngokungalungile amapharamitha wokubala kule ncwadi.
- Iya kuthebhu Ifayela. Ukuba kuyo, chofoza entweni "Izinketho".
- Iwindi lokukhetha liyavula. Udinga ukuya esigabeni Amafomula. Ebhuthini yezilungiselelo Ukubalwa kwamapharamitha, ebekwe phezulu kwewindi, uma kunopharamitha "Izibalo encwadini", inkinobho ayisethiwe "Ngokuzenzakalelayo", ke lokhu yisizathu sokuthi umphumela wokubala awuchazi. Sishintsha switch siye endaweni oyifunayo. Ngemuva kokwenza izilungiselelo ezingenhla, ukuze uzisindise ngaphansi kwewindi, chofoza inkinobho "Kulungile".
Manje zonke izinkulumo ezikule ncwadi zizophinda zibhalwe ngokuzenzakalelayo lapho noma yiliphi inani elihlobene liguquka.
Indlela 5: iphutha kwifomula
Uma uhlelo lusasebenza ukubala, kepha ngenxa yalokho kukhombisa iphutha, khona-ke leso simo kungenzeka ukuthi umsebenzisi enze iphutha lapho engena ibinzana. Izindlela ezinephutha yilezo, lapho zibalwa, la maxabiso alandelayo avela esitokisini:
- # INANI !;
- #VALUE !;
- # EMPTY !;
- #DEL / 0!;
- # N / A.
Kulokhu, udinga ukubheka ukuthi idatha kumaseli akhonjwe ngenkulumo ibhalwe kahle yini, ukuthi ngabe akhona amaphutha ku-syntax noma uma isenzo esithile esingalungile (ngokwesibonelo, ukwahlukaniswa ngo-0) kufakwe kwifomula uqobo.
Uma umsebenzi uyinkimbinkimbi, ngenani elikhulu lamaseli axhunyiwe, kulula ukulandela ukubala usebenzisa ithuluzi elikhethekile.
- Khetha iseli elinephutha. Iya kuthebhu Amafomula. Kubambo olubekwe ebhokisini lamathuluzi Ukuncika Kwefomula chofoza inkinobho "Bala ifomula".
- Kuvulwa iwindi lapho kuvezwa ukubalwa okuphelele. Chofoza inkinobho "Bala" futhi ubheke isinyathelo sokubalwa ngesinyathelo. Sifuna iphutha futhi silisuse.
Njengoba ukwazi ukubona, izizathu i-Excel ezingazicabangeli noma ezingawabali kahle amafomula zingahluka ngokuphelele. Uma, esikhundleni sokubala, umsebenzisi ukhombisa umsebenzi uqobo, khona-ke kuleli cala, kungenzeka kakhulu, noma iseli lifomatiwe umbhalo noma imodi yokubuka yezinkulumo ivuliwe. Futhi, kungahle kube nephutha le-syntax (ngokwesibonelo, isikhala ngaphambi komlingiswa "=") Uma ngemuva kokushintsha idatha kumaseli axhunyiwe umphumela ungavuselelwa, kuzodingeka ubheke ukuthi ukuvuselelwa okuzenzakalelayo kulungiswa kanjani kuzilungiselelo zencwadi. Futhi, imvamisa esikhundleni somphumela ofanele, kuboniswa iphutha kuseli. Lapha udinga ukubuka wonke amanani asebenza kuwo umsebenzi. Uma kutholwe iphutha, lilungise.
