Ukufunda indlela yokufumana ixabiso elipheleleyo kwi-Excel kunokuba luncedo kakhulu, ngakumbi ukuba ungomnye wabantu abahlala besebenzisa olu hlobo lwefayile ukwenza izibalo zemathematika. I-Excel sesinye sezixhobo okwangoku esetyenziswa kakhulu kubalo lwamanani, imizobo kunye nezifundo zoshishino.
Kungoko ukubaluleka kokufunda ukuba ungabala njani ixabiso elipheleleyo kule nkqubo kwaye ukwazi ukuzigcina iinkqubo ezininzi oqhele ukuzenza ngesandla.
Kweli nqaku siza kuchaza ukuba ingantoni na ixabiso elipheleleyo le-Excel kunye nendlela onokuyifumana ngayo ukulandela amanyathelo athile.
Limalunga nantoni ixabiso elipheleleyo kwi-Excel?
Into yokuqala omele uyazi kukuba, kwi-Excel, ixabiso elipheleleyo li enye engahlukanga kwifomula, kungakhathaliseki ukuba iseli efakwe kuyo ayikho kwireferensi efanayo nezinye. Oku kuluncedo ngamaxesha xa ufuna sebenzisa ixabiso elithile kwizibalo ezahlukeneyo kwi-excel sheet.
Ukuba ufuna ukusebenzisa lo msebenzi we-Excel, kufuneka wenze nje yongeza uphawu lwe-$ phambi konobumba kunye nenani leseli oza kubhekisela kuyo kwifomula. Ukuba imeko kukuba ukhethe iseli B3, kufuneka ubhale I-$3 yeedola.
Nangona kunjalo, ukuba ufuna ukubala ixabiso elipheleleyo lenani lokwenyani kwi-Excel, kufuneka sebenzisa umsebenzi we-ABS yenkqubo ethethiweyo. Uncedo lwalo msebenzi kukuba ungawusebenzisela imisebenzi yemathematika apho unomdla kuphela ekusebenzeni ngexabiso eliqinisekileyo lenani okanye isiphumo.
Ngamanye amazwi, ukuba ufuna ukubala ixabiso elipheleleyo ledatha kwi-Excel, kufuneka usebenzise umsebenzi we-ABS wenkqubo ethethiweyo.
Yintoni umsebenzi we-ABS kwi-Excel?
Umsebenzi we-ABS ngomnye we iifomula Izibalo ezigqwesileyo, kodwa ikwayenye yezona zinto zincinci zinzima ukuyisebenzisa. Njengoko sele sibonisile, ngayo ungabala ixabiso elipheleleyo lenani lokwenyani kwi-spreadsheet ye-Excel.
Kubalulekile ukuba baqonde isintaksi somsebenzi we-ABS, ukuze ukwazi ukuyisebenzisela ubalo olwahlukileyo ofuna ukuzenza. Isivakalisi omawusisebenzise kwiphepha le-Excel sithi: ABS(Number).
Kulo mzekelo, i-ABS ixelela inkqubo ukuba ngowuphi umsebenzi ofuna usetyenziswe kwiseli ewubhalayo. Icandelo inani, kufuneka ubhale inani lokwenyani okanye iseli apho inani ofuna ukubona ixabiso layo elipheleleyo likhoyo.
Amanyathelo onokuthi uwalandele ukuze ukwazi ukufumana ixabiso elipheleleyo kwi-Excel
Njengoko sele sikuxelele, ukufunda indlela yokufumana ixabiso elipheleleyo kwi-Excel luncedo kakhulu, ngakumbi xa uceba ukwenza izibalo apho amaxabiso angalunganga awanakuthatyathwa qwalasela. Nanga amanye amanyathelo onokuthi uwalandele ukwenza umsebenzi we-ABS.
- Into yokuqala ekufuneka uyenzile vula i-excel sheet kwaye khangela ukuba yeyiphi idata ofuna ukufumana ixabiso elipheleleyo. Kucetyiswa ukuba cwangcisa idatha ngokweetafile, ukuze kube lula ukubala.
- Nje ukuba ukhethe iseli ofuna ukufaka kuyo ixabiso elipheleleyo, kufuneka nje ubhale kwiseli echaziweyo oku kulandelayo “=ABS(inombolo okanye iseli)".
- Ngokwenza njalo uya kuqaphela ukuba amaxabiso angakhiyo abe positive kwaye le yindlela oza kubona ngayo ukuba ixabiso elipheleleyo liyasebenza.
La ngawona manyathelo alula ukuze ukwazi ukusebenzisa umsebenzi we-ABS kuyo nayiphi na itafile okanye izibalo ozenzayo.
Amanyathelo okwazi ukufumana ixabiso elipheleleyo kwi-Excel usebenzisa imenyu yayo
Nangona sele sikunike amanyathelo omawuwalandele malunga nendlela yokufumana ixabiso elipheleleyo lenani kwi-Excel. Nangona kunjalo, kukho amanye amanyathelo onokuwalandela kwaye ngaloo ndlela sebenzisa umsebenzi ofanayo. Okulandelayo, sikuxelela ukuba ziyintoni na:
- Into yokuqala ekufuneka uyenzile vula ifayile ye-excel kwaye ukhethe ukuba yeyiphi iseli okanye iiseli ofuna ukubonisa ixabiso elipheleleyo yenani.
- Kanye kwiseli yomdla, kufuneka ukhethe icandelo "Iifomula"
- Kanye kwicandelo leefomyula, kufuneka ukhethe ukhetho "Faka umsebenzi".
- Ukunqakraza koku kuvula imenyu apho ucelwa ukuba ubhale inkcazelo malunga nomsebenzi owukhangelayo. Kule meko ungasebenzisa "ABS".
- Xa inkqubo ifumana Umsebenzi we-ABS kufuneka ucofe kuyo kwaye ucinezele kwamkela.
- Ukwenza njalo kubonisa imenyu entsha ebizwa ngokuba "iingxoxo zokusebenza” kwaye apho ubona icandelo elitsha elibizwa ngokuba “Inani".
- Kwicandelo lamanani, kufuneka ufake iseli okanye inombolo ofuna ukufumana ixabiso elipheleleyo.
- Ngokungena kwiseli kunye nokucofa kwamkela, uya kuqaphela ukuba inani ebekade li-negative liba positive. Oko kukuthi, ubuya kujonga kwixabiso elipheleleyo lelo nani okanye ukubalwa komdla.
Umzekelo wokuba ukwazi ukufumana ixabiso elipheleleyo kwi-excel kunokuba luncedo
Kumfanekiso sikubonisa umzekelo womsebenzi we-ABS kwi-Excel, njengoko ubona ukuba kukho amaxabiso oluhlu "X” kunye namanye amaxabiso e " columnY”. Kuluhlu olulandelayo ukubalwa kwe umahluko we XY, kodwa ekubeni amaxabiso oluhlu "X" engaphantsi kwamaxabiso oluhlu "Y", uya kufumana amaxabiso angalunganga.
Nangona kunjalo, xa usebenzisa umsebenzi we-ABS njengoko besichazile kumanyathelo angaphambili, uya kuqaphela ukuba amanani asuka ku-negative ukuya ku-positive. Oko kuthetha ukuba ujonge kwixabiso elipheleleyo lesiphumo sokuthabatha amaxabiso ka-X nalawo e-Y.
Este yenye yezona meko zilula apho unokusebenzisa umsebenzi ogqibeleleyo xa usenza izibalo kwiphepha le-Excel.
Sebenzisa amanyathelo ngokusesikweni okanye ubhale ngokulula umsebenzi we-ABS ngqo kwiseli. ungafumana ixabiso elipheleleyo lazo zonke izibalo okanye amanani owafunayo kwiphepha lakho le-Excel ukuba nje ulandela amanyathelo esikunike wona kweli nqaku.