Ulibeka njani ixabiso elipheleleyo kwi-Excel? Ngaphakathi kweli nqaku siza kukufundisa, ngamanyathelo alula.
Kuyaziwa ukuba i-Excel yi-sisoftware, ekwaziyo ukuququzelela, ukugcina kunye nokuhlela zonke iintlobo zedatha kunye nolwazi. Kunzima kakhulu ukusebenzisa, kodwa kuluncedo kakhulu xa sifuna ukugcina umbutho wonke weshishini, indawo, imbali, phakathi kwezinye ezininzi.
I-Excel, njengesixhobo esikrelekrele, ikwasivumela ukuba senze imisebenzi yezibalo engapheliyo, efanayo esihlala siyidinga, ngaphakathi kweeprojekthi zethu, imisebenzi, okanye iirekhodi ezikhankanywe ngasentla.
Ngoko ekugqibeleni, I-Excel inokusinceda ukubala ixabiso elipheleleyo, kuba oku kufuneka ukwazi. Ukuba ngenxalenye yalo, ixabiso elipheleleyo ngumgama okhoyo phakathi kwenani elinikiweyo kunye no-zero, oku kuthetha ukuba isiphumo esifunyenweyo siya kuhlala siyinani eli-positive, nokuba ixabiso ngokwenene li-negative.
Ngale ndlela, i-Excel ikwasivumela ukuba songeze uluhlu olupheleleyo okanye uluhlu lwamanani a-positive kunye nama-negative phakathi kwamaphepha okusebenzela.
Ukuba ufuna ukwazi, ukuba ungayenza njani yonke loo nto, hlala ngaphakathi kwesi sifundo, apho siya kukufundisa khona indlela yokubeka ixabiso elipheleleyo kwi-excel.
Imisebenzi ye-Excel esivumela ukuba sibeke ixabiso elipheleleyo
Ngokwenyani i-Excel, inemisebenzi eyahlukeneyo, evumela ukuba sibale kwaye songeze ixabiso elipheleleyo lenani, ngaphakathi kwamaphepha okusebenzela, le misebenzi ilandelayo:
umsebenzi ABS
Lo ngomnye wemisebenzi yokuqala, ekhuthazwayo ukuba sifuna Yongeza ixabiso elipheleleyo kwi-excel spreadsheet. Ngaphakathi kwayo, ixabiso elipheleleyo lenani lisekiwe, ngaphakathi kweseli eyodwa. Lo ngumsebenzi osisiseko, ongenako ukongeza amaxabiso apheleleyo ngokuzenzekelayo, kodwa usivumela ukuba siwenze ngesandla.
Ukuze siyenze, kufuneka senze oku kulandelayo:
Vula iphepha le-Excel elingenanto kwaye uqale ukungena -3454 kwiseli B3, emva koko kufuneka ukhethe iseli elandelayo, B4, ukuba ikuyo cofa umyalelo “FxOku kuya kuvula ifestile entsha, apho kufuneka ukhethe "faka umsebenzi”. Emva koko imenyu eyehlayo iya kuvela, apho kufuneka ukhethe udidi "ABS”, ifestile entsha iya kuvula ngoko nangoko ngaphantsi kwayo.
Emva koko kufuneka ucofe iqhosha elithi "reference reference" kwindawo ethi "inani” uze ukhethe kwakhona iseli B3. Emva koko kuya kufuneka ucofe ku "Kulungile", ngaloo ndlela ulwazi luya kongezwa. Umsebenzi we-ABS ngaphakathi kwispredishithi. Kuloo nto uya kuqaphela ukuba iseli B4 ngoku iza kuthatha ixabiso lika-3454.
Ukuba uyafuna, unokufumana ixabiso elipheleleyo loluhlu lweeseli, kunye nalo msebenzi ofanayo, ngokongeza ikholamu ye-ABS ngaphakathi kwespredishithi. Emva koko ungafaka umsebenzi we-ABS kulo kholamu, ungenisa i-equation =SUM, kwiseli esezantsi kwekholamu, ngaloo ndlela unokongeza amaxabiso apheleleyo afunyenweyo.
Yiloo nto ke. Kulula kakhulu, akunjalo? Ngaloo ndlela uya kuba nakho beka ixabiso elipheleleyo ngaphakathi kweshiti lokugqwesa.
Ukudityaniswa kwe-ABS kunye nomsebenzi we-SUMPRODUCT ukubeka ixabiso elipheleleyo kwi-Excel
Umsebenzi we-ABS, ngokufutshane, uluncedo kakhulu ekubaleni ixabiso elipheleleyo kwaye unokudityaniswa neminye imisebenzi, kulo mzekelo sithetha ngomsebenzi we-SUMPRODUCT, osivumela ukuba sinikeze uluhlu olubi okanye olulungileyo kwixabiso elipheleleyo.
Ukuze ukwazi beka ixabiso elipheleleyo kwi-excel, usebenzisa le misebenzi mibini, kufuneka wenze oku kulandelayo:
Kufuneka uqale uvule i-Excel sheet entsha. Kwaye emva koko uyigcwalise ngedatha eyiliweyo. Ungangenisa amaxabiso 4, 4 kunye 7 kwiiseli A2, A3 kunye A4. Emva koko kufuneka ukhethe iseli A5 kwaye ucofe, ngaphakathi kwebar ebizwa ngokuba yi "effects". Emva koko kufuneka ufake ifayile umsebenzi =UMVELISO(A2:A4), kwibar efanayo "yeziphumo" emva kokuba kufuneka ukhethe "OK"Okanye"Ngethulo", oku kuya kwenza iseli A5, ibe yinombolo 7, engelilo ixabiso elipheleleyo.
Emva koko kufuneka ufumane ixabiso elipheleleyo, oku kufuneka sidibanise umsebenzi we-ABS kunye namanyathelo angaphambili, ngoko ke umsebenzi kunye nenxaki yawo yoqobo kufuneka itshintshwe kule nto. =UMVELISO (ABS(A2:A4)). Oko kuya kubangela ukuba i-A5 ibe yi-15, oko kukuthi, 4+4+7, ukuze uluhlu lweseli, lunike isiphumo esithe ngqo.
Ulungile! Nangona olu khetho lunokubonakala lunzima ngakumbi kunolu lwangaphambili, xa ulusebenzisa, uya kuqaphela ukuba lulula kangakanani.
Umsebenzi we-SUMIF ukufumana ixabiso elipheleleyo kwi-Excel
Lo msebenzi uvumela abasebenzisi be-Excel ukuba bongeze amaxabiso adibana nothotho lweenqobo ezithile. Ngayo sinokufumana ixabiso eligqibeleleyo, kuluhlu olunikiweyo lweeseli, kufuneka songeze lenxaki ilandelayo. SUMIF(uluhlu, iinqobo zokugweba,[sum_uluhlu]). Ngaloo ndlela unokufumana ixabiso elipheleleyo, ngokuzenzekelayo.
Kwelinye icala, ukuba ufuna ukuba umsebenzi wenziwa ngendlela eyongezelelekileyo, ngenisa umsebenzi kwi “Iziphumo”. Ukukhetha iseli A6, emva koko ungenisa idatha =SUMIF(A2:A4,»>0″)-SUMIF(A2:A4,».
Kwaye oko kuya kuba konke, kulula akunakwenzeka.
I-plugin ye-Kutools
Esi, kwelinye icala, sisixhobo sangaphandle, kodwa sisebenza kakuhle kakhulu kunye ne-Excel, ngayo unokwenza imisebenzi eyahlukeneyo kwaye phakathi kwabo, leyo fumana ixabiso elipheleleyo, kukwasinceda ukuba sitshintshe iimpawu zamaxabiso, ukusuka ku-negative ukuya kumanani a-positive, ngaphakathi kwephepha lethu le-Excel.
Ukuba ufuna ukufikelela kuyo yonke imisebenzi kunye neenzuzo zayo, konke okufuneka ukwenze kukuyifaka kwikhompyuter yakho kwaye uqalise ukusebenza nayo.
Isiphelo
Kukho ngokwenene iindlela ezimbalwa zokufumana ixabiso elipheleleyo loluhlu lwamanani ngaphakathi kwespredishithi ye-Excel. Kodwa nganye kwezi zichazwe ngasentla, ilawula ukuzalisekisa loo msebenzi ufunwayo, okhoyo beka ixabiso elipheleleyo ngaphakathi kwe-excel.
Kwelakho icala, ekuphela kwento eseleyo kukukhangela kwaye uchonge eyona ilula kuwe kwaye, ngokucacileyo, eyona ilunge ngakumbi kwiimfuno onazo njengomsebenzisi we-Excel.
Kwabanye, sithemba kuphela ukuba ulithandile inqaku kwaye sele usazi indlela yokubeka ixabiso elipheleleyo kwi-excel.