Indlela yokuthola amaphutha kumafomula ayinkimbinkimbi ngenjini yokulungisa amaphutha ehlakaniphile ye-Excel

Ukusebenza ngamaspredishithi agcwele amafomula kungaba kuhle kakhulu... kuze kube yilapho kukhona okungahambi kahle bese kuvela inkinga eyimfihlakalo. Iphutha ku-Excel ongazi ukuthi livelaphi futhi uqaphele Amaphutha avame kakhulu kumafomula e-ExcelNjengoba amafomula eba made futhi eyinkimbinkimbi, ukuthola umthombo wenkinga ngeso kuba nzima kakhulu, futhi isikhathi esiningi siyachithwa ukuhlola iseli ngeseli.

Ngenjini entsha yokulungisa amaphutha ehlakaniphile kanye namathuluzi okuhlola amaphutha, i-Excel inikeza usizo olwengeziwe ku- ukuthola, ukuqonda, nokulungisa amaphutha kumafomula ayinkimbinkimbiKodwa-ke, ukuze uthole okuningi kuzo, kubalulekile ukwazi imithetho embalwa eyisisekelo yokubhala amafomula, ukuqonda ukuthi kusho ukuthini imilayezo ehlukene yamaphutha, kanye nokwazi ukuthi ungazilungisa kanjani ngokuzenzakalelayo izilungiso eziningi, ikakhulukazi uma idatha engenisiwe evela kwezinye izinhlelo futhi ziza ngezindlela ezahlukene ezingavamile.

Imiqondo eyisisekelo yokuqinisekisa ukuthi amafomula awaphumeleli kusukela ekuqaleni

Ngaphambi kokungena ezinjinini ezihlakaniphile kanye nabalungisi bezinkinga abathuthukile, kubalulekile ukuqonda imithetho eyisisekelo evimbela amaphutha amaningi. I-Excel iqinile kakhulu nge-syntax, futhi noma yimiphi imininingwane emincane ingabangela izinkinga. ifomula ihunyushwa njengombhalo noma yehluleka ngokuphelele.

Into yokuqala futhi ebaluleke kakhulu ukuthi Yonke ifomula kumele iqale ngophawu olulinganayo (=)Uma uphawu lokulingana lushiywe ngaphandle, i-Excel ayiqondi ukuthi ufuna ukwenza isibalo, kodwa kunalokho ukuthi ufaka umbhalo noma usuku. Isibonelo, uma uthayipha i-SUM(A1:A10) ngaphandle kophawu lokulingana, iseli lizobonisa ngokoqobo i-SUM(A1:A10) futhi ngeke lenze noma yikuphi ukubala. Kwenzeka okufanayo ngezinsuku: uma uthayipha u-11/2 futhi ifomethi yeseli ingu-General, i-Excel ingase ibonise u-2-nov (Novemba 2nd) esikhundleni sokuhlukanisa u-11 ngo-2, ngoba ichaza ukuthi uyinika usuku hhayi ukubala. Lokhu kuhlobene Iphutha elimangalisayo ledethi le-Excel.

Elinye iphuzu elibalulekile ukusetshenziswa kahle kwama-parenthesis. Wonke umsebenzi osebenzisa wona kumele ube nawo i-parenthesis yokuvula nokuvala ebekwe kahleUma usebenza ne imisebenzi esidlekeKuvamile kakhulu ukushiya i-parenthesis eyodwa eyengeziwe noma eyodwa ingekho, okubangela amaphutha e-syntax. Cabanga ngefomula efana ne-=IF(B5<0,"Not valid",B5*1,05). Uma ubhala ngephutha =IF(B5<0,"Not valid",B5*1,05)) nge-parenthesis eyengeziwe yokuvala, ifomula izoyeka ukusebenza ngoba inani le-parenthesis ngeke lifane. Ukuhlola njalo ukuthi kunenani elifanayo le-parenthesis yokuvula nokuvala nokuthi isendaweni efanele kubalulekile ukuze kugwenywe amaphutha okunzima ukuwathola.

Kubalulekile futhi ukuphatha amabanga ngendlela efanele. Ukuze ubhekisele kumaseli amaningana alandelanayo, kumele usebenzise ikholoni (:) phakathi kweseli lokuqala nelokugcinaUbubanzi bubhalwe, isibonelo, njengo-A1:A5. Uma ushiya ikholoni bese ugcina ngento efana ne-=SUM(A1 A5), i-Excel izochaza lokhu njengezinkomba ezingavumelekile phakathi kwamaseli angahlobene futhi izobuyisa iphutha. #NULL!, okuyiyona ebonakala lapho kukhona ukuhlangana okungekho noma izinkomba ezingahambisani.

Okokugcina, inani kanye nohlelo lwezimpikiswano zomsebenzi ngamunye kumele kuhlonishwe. Eminye imisebenzi idinga izimpikiswano eziphoqelekile kanye nesimo esithileEminye imisebenzi idinga ama-agumenti amaningi, kanti eminye ivumela amapharamitha okuzikhethela. Uma uphelelwa ama-agumenti, noma wengeza okungaphezu kwalokho okudingekayo, i-Excel izokuxwayisa ngemiyalezo yamaphutha ehlobene nomsebenzi. Ukwazi i-syntax eqondile yomsebenzi ngamunye (inani lama-agumenti, uhlobo lwedatha olulindelekile, njll.) kusiza ukunciphisa izinkinga ngaphambi kokuba zivele.

Izinhlobo zempikiswano: izinombolo, umbhalo, kanye nemikhawulo yokwakha isidleke

Imisebenzi ye-Excel ayidingi nje inani elithile lama-agumenti, kodwa futhi ilindele ukuthi idluliselwe uhlobo lwedatha olufanele kumpikiswano ngayinyeUmsebenzi owenzelwe ukwengeza izinombolo awufani nalowo owenzelwe ukuguqula umbhalo; uma ushintshaniswa, imiphumela ingaba engalindelekile noma iveze iphutha.

Isibonelo, imisebenzi efana ne-SUM, i-AVERAGE, noma i-PRODUCT idinga izimpikiswano zezinombolo. Uma ubadlulisela amanani ombhalo lapho belindele khona izinombolo, i-Excel ingase ibuyisele u-0, inganaki amaseli, noma ibonise iphutha kuye ngomongo. Ngokuphambene nalokho, imisebenzi efana ne-REPLACE, i-CONCAT, noma i-RIGHT yenzelwe ukusebenza ngezintambo zombhalo. Kulezi, okungenani eyodwa yezimpikiswano kumele ibe inani lombhalo noma ireferensi yeseli equkethe umbhalo; uma uphoqa inombolo ukuthi iphathwe njengombhalo ngaphandle kokuphathwa kahle, umsebenzi ungase ungasebenzi njengoba bekulindelekile.

Ngaphezu kwalokho, i-Excel ibeka umkhawulo omkhulu ekuhlanganiseni imisebenzi ngaphakathi komunye nomunye. Awukwazi faka amazinga emisebenzi angaphezu kuka-64 kwifomula eyodwaLokhu kusho ukuthi uma unefomula enezitatimende ze-IF ngaphakathi kwezitatimende ze-IF ngaphakathi kwezitatimende ze-IF, njalo njalo, kunephuzu lapho i-Excel ingeke yamukele amanye amazinga. Nakuba empeleni bambalwa abantu abafinyelela kulezi zigaba eziphakeme, kumamodeli ayinkimbinkimbi kakhulu noma aklanywe kabi lo mkhawulo ungadlulwa, okubangela amaphutha okunzima ukuwachaza. Ngale kwezinga elithile lobunzima, ngokuvamile kuhlakaniphile ukuhlukanisa i-logic ibe amaseli amaningana asizayo kunokuzama ukugxila konke kufomula eyodwa, ende kakhulu; ngalokhu, kuyalulekwa futhi ukubuyekeza Izimbangela nezixazululo zezinkinga zokusebenza ku-Excel.

Isibonelo esijwayelekile sephutha ngenxa yohlobo lwempikiswano nenombolo umsebenzi we-ABS. Lo msebenzi wamukela kuphela impikiswano eyodwa yenombolo futhi ibuyisela inani layo eliphelele. Uma uthayipha into efana ne-=ABS(-2;134), i-Excel izobonisa iphutha ngoba umsebenzi awazi ukuthi wenzeni ngezimpikiswano ezimbili ezihlukaniswe yi-semicolon. Indlela efanele ingaba yinto efana ne-=ABS(-2134) noma =ABS(A1) uma iseli A1 liqukethe inombolo engemihle ofuna ukuyiguqula ibe yinhle.

Ngakolunye uhlangothi, ukusetshenziswa kwezihlukanisi kumele kucatshangelwe kuye ngezilungiselelo zesifunda. Ezintweni eziningi zokufakwa kweSpanishi ze-Excel, okulandelayo kusetshenziswa: i-semicolon (;) njengesihlukanisi sempikiswano kanye nekhoma (,) yengxenye yedesimali. Uma ifomula ixuba amakhoma nama-semicolon ngephutha ezindaweni ezingafanele, ingadala amaphutha engeziwe e-syntax ayenza kube nzima ukufunda nokulungisa amaphutha efomula.

Ngamafuphi, ukukhetha uhlobo lwedatha olufanele okufanele ludluliselwe kumsebenzi ngamunye, ukuhlonipha inani lama-agumenti achazwe ku-syntax yawo, kanye nokungadluli imikhawulo yokuzalela kuyizinto ezintathu eziyisisekelo zokunciphisa ukwenzeka kwamaphutha kumafomula ayinkimbinkimbi.

Izinkomba kwamanye amakhasi nezincwadi: indlela yokugwema amaphutha okuxhumanisa

Uma amafomula eqala ukuxhumanisa namanye amashidi encwadini efanayo noma ngisho nasezincwadini zokusebenzela zangaphandle, kulula kakhulu ukwenza amaphutha amancane okuthayipha agcina ekhiqize imiyalezo yokubhekisela engavumelekile. I-Excel idinga ukuthi wenze kanjalo Amagama amashidi, izincwadi, kanye nemizila abhalwe ngendlela eqondile kakhulu ukuze kutholakale idatha ngendlela efanele.

Uma kufomula ubhekisela eshidini elinegama elihlanganisa izikhala noma izinhlamvu ezingezona izinhlamvu (izinombolo, ama-hyphen, izimpawu…), igama kumele lifakwe njalo. ngezingcaphuno ezilodwaIsibonelo, uma uneshidi elibizwa ngokuthi i-Quarterly Data, ireferensi efanele yeseli D3 kulelo shidi ingaba yi-='Quarterly Data'!D3. Ngokufanayo, uma ishidi libizwa ngokuthi i-123, ungabhala u-='123'!A1 ukuze i-Excel iqonde igama leshidi futhi ingaliphambanisi nenombolo engahleliwe.

Ngaphezu kwalokho, noma nini lapho ifomula ikhomba kwelinye ishidi, i-hyphen kumele ibekwe ngokushesha ngemva kwegama. uphawu lokubabaza (!)Uphawu lokubabaza (```) lubonisa ukuguquka phakathi kwesihlonzi seshidi kanye nereferensi yeseli ethile. Isibonelo esiphelele singaba: ='Idatha Yekota'!D3. Uma uphawu lokubabaza lushiywe noma lubekwe ngendlela engafanele, ifomula ngeke isebenze futhi kuzovela amaphutha okubhekisela.

Uma ulwazi lusencwadini yokusebenzela kwenye indawo, i-Excel idinga umongo owengeziwe. Kulezi zimo, ireferensi yangaphandle kumele ifake phakathi igama lefayela elikumabakaki, igama leshidi, kanye nobubanziIsibonelo, uma ufuna ukubala inani lemigqa kububanzi buka-A1:A8 bencwadi yokusebenza ethi Operations T2.xlsx, kushidi lokuthengisa, ungasebenzisa ifomula efana ne-=ROWS('Sales'!A1:A8). Uma ifayela lingavuliwe, udinga futhi ukunikeza indlela yefayela ephelele, njenge-'C:\My Documents\Sales'!A1:A8, ngaphakathi kwefomula.

Ifomula evamile kulo mongo ingaba yinto efana ne-=ROWS('C:\My Documents\Sales'!A1:A8). Lo myalelo uzobuyisela inani lemigqa ebangeni le-A1:A8 kuleyo ncwadi yokusebenzela, kulokhu okungaba ngu-8. Uma kwenzeka iphutha ekuthayipheni indlela, igama lencwadi yokusebenzela, igama leshidi, noma amabakaki asikwele, umphumela uzoba iphutha. iphutha lereferensi noma inani elingabuyekezi ngoba i-Excel ayikwazi ukuthola umthombo wedatha wangaphandle.

Kunconywa futhi ukuqapha okwenzekayo lapho amafayela aqukethe idatha exhunyiwe esuswa, eqanjwa kabusha, noma esuswa. Injini yokuhlola amaphutha ingase ithole ezinye izinkinga, kodwa uma ifayela langaphandle lingasekho endaweni elindelwe, kuzodingeka ubuyekeze izixhumanisi ngesandla noma uchaze kabusha izindlela zokubuyisela ukusebenza kwefomula.

Ukufometha izinombolo kumafomula: amaphutha ngenxa yezimpawu kanye nabahlukanisi

Enye yezinkinga ezivame kakhulu kumaspredishithi anedatha eningi, ikakhulukazi uma ivela kwezinye izinhlelo zokusebenza, ukusetshenziswa kwe Amafomethi ezinombolo angalungile ngaphakathi kwamafomulaI-Excel ihlukanisa ngokucacile phakathi kwenani langempela eligcinwe kuseli kanye nokufometha okusetshenziselwa ukubonisa lelo nani. Ukudideka kwala mazinga amabili kuvame ukuholela emaphutheni amancane.

Izinombolo akufanele zifomethwe ngamafomula. Okusho ukuthi, uma inani liyi-euro eyi-1000, kumele livele kufomula njengo-1000, ngaphandle kophawu lwe-€, abahlukanisi bezinkulungwane, noma amakhoma. Uma ubhala u-1.000 noma u-1,000 (kuye ngezilungiselelo zesifunda), i-Excel cishe izoyichaza njengesihlukanisi sempikiswano noma inani elihlukile kunalelo obulihlosile. Izinombolo zifomethwe ngohlobo lwemali, abahlukanisi bezinkulungwane, noma abahlukanisi bedesimali. ngemuvaUkusebenzisa izinketho zokufometha kweseli, hhayi ngaphakathi kwenkulumo; ukuthola imininingwane eyengeziwe yokuthi ungawasebenzisa kanjani amafomethi ngendlela efanele, bheka ifomethi yedatha ku-Excel 365.

Cabanga ukuthi ufuna ukwengeza u-3100 kokuqukethwe kweseli A3. Uma uthayipha ngokwemvelo u-=SUM(3.100,A3) ucabanga ukuthi usho u-3100, i-Excel izochaza lokhu njengokwengeza u-3 no-100 kuqala, bese ingeza inani lika-A3 emphumeleni. Ngamanye amazwi, izobala u-(3 + 100) + A3, okungafani no-A3 + 3100. Ifomula efanele izoba u-=SUM(3100,A3), ngaphandle kokuzama ukumelela ifomethi yokuhlukanisa izinkulungwane.

Kwenzeka into efanayo ngemisebenzi eyamukela kuphela inani elithile lama-agumenti, njenge-ABS, eyamukela kuphela inani lezinombolo. Uma uzama ukubhala amakhoma noma ama-semicolon ngaphakathi kwenombolo ukuze ulingise izinkulungwane, i-Excel izoyibheka njenge-agumenti eziningana ezihlukene, futhi umsebenzi ngeke usebenze. izobuyisa iphutha le-syntaxNgakho-ke, izinkulumo ezifana ne-=ABS(-2;134) azisebenzi, kuyilapho i-=ABS(-2134) isebenza.

Lokhu kubaluleke kakhulu okufanele kukhunjulwe lapho ungenisa idatha kusuka ezinhlelweni zokubala, ama-ERP, noma izinhlelo zokukhokha. Iningi lala manani okuthumela ngaphandle anefomethi, izimpawu zemali, izikhala, noma ngisho negama elithi "EUR" ekugcineni. Konke lokhu kuguqula lokho okufanele kube yinani lezinombolo libe umucu wombhalo i-Excel engakwazi ukuwusebenzisa ngqo ekubaleni kwayo, okuholela emaphutheni ohlobo, imiphumela engenalutho, noma izibalo ezingahlangani.

Umkhuba omuhle kakhulu ukugcina idatha egciniwe njenge izinombolo ezingavuthiwe kumaseli ngaphandle kokufometha okukhethekile Bese usebenzisa ukufometha okubonakalayo kwemali, iphesenti, noma isihlukanisi sezinkulungwane kusuka kumenyu yokufometha. Lokhu kuvimbela izimpawu ukuthi zingaphazamisi ukubalwa futhi kuvumela injini yephutha ukuthi ibone kangcono ukungahambisani.

Ukuhlola amaphutha okuhlakaniphile nokulungisa amaphutha ku-Excel

Ngaphezu kokulungisa i-syntax, i-Excel ifaka uhlelo lwe- ukuhlola iphutha okuhlaziya amafomula futhi kusikisele ukulungiswa Uma ithola okuthile okungavamile, le njini ehlakaniphe kakhulu isiza ekutholeni izinkomba ezingekho, ukungalingani, kanye nezinkinga zokuthayipha kumafomula ayinkimbinkimbi, okunciphisa isikhathi esithathayo ukuthola umthombo wephutha.

Kuhlobo lwedeskithophu lwe-Excel, ukuhlola amaphutha kungafinyelelwa kuthebhu yeFomula, ngaphakathi kweqembu le-Formula Editing, lapho kuvela khona inketho ethi Error Checking. Lo mthakathi uskena amaseli ngezixwayiso futhi ubonisa imiyalezo enezimbangela ezingaba khona zenkinga, kanye nokuphakamisa izinguquko ezithile ezingasetshenziswa ngokuchofoza okukodwa. Kuwusizo ekutholeni amabanga angavumelani, amafomula angakabuyekezwa lapho ehudulwa, izinkomba zamaseli angenalutho, noma ukungahambisani kwenani.

Noma kunjalo, ku-Excel Online (inguqulo yewebhu), okwamanje akunakwenzeka ukumisa noma ukusebenzisa le mithetho yokuhlola amaphutha ethuthukisiwe ngendlela efanayo. Isevisi yamafu inikeza imisebenzi eyisisekelo, kodwa ayifaki isethi ephelele yemithetho yokubuyekezwa kwefomula Iyatholakala kudeskithophu. Ngakho-ke, uma usebenza ngezincwadi zokusebenza eziyinkimbinkimbi kakhulu, kungcono kakhulu ukuzivula ngohlelo lokusebenza lwedeskithophu ukuze usebenzise ngokugcwele injini yokulungisa amaphutha.

Uma unenguqulo yedeskithophu, ungasebenzisa inkinobho ethi "Vula nge-Excel" ku-Excel Online ukuze uqalise incwadi yokusebenza kuhlelo lokusebenza oluphelele. Uma usufikile lapho, ungenza konke ukuhlola okudingekayo ukuze uthole amaphutha efomula angaba khona, usebenzise imithetho ethile, futhi ubuyekeze noma yiziphi izixwayiso uhlelo oluzinikezayo. Kuyindlela ephumelelayo yokuhlanganisa ukulula kokusebenza ku-inthanethi namandla ohlelo lokusebenza lwedeskithophu.

Ukuze uhlale usesikhathini ngamakhono amasha enjini yokuqinisekisa kanye nokuthuthukiswa kwamathuluzi okulungisa amaphutha ahlakaniphile, kuyalulekwa ukuthi uhlole amadokhumenti ngezikhathi ezithile. I-Microsoft Excel Ibhulogi EsemthethweniYilapho izindaba, izibuyekezo, kanye nezinguquko kudeskithophu kanye nezinguqulo eziku-inthanethi zishicilelwa khona, okukusiza ukuthi wazi ukuthi izici ezintsha zokulungisa amaphutha zitholakala nini.

Uma udinga ukufinyelela okubanzi kuzo zonke izinhlelo zokusebenza ze-Office (i-Word, i-Excel, i-PowerPoint, njll.) kanye nezinsizakalo ezihambisana nazo, ungazama noma uthenge i-suite ephelele nge-Office.com, uqinisekise ukuthi unamathuluzi okuhlola amaphutha athuthuke kakhulu kuwo wonke amaspredishithi akho.

Amaphutha abangelwa izinombolo ezigcinwe njengombhalo nokuthi ungawalungisa kanjani ngobuningi

Isimo esivame kakhulu, ikakhulukazi ezindaweni zokubalwa kwezimali noma zezimali, sivela lapho kuthunyelwa incwadi eningiliziwe (i-GL enemininingwane) kusuka kusofthiwe yokuphatha. Ezimweni eziningi, lolu hlobo lwezinhlelo zokusebenza Bathumela amanani ezinombolo njengombhaloUmphumela uba ukuthi, lapho ifayela livulwa ku-Excel, amafomula azama ukwengeza, ukususa, noma ukuhlaziya lawo masimu awawaqapheli amanani njengezinombolo, futhi imisebenzi iyahluleka noma ikhiqize imiphumela engalungile.

Ukuhlola amaphutha okwakhelwe ngaphakathi kwe-Excel kungabona le nkinga futhi kubonise unxantathu oluhlaza okwejwayelekile ekhoneni lamaseli, okubonisa ukuthi "inombolo igcinwa njengombhalo." Ukuchofoza isithonjana sesixwayiso kunikeza i-Excel inketho yokuguqula umbhalo ube yinombolo. Inkinga ukuthi, ngokuzenzakalelayo, uma usebenzisa ithuluzi lokuhlola amaphutha kuthebhu yefomula > Ukuhlela amafomula > Ukuhlola amaphutha, ukulungiswa kuvame ukusetshenziswa. iseli ngeseliokungaba yinto ecasulayo ku-GL enezinkulungwane zemigqa.

Ngaphezu kwalokho, uma idokhumenti yonke ikhethiwe, ukuhlola amaphutha akugxili kuphela kumakholomu ezinombolo, njengoba amanye amakholomu aqukethe izinsuku, umbhalo, kanye nezincazelo nawo angabangela izexwayiso, okwenza inqubo yokulungisa inqwaba ibe nzima nakakhulu. Umbuzo onengqondo kulo mongo ukuthi ikhona yini indlela yokukhetha lonke ishidi bese i-Excel ilungisa wonke la maphutha ngokuguqula umbhalo ube izinombolo zangempela ngesikhathi esisodwa.

Kunezindlela eziningana ezingasetshenziswa ngqo kusuka kudeskithophu ye-Excel ukuxazulula lezi zinhlobo zezimo. Enye yezindlela eziqondile kakhulu ihilela ukusebenzisa inhlaka ekhethekile enomsebenzi wezibaloIsibonelo, ungathayipha inombolo 1 kuseli elingenalutho, ukopishe lelo seli, ukhethe uhla lwamaseli aqukethe izinombolo ezigcinwe njengombhalo (isibonelo, ikholomu yonke yamanani), bese usebenzisa i-Namathisela Okukhethekile > Ukuphindaphinda. Lo msebenzi ubangela i-Excel ukuthi ihumushe okufakiwe "kombhalo" ngakunye njengenombolo, ikuphindaphinde ngo-1, bese igcina umphumela njengenani langempela lezinombolo, ilondoloze inani elifanayo. Kuyindlela ephumelela kakhulu yokuguqula inani elikhulu ledatha ngobuningi.

Enye indlela ukusebenzisa umsebenzi we-VALUE kukholomu yokusiza. Uma, isibonelo, amanani ombhalo akukholomu B, ungakha ifomula efana ne-=VALUE(B2) kukholomu C, uyikopishe phansi, bese ukopisha bese unamathisela imiphumela njengamanani kukholomu yokuqala, ushintsha umbhalo. Le ndlela ikuvumela futhi ukuthi uqinisekise ngokubonakalayo ukuthi konke kuyafana ngaphambi kokususa idatha yokuqala.

Kwezinye izimo, izexwayiso "zenombolo egcinwe njengombhalo" zikuvumela ukuthi ukhethe ububanzi obubanzi futhi usebenzise ukuguqulwa kumaseli amaningi ngesikhathi esisodwa kusuka kumenyu yomongo kanxantathu oluhlaza omncane. Kodwa-ke, ukusebenza kwazo kuncike ekutheni idatha yakhiqizwa kanjani nokuthi i-Excel ithola zonke izimo njengohlobo olufanayo lwephutha.

Uma usebenza ngemininingwane eminingi yokubalwa kwezimali, kuyalulekwa futhi ukuthi ubuyekeze izilungiselelo zesifunda ze-Excel kanye nefomethi yokuthumela yohlelo lomthombo. Ukulungisa la mapharamitha ukuqinisekisa ukuhambisana kwabahlukanisi bedesimali, izimpawu zemali, kanye namafomethi osuku kunciphisa kakhulu ukuvela kwezinombolo kufomethi yombhalo kanye namaphutha asakazekile, futhi kuvumela amafomula ukuthi asebenze kahle kusukela ekuqaleni.

Ngamafuphi, nakuba ukuhlola amaphutha okujwayelekile kuvame ukusebenza umugqa nomugqa, ukuhlanganisa izixwayiso zakho namasu anjengokunamathisela okukhethekile nemisebenzi yokuguqula kungenzeka ukulungisa amabhlogo amakhulu edatha engakahleleki kahle ngobuningi futhi ubuyisele isimo sazo njengezinombolo ngaphandle kokuya kuseli ngeseli.

Lonke lolu sethi lwezincomo mayelana nophawu lokulingana, ama-parentheses, ububanzi, izinhlobo zempikiswano, ukufometha kwezinombolo, izinkomba zangaphandle, kanye namathuluzi okuhlola amaphutha ahlanganyela umgomo ofanayo: ukunika amandla injini entsha yokulungisa amaphutha ye-Excel ukuthi isebenze kahle kakhulu. Uma amafomula akhiwe kahle futhi idatha isebenzisa uhlobo olufanele kanye nefomethi, uhlelo lwezexwayiso neziphakamiso luba umsizi onamandla wokuthola ngokushesha ukungahambisani, izinkomba eziphukile, noma amaseli anenkinga, ngisho nasemakhasini okusebenzela anamafomula ayinkimbinkimbi kakhulu kanye nedatha engeniswe emithonjeni eminingi.

I-athikili ehlobene:

Amaphutha ajwayelekile kakhulu kumafomula e-Excel nendlela yokuwalungisa

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.