Esinye sezici ezithandwayo kakhulu ze-Excel isebenza ngamafomula. Ngenxa yalokhu msebenzi, lolu hlelo luzimela ngokuzimela ngezinhlobo ezahlukene zokubala kumatafula. Kodwa ngezinye izikhathi kwenzeka ukuthi umsebenzisi ufake ifomula ibe yiseli, kodwa ayifezi injongo yayo eqondile - ukubalwa komphumela. Ake sibone ukuthi ingaxhunyaniswa nani, nokuthi ungaxazulula kanjani le nkinga.
Ukuxazulula izinkinga zokubala
Izimbangela zezinkinga ngokubala kwamafomula ku-Excel zingahluka ngokuphelele. Zingakhokhwa kokubili kumasethi encwadi ethize noma ngisho nasezingeni elithile lamaseli, kanye namaphutha ahlukahlukene ku-syntax.
Indlela 1: shintsha ifomethi yamaseli
Esinye sezizathu ezivame kakhulu ukuthi kungani i-Excel ingacabangi noma ingacabangi kahle amafomula nakanjani ifomethi yeseli engalungile. Uma ububanzi bunombhalo wombhalo, khona-ke ukubalwa kwezinkulumo kulo akukwenziwa nhlobo, okungukuthi, kuboniswa njengombhalo ocacile. Kwezinye izimo, uma ifomethi ingahambisani nalokho okubhaliwe kwedatha ebalwe, umphumela oboniswa esitokisini awukwazi ukuboniswa ngendlela efanele. Ake sithole indlela yokuxazulula le nkinga.
- Ukuze ubone ukuthi iyiphi isakhi ethile noma ibanga elithile eliye, hamba kuthebhu "Ikhaya". On the tape ebhodini amathuluzi "Inombolo" Kukhona inkundla yokubonisa ifomethi yamanje. Uma kunenani "Umbhalo", ifomula ngeke ibalwe ngokuqondile.
- Ukuze wenze ushintsho kwifomathi, chofoza nje kule nsimu. Uhlu lwezinketho zokufometha luzovuleka, lapho ungakhetha khona inani elihambelana ne-essence yefomula.
- Kodwa ukukhethwa kwezinhlobo zefomethi nge-tape akukona okubanzi njengokungathi usebenzisa iwindi elikhethekile. Ngakho-ke, kungcono ukusebenzisa indlela yokufometha yesibili. Khetha ibanga lokukhomba. Sichofoza kuso ngenkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Fometha amaseli". Ungaphinda ucindezele isinqamuleli ngemuva kokukhetha ibanga. Ctrl + 1.
- Iwindi yokufometha ivula. Iya kuthebhu "Inombolo". Ku-block "Amafomu Amanani" khetha ifomethi esiyidingayo. Ngaphezu kwalokho, ngakwesokudla kwefasitela, ungakhetha uhlobo lwesethulo sefomethi ethile. Emva kokukhethwa kukwenziwa, chofoza inkinobho "Kulungile"kufakwe ngezansi.
- Khetha eyodwa ngamaseli lapho umsebenzi ungabalwa khona, futhi ukuze uvuselele kabusha, cindezela ukhiye womsebenzi F2.
Manje ifomula izobalwa ku-oda evamile nomphumela oboniswe kuseli elichaziwe.
Indlela 2: Khubaza imodi "yefomu yokubonisa"
Kodwa mhlawumbe isizathu sokuthi esikhundleni semiphumela yokubala unezinkulumo eziboniswayo, yilelo hlelo lunemodi "Bonisa amafomula".
- Ukuze unike amandla ukuboniswa kwama-totals, iya kuthebhu "Amafomula". On the tape ebhodini amathuluzi "I-Formula Dependencies"uma inkinobho "Bonisa amafomula" esebenzayo, bese uchofoza kuso.
- Ngemva kwalezi zenzo, amaseli azophinde abonise umphumela esikhundleni se-syntax yemisebenzi.
Indlela 3: Lungisa iphutha le-syntax
Ifomula lingaboniswa njengombhalo uma i-syntax yayo iphutha, isibonelo, uma incwadi ingekho noma ishintshiwe. Uma ulifakile ngesandla, futhi hhayi ngokusebenzisa Umsebenzi weWebhu, cishe kungenzeka. Iphutha elivamile kakhulu elihlobene nokubonisa inkulumo njengombhalo yisikhala ngaphambi kwesibonakaliso "=".
Ezimweni ezinjalo, udinga ukuhlola ngokucophelela i-syntax yalezo fomula ezingabonakali kahle, futhi wenze izinguquko ezifanele kubo.
Indlela 4: Nika amandla ukulungiswa kabusha kwefomula
Kuphinde kwenzeke ukuthi ifomula ibonakala ibonisa ukubaluleka, kodwa uma amaseli axhumene nayo ashintshe, ayishintshi ngokwayo, okungukuthi, umphumela awukwenziwa kabusha. Lokhu kusho ukuthi ulungise ngokungalungile imigomo yokubala kule ncwadi.
- Chofoza ithebhu "Ifayela". Ngenkathi ukhona, chofoza into "Izinketho".
- Iwindi yezimangalo izovulwa. Udinga ukuya esigabeni "Amafomula". Ebhokisini lesethingi "Izibalo zokubala"okuyinto itholakala phezulu kakhulu kwefasitela, uma kupharamitha "Izibalo encwadini", shintsha ungabeki esimweni "Okuzenzakalelayo"ke yilesi isizathu sokuthi umphumela wokubala awubalulekile. Hambisa inkinobho endaweni efunayo. Ngemuva kokuthi wenze izilungiselelo ezingenhla ukuze uzigcine ngaphansi kwefasitela chofoza inkinobho "Kulungile".
Manje zonke izinkulumo kule ncwadi zizohlelwa kabusha ngokuzenzakalelayo uma kushintsha noma yiliphi inani elihlobene.
Indlela 5: iphutha kwifomula
Uma lolu hlelo lusenza lokho kubalwa, kodwa ngenxa yalokho kubonisa iphutha, cishe kungenzeka ukuthi umsebenzisi wenza iphutha lapho efaka inkulumo. Amafomula angalungile yilokho okubalwa ukuthi amanani alandelayo avela esitokisini:
- #NUM!;
- #VALUE!;
- # NULL!;
- # DEL / 0!;
- # N / a.
Kulesi simo, udinga ukuhlola ukuthi idatha iqoshiwe kahle emangqamuzaneni abhekiswa yile nkulumo, kungakhathaliseki ukuthi kukhona amaphutha ku-syntax noma ngabe kukhona isenzo esingalungile kwifomu ngokwalo (isibonelo, ukuhlukaniswa ngu-0).
Uma umsebenzi unzima, ngenani elikhulu lamaseli axhunyiwe, kulula ukulandelela izibalo usebenzisa ithuluzi elikhethekile.
- Khetha iseli ngephutha. Iya kuthebhu "Amafomula". On the tape ebhodini amathuluzi "I-Formula Dependencies" chofoza inkinobho "Bala i-Formula".
- Ifasitela ivula lapho kubalwa khona ukubala okuphelele. Push inkinobho "Bala" bese ubheka isinyathelo ngesinyathelo. Sifuna iphutha futhi sililungise.
Njengoba ubona, izizathu zokuthi kungani i-Excel ingacabangi noma ingacabangi ngamafomula angalungile ingahluka ngokuphelele. Uma, esikhundleni sokubala, umsebenzisi ubonisa umsebenzi ngokwawo, ngakho-ke kulokhu, kungenzeka ukuthi iseli ifomathiwe njengombhalo, noma imodi yokukhuluma ivuliwe. Futhi, kungenzeka kube nephutha ku-syntax (isibonelo, ukuba khona kwesikhala ngaphambi kwesignali "="). Uma ngemuva kokushintsha idatha kumaseli ahlobene umphumela awubuyekezwanga, khona-ke udinga ukubheka ukuthi ukubuyekezwa kokuzenzakalela kulungiselelwe kanjani kuzilungiselelo zencwadi. Futhi, kaningi, esikhundleni somphumela oqondile, iphutha likhonjiswa esitokisini. Lapha udinga ukubuka wonke amanani afakwe ngumsebenzi. Uma iphutha litholakala, kufanele lilungiswe.
