Ukwahlukana ngenye yezinto ezine ezijwayelekile zokusebenza kwezibalo. Ngokuvamile kunezibalo eziyinkimbinkimbi ezingenza ngaphandle kwakhe. I-Excel inezinhlobo eziningi zemisebenzi yokusebenzisa lolu hlelo lokusebenza. Ake sithole ukuthi singakwenza kanjani ukuhlukaniswa ku-Excel.
Ukwenza ukwahlukana
Ku-Microsoft Excel, ukuhlukaniswa kungenziwa ngokusebenzisa amafomu noma ukusebenzisa imisebenzi. Ukuhlukanisa nokuhlukanisa izinombolo kuyizinombolo namakheli amangqamuzana.
Indlela 1: ukwahlukanisa inombolo ngenombolo
I-Excel sheet ingasetshenziswa njengehlobo lokubala, ngokuhlukanisa inombolo eyodwa ngomunye. Isibonakaliso sokuhlukanisa si-slash (umugqa ongemuva) - "/".
- Sithola kunoma iyiphi isisindo samahhala seshidi noma emgqeni wefomula. Sabeka uphawu kufana (=). Siyiphayipha inombolo yenzuzo kusuka kwikhibhodi. Sibeka uphawu lokuhlukanisa (/). Siyiphayipha umhlukanisi kusuka kwikhibhodi. Kwezinye izimo, kunomeluleki ongaphezu kweyodwa. Bese ubeka umshini ngaphambi kwesahluko ngasinye. (/).
- Ukuze wenze isibalo futhi ubonise umphumela walo kumqapha, chofoza inkinobho. Ngena.
Ngemuva kwalokho, i-Excel izobala ifomula bese ibonisa umphumela wokubala kuseli elicacisiwe.
Uma isibalo senziwa ngezibonakaliso eziningana, khona-ke umyalelo wokukwenziwa kwawo wenziwa wuhlelo ngokuya kwemithetho yezibalo. Okokuqala, ukuhlukaniswa nokuphindaphinda kwenziwa, futhi kuphela ukufaka nokukhipha.
Njengoba wazi, ukwahlukana ngu-0 kuyisenzo esingalungile. Ngakho-ke, ngomzamo onjalo wokwenza isibalo esifanayo ku-Excel, umphumela uzovela esitokisini "#DEL / 0!".
Isifundo: Sebenzisa ngamafomula ku-Excel
Indlela 2: ukuhlukaniswa kokuqukethwe kweseli
Futhi ku-Excel, ungahlanganyela idatha kumaseli.
- Khetha iseli lapho umphumela wokubala uzoboniswa khona. Sibeka uphawu lwakhe "=". Okulandelayo, chofoza endaweni lapho isahlukaniso sitholakala khona. Ngalokhu, ikheli lakhe livela kubha yefomula ngemuva kwesibonakaliso kufana. Okulandelayo, kusuka kukhibhodi usethe isibonakaliso "/". Sichofoza esitokisini lapho umhlukanisi ebeka khona. Uma kunezihlukanisi eziningana, kanye nendlela esedlule, sibonisa konke, futhi sibeka uphawu lwesahlukaniso phambi kwamakheli abo.
- Ukuze wenze isenzo (ukwahlukana), chofoza inkinobho "Faka".
Ungaphinda uhlangane, njengokuhlukanisa noma ukwehlukanisa, usebenzisa kokubili amakheli eseli kanye nezinombolo ze-static ngesikhathi esisodwa.
Indlela 3: ukwehlukanisa ikholomu ngekholomu
Ukubala emathebula ngokuvamile kudingekile ukwahlukanisa izindinganiso zekholomu eyodwa kudatha yekholomu yesibili. Yiqiniso, ungahlukanisa inani leseli ngayinye ngendlela echazwe ngenhla, kodwa ungenza le nqubo ngokushesha kakhulu.
- Khetha iseli lokuqala kukholomu lapho umphumela kufanele uboniswe khona. Sabeka uphawu "=". Chofoza kuseli le-dividend. Uphawu lokuthayipha "/". Chofoza kumhlukanisi weseli.
- Sicindezela inkinobho Ngenaukubala umphumela.
- Ngakho, umphumela ubalwa, kodwa kuphela ngomugqa owodwa. Ukuze wenze ukubalwa kwamanye imigqa, udinga ukwenza izinyathelo ezingenhla ngayinye yazo. Kodwa ungalondoloza kakhulu isikhathi sakho ngokumane usebenzise ukuxhaphaza okulodwa. Setha isikhombisi ekhoneni elingezansi elingakwesokudla leseli ngefomula. Njengoba ungabona, isithonjana sibonakala ngesimo sesiphambano. Ibizwa ngokuthi uphawu lokugcwalisa. Bamba inkinobho yesinxele yesinxele bese uhudula isibambo sokugcwalisa phansi ekupheleni kwetafula.
Njengoba ubona, ngemuva kwalesi senzo, inqubo yokwehlukanisa ikholomu eyodwa ngomzuzwana izokwenziwa ngokugcwele, futhi umphumela uzoboniswa kukholomu ehlukile. Iqiniso liwukuthi ifomula likopishwa kumaseli aphansi esebenzisa uphawu lokugcwalisa. Kodwa, ngokucabangela ukuthi ngokuzenzakalelayo zonke izixhumanisi zihlobene, hhayi ngokuphelele, kwifomula, njengoba uhamba phansi, amakheli eseli ukuguquka ngokuhambisana nezixhumanisi zangempela. Ngokufanayo, yilokho esikudingayo esimweni esithile.
Isifundo: Indlela yokwenza ngokuzenzekelayo ku-Excel
Indlela 4: ukwahlukanisa ikholomu ngokuhlala njalo
Kunezimo lapho kudingekile ukwahlukanisa ikholomu ibe yinye kanye nenombolo efanayo efanayo - njalo, bese uprinta isamba sehlukaniso sibe ikholomu ehlukile.
- Sabeka uphawu kufana esitokisini sokuqala sekholomu yokugcina. Chofoza esitokisini esahlukisiwe salolu hlu. Sabeka uphawu lwesigaba. Bese usebenzisa ngesandla ngekhibhodi ukubeka inombolo efunayo.
- Chofoza inkinobho Ngena. Umphumela wokubala emgqeni wokuqala uboniswa kumqapha.
- Ukuze ubale amanani eminye imigqa, njengangesikhathi esidlule, sibiza uphawu lokugcwalisa. Ngokufanayo ngendlela efanayo siyidonsela phansi.
Njengoba ungabona, manje lesi sigaba senziwa ngendlela efanele. Kulesi simo, lapho ukopisha idatha nomaka wokugcwalisa, izixhumanisi futhi zahlala zihlobene. Ikheli le-dividend yomugqa ngamunye lishintsha ngokuzenzakalelayo. Kodwa umhlukanisi ngalesi simo inamba ehlala njalo, okusho ukuthi impahla yokuzibandakanya ayisebenzi kulo. Ngakho-ke, sahlukanisa okuqukethwe kwamaseli wekholomu sibe njalo.
Indlela 5: ukwahlukanisa ikholomu ibe yiseli
Kodwa yini okufanele uyenze uma udinga ukwahlukanisa ikholomu kukho okuqukethwe kweseli elilodwa. Emva kwakho konke, ngokuvumelana nesimiso sokuhlanganiswa kwezingcaphuno, izixhumanisi ze-dividend kanye ne-divisor zizoshintsha. Kudingeka senze ikheli leseli nomshayeli ohleliwe.
- Setha isikhombisi esitokisini esiphezulu sekholomu ukuze ubonise umphumela. Sabeka uphawu "=". Chofoza endaweni yenzuzo lapho inani eliguquguqukayo likhona. Sibeka umshini (/). Sichofoza esitokisini lapho kuhlukaniswa khona ukwahlukana njalo.
- Ukuze sibheke umhlukanisi ophelele, okungukuthi, njalo, sifaka isibonakaliso se-dollar ($) kwifomula ngaphambi kwezixhumanisi zeseli ngokuqondile futhi ngokuzenzekelayo. Manje leli kheli lizohlala lingashintshi uma ukopisha ngomaka wokugcwalisa.
- Sicindezela inkinobho Ngena, ukubonisa imiphumela yokubala emgqeni wokuqala esikrinini.
- Ukusebenzisa uphawu lokugcwalisa, ukopisha ifomula kumaseli asele ekholomu nomphumela wonyaka.
Ngemuva kwalokho, umphumela wekholomu yonke isilungile. Njengoba ungabona, kulokhu kwakukhona ukuhlukaniswa kwekholomu esitokisini ngekheli elihleliwe.
Isifundo: Ukuxhumanisa okuphelele nokuhlobene ku-Excel
Indlela 6: umsebenzi u-PRIVATE
Ukuhlukaniswa kwe-Excel nakho kungenziwa ngokusebenzisa umsebenzi okhethekile obizwa ngokuthi I-PRIVATE. Ukungafani kwalokhu msebenzi ukuthi ihlukanisa, kodwa ngaphandle kokusala. Okusho ukuthi, uma usebenzisa le ndlela yokuhlukanisa, umphumela uzohlale unenombolo. Ngesikhathi esifanayo, ukujikeleza akukwenziwanga ngokwemithetho yemathemu evunyelwe ngokuvamile kumuntu oseduze, kodwa kumncane. Okusho ukuthi umsebenzi we-5.8 awuhambisani no-6, kepha ku-5.
Ake sibone ukusetshenziswa kwalo msebenzi ngesibonelo.
- Chofoza kuseli lapho umphumela wokubala uzoboniswa khona. Sicindezela inkinobho "Faka umsebenzi" ngakwesokunxele kwebha yefomula.
- Ivula Umsebenzi weWebhu. Kuhlu lwemisebenzi esinikeza yona, bheka into "KUPHAKATHI". Khetha bese uchofoza inkinobho. "Kulungile".
- Iwindi lempikiswano yokusebenza ivula. I-PRIVATE. Lo msebenzi unemibono emibili: isibalo nesibalo. Zifakwe ensimini ngamagama afanele. Ensimini Isibalo faka i-dividend. Ensimini I-Denominator - ukwahlukanisa. Ungangena kokubili izinombolo ezithile namakheli wamaseli lapho idatha ikhona khona. Ngemuva kokuthi wonke amanani afakiwe, chofoza inkinobho "Kulungile".
Emva kwalezi zenzo, umsebenzi I-PRIVATE iqhuba idatha futhi iphume impendulo kwiseli echazwe esiteji sokuqala sale ndlela yokuhlukanisa.
Lo msebenzi ungafakwa futhi ngesandla ngaphandle kokusebenzisa idijithali. I-syntax yayo ilandelayo:
= PRIVATE (isibalo; i-denominator)
Isifundo: I-Excel Function Wizard
Njengoba ungabona, indlela eyinhloko yokuhlukanisa ohlelweni lweMicrosoft Office ukusetshenziswa kwamafomula. Uphawu lokuhlukanisa phakathi kwabo yi-slash - "/". Ngesikhathi esifanayo, ngezinhloso ezithile, umsebenzi ungasetshenziswa ngenqubo yokuhlukanisa I-PRIVATE. Kodwa, kubalulekile ukucabangela ukuthi uma ubala ngale ndlela, umehluko uthola ngaphandle kokusala, njenge-integer. Ngesikhathi esifanayo, ukujikeleza akukwenziwanga ngokuvumelana nemigomo evunyelwe ngokuvamile, kodwa kunani eliyingcosana ngenani eliphelele.
