Ukufunda indlela yokuthola inani eliphelele ku-Excel kungaba usizo kakhulu, ikakhulukazi uma ungomunye wabantu abavame ukusebenzisa lolu hlobo lwefayela ukwenza izibalo zezibalo. I-Excel ingelinye lamathuluzi okwamanje esetshenziswa kakhulu ukubala kwezibalo, ihluzo nezifundo zebhizinisi.
Ngakho-ke ukubaluleka kokufunda ukuthi ungabala kanjani inani eliphelele kulolu hlelo futhi ngaleyo ndlela ukwazi ukuzisindisa izinqubo ezimbalwa ojwayele ukuzenza ngesandla.
Kulesi sihloko sizochaza ukuthi imayelana nani inani eliphelele le-Excel nokuthi ungayithola kanjani ukulandela ezinye izinyathelo.
Imayelana nani inani eliphelele ku-Excel?
Into yokuqala okufanele uyazi ukuthi, ku-Excel, inani eliphelele ngu eyodwa engahlukanga kufomula, kungakhathaliseki ukuthi iseli efakwe kulo alikho kusithenjwa esifanayo namanye. Lokhu kuyasiza ngezikhathi lapho ufuna sebenzisa inani elithile ngezibalo ezahlukene eshidini le-excel.
Uma ufuna ukusebenzisa lo msebenzi we-Excel, kufanele nje engeza uphawu lwe-$ ngaphambi kohlamvu nenombolo yeseli ozobhekisela kuyo kufomula. Uma icala liwukuthi ukhethe iseli B3, kufanele ubhale $B$3.
Kodwa-ke, uma ufuna ukubala inani eliphelele lenombolo yangempela ku-Excel, kufanele sebenzisa umsebenzi we-ABS yohlelo olushiwo. Usizo lwalo msebenzi ukuthi ungawusebenzisela ukusebenza kwezibalo lapho uthanda khona kuphela ukusebenza ngevelu ephozithivu yenombolo noma umphumela.
Ngamanye amazwi, uma ufuna ukubala inani eliphelele ledatha ku-Excel, udinga ukusebenzisa umsebenzi we-ABS wohlelo olushiwo.
Uyini umsebenzi we-ABS ku-Excel?
Umsebenzi we-ABS ungenye ye amafomula i-excel izibalo, kodwa futhi ingenye yezinto eziyinkimbinkimbi kakhulu ukuyisebenzisa. Njengoba sesibonisile, ngayo ungakwazi ukubala inani eliphelele lenombolo yangempela kuspredishithi se-Excel.
Kubalulekile ukuthi qonda i-syntax yomsebenzi we-ABS, ukuze ukwazi ukukusebenzisa ezibalweni ezahlukene ofuna ukuzenza. I-syntax okufanele uyisebenzise eshidini le-Excel ithi: ABS(Number).
Kulokhu, i-ABS itshela uhlelo ukuthi yimuphi umsebenzi ofuna kusetshenziswe kuseli eliwubhalayo. Isigaba inombolo, kufanele ubhale inombolo yangempela noma iseli lapho inombolo ofuna ukubona inani layo eliphelele litholakala khona.
Izinyathelo ongazilandela ukuze wazi ukuthi ungalithola kanjani inani eliphelele ku-Excel
Njengoba sesike sakutshela, ukufunda indlela yokuthola inani eliphelele ku-Excel kubaluleke kakhulu, ikakhulukazi uma uhlela ukwenza izibalo amanani angalungile awakwazi ukuthathwa cabangela. Nazi ezinye izinyathelo ongazilandela ukuze usebenzise umsebenzi we-ABS.
- Into yokuqala okufanele uyenze vula ishidi le-excel futhi uhlole ukuthi iyiphi idatha ofuna ukuthola inani eliphelele. Kunconywa ukuthi hlela idatha ngamathebula, ukuze kube lula ukubala.
- Uma usukhethe iseli ofuna ukusebenzisa kulo inani eliphelele, kufanele ubhale kuseli elishiwo lokhu okulandelayo “=ABS(inombolo noma iseli)".
- Ngokwenza kanjalo uzoqaphela lokho amanani angalungile aba phozithivu futhi yile ndlela ozobona ngayo ukuthi umsebenzi wenani eliphelele uyasebenza.
Lezi yizinyathelo ezilula kakhulu ukuze ukwazi ukusebenzisa umsebenzi we-ABS kunoma yimaphi amathebula noma izibalo ozenzayo.
Izinyathelo zokwazi ukuthi ungalithola kanjani inani eliphelele ku-Excel usebenzisa imenyu yayo
Nakuba sesivele sikunike izinyathelo okufanele uzilandele zokuthi ungalithola kanjani inani eliphelele lenombolo ku-Excel. Nokho, zikhona ezinye izinyathelo ongazilandela futhi ngaleyo ndlela sebenzisa umsebenzi ofanayo. Okulandelayo, sizokutshela ukuthi ziyini:
- Into yokuqala okufanele uyenze vula ifayela le-excel bese ukhetha ukuthi iyiphi iseli noma amaseli ofuna ukukhombisa inani eliphelele lenombolo.
- Uma usesitokisini othakaselayo, kufanele ukhethe isigaba “Amafomula"
- Uma usesigabeni samafomula, udinga ukukhetha inketho "Faka umsebenzi".
- Ukuchofoza lokhu kuvula imenyu lapho ucelwa khona ukuthi ubhale incazelo ngomsebenzi owufunayo. Kulokhu ungasebenzisa "ABS".
- Lapho uhlelo luthola Umsebenzi we-ABS kufanele uchofoze kuso bese ucindezela yamukela.
- Ukwenza kanjalo kuveza imenyu entsha ebizwa ngokuthi “izimpikiswano zokusebenza” futhi lapho ubona khona isigaba esisha esibizwa ngokuthi “Inombolo".
- Esigabeni sezinombolo, kufanele ufake iseli noma inombolo ofuna ukuthola inani layo eliphelele.
- Ngokufaka iseli bese ucindezela yamukela, uzobona ukuthi inombolo ebikade inegethivu iba phozithivu kanjani. Okusho ukuthi, uzobe ubheka inani eliphelele laleyo nombolo noma ukubalwa kwenzuzo.
Isibonelo lapho ukwazi ukuthola inani eliphelele ku-excel kungaba wusizo
Esithombeni sikubonisa isibonelo somsebenzi we-ABS ku-Excel, njengoba ubona kukhona amanani ekholomu ethi "X” kanye namanye amanani "ekholomuY”. Kukholomu elandelayo isibalo se umehluko we-XY, kodwa njengoba amanani ekholomu ethi "X" engaphansi kwamanani ekholomu ethi "Y", uzothola amanani angalungile.
Kodwa-ke, uma usebenzisa umsebenzi we-ABS njengoba sichazile ezinyathelweni ezedlule, uzoqaphela ukuthi izinombolo zisuka ku-negative ziye kuphozithivu. Okusho ukuthi ubheka inani eliphelele lomphumela wokukhipha amanani ka-X nalawo ka-Y.
Este ingenye yamacala alula lapho ungasebenzisa khona umsebenzi ophelele lapho wenza izibalo eshidini le-Excel.
Sebenzisa izinyathelo ngokusemthethweni noma mane ubhale umsebenzi we-ABS ngqo kuseli. ungathola inani eliphelele lazo zonke izibalo noma izinombolo ozifunayo eshidini lakho le-Excel inqobo nje uma ulandela izinyathelo esikunike zona kulesi sihloko.