Kusetshenziswa ukwahlukaniswa kuMicrosoft Excel

Ukwahlukanisa kungenye yezinto ezijwayelekile ezibala kakhulu. Ukubala okuyinkimbinkimbi akuvamile, okungenza ngaphandle kwawo. I-Excel inokusebenza okubanzi kokusebenzisa lo msebenzi we-arithmetic. Ake sibheke ukuthi iyiphi indlela ukwahlukanisa engenza ngayo e-Excel.

Ukwenza ukwahlukanisa

KuMicrosoft Excel, ukwahlukanisa kungenziwa kusetshenziswa amafomula kanye nokusebenzisa imisebenzi. Kulokhu, izinombolo namakheli amaseli ayavela futhi ayabonakala.

Indlela yoku-1: hlukanisa inombolo ngenombolo

Ishidi le-Excel lingasetshenziswa njengesihlobo sokubala, ngokumane sehlukanise inombolo ngenombolo. Islash imele uphawu lokwahlukanisa (emuva emuva) - "/".

1. Singena kunoma yisiphi iseli lamahhala eshidi noma emugqeni wamafomula. Sibeka isibonakaliso okulinganayo (=). Sithayipha kwikhibhodi inombolo ebonakalayo. Sibeka uphawu lokuhlukanisa (/). Sithayipha isisehlukanisi kusuka kwikhibhodi. Kwezinye izimo, kunezihlukanisi ezingaphezu kwesisodwa. Bese kuthi, ngaphambi kwesihlukaniso ngasinye sibeka ukubambeka (/).



2. Ukuze wenze sibalo futhi ubonise imiphumela yaso kuqapha, chofoza inkinobho Ngena.

Ngemuva kwalokho, i-Excel izobala ifomula futhi kuseli elibekiwe kuzobonisa umphumela wokubala.

Uma ukubalwa kwenziwa ngezinhlamvu eziningana, khona-ke ukulandelana kokubulawa kwabo kwenziwa ngohlelo ngokwemithetho yezibalo. Okusho ukuthi, okokuqala, ukuhlukaniswa nokuphindaphindwa kwenziwa, futhi kulapho kuphela - ukwengeza nokukhipha.

Njengoba wazi, ukwahlukanisa ngu-0 isenzo esingalungile. Ngakho-ke, ngomzamo onjalo wokubalwa okufanayo ku-Excel, umphumela uzovela esitokisini "#DEL / 0!".

Isifundo: Ukusebenza namafomula ku-Excel

Indlela 2: ukwahlukanisa okuqukethwe ngamaseli

Futhi ku-Excel, ungahlukanisa idatha kumaseli.

1. Sikhetha esitokisini lapho umphumela wokubala uzokhonjiswa khona. Sibeka uphawu kuyo "=". Okulandelayo, chofoza endaweni lapho ukwahlukanisa kutholakala khona. Ngemuva kwalokho ikheli lakhe liyavela emgqeni wezindlela ngemuva kwesibonakaliso okulinganayo. Okulandelayo, setha isibonakaliso esivela kwikhibhodi "/". Chofoza kuseli lapho isehlukanisi sitholakala khona. Uma ngabe kukhona abahlukanisi abaningana, njengasekuqaleni kwendlela, sibakhombisa bonke, bese sibeka uphawu lokuhlukanisa phambi kwamakheli abo.



2. Ukuze wenze isenzo (ukwahlukanisa), chofoza inkinobho "Ngena".

Ungahlanganisa futhi, njengesihlukanisi noma isahlukanisi, usebenzisa womabili amakheli weselula nezinombolo ze-tuli.

Indlela 3: ukwahlukanisa ikholomu ngokholamu

Ukubalwa kumatafula, ngokuvamile kuyadingeka ukwehlukanisa amanani ekholamu eyodwa kwidatha yekholamu yesibili. Vele, ungahlukanisa inani leseli ngalinye ngendlela echazwe ngenhla, kepha ungayenza le nqubo ngokushesha okukhulu.

1. Khetha iseli lokuqala kukholamu lapho umphumela kufanele uboniswe khona. Sibeka isibonakaliso "=". Chofoza kuseli yokwabelana. Sithayipha isibonakaliso "/". Chofoza kusihlukanisi seseli.



2. Chofoza inkinobho Ngenaukubala umphumela.



3. Ngakho-ke, umphumela ubaliwe, kepha umugqa owodwa kuphela. Ukuze wenze ukubalwa kweminye imigqa, udinga ukwenza izinyathelo ezingenhla zazo ngazinye. Kepha ungasindisa kakhulu isikhathi sakho ngokwenza into eyodwa. Setha isikhombisi ekhoneni elingezansi kweseli ngefomula. Njengoba ukwazi ukubona, isithonjana sivele ngendlela yesiphambano. Ibizwa ngokuthi umaka wokugcwalisa. Bamba phansi inkinobho yegundane kwesobunxele bese uhudula umaki wokugcwalisa uze ufike ekugcineni kwetafula.

Njengoba ukwazi ukubona, ngemuva kwalesi senzo, inqubo yokuhlukanisa ikholamu eyodwa kwisekhondi izokwenziwa ngokuphelele, futhi umphumela uzokhonjiswa kukholamu ehlukile. Iqiniso ngukuthi usebenzisa umaki wokugcwalisa, ifomula ikopishelwa kumaseli aphansi. Kepha, kucatshangelwa iqiniso lokuthi ngokuzenzakalelayo zonke izixhumanisi zihlobene, futhi azikho ngokuphelele, khona-ke kwifomula njengoba usuka phansi, amakheli amaseli aguqula okuhlobene nezixhumanisi zokuqala. Futhi yilokhu kanye esikudingayo ecaleni elithile.

Isifundo: Ungayenza kanjani ngokuzenzakalela i-Excel

Indlela 4: ukwahlukanisa ikholamu ngokuhlala njalo

Kunezikhathi lapho udinga ukwehlukanisa ikholomu ngenombolo efanayo engaguquki - okuhlala njalo, futhi ubonise inani lokuhlukanisa kukholamu ehlukile.

1. Sibeka isibonakaliso okulinganayo esitokisini sokuqala sekholamu yokufingqa. Chofoza kuseli elibonakalayo lalolayini. Sibeka uphawu lokuhlukanisa. Bese ngesandla kusuka kukhibhodi sibeka phansi inombolo oyifunayo.



2. Chofoza inkinobho Ngena. Umphumela wokubala womugqa wokuqala uboniswa kuqapha.



3. Ukuze ubale amanani weminye imigqa, njengasesikhathini esedlule, sibiza umaki wokugcwalisa. Ngendlela efanayo esilula ngayo.

Njengoba ukwazi ukubona, kulokhu ukwahlukaniswa futhi kwenziwa kahle. Kulokhu, lapho ukopisha idatha ngomaka wokugcwalisa, izixhumanisi ziphinde zahlala zihlobene. Ikheli lokwehlukaniswa kwemali kolayini ngalunye lishintshwe ngokuzenzakalelayo. Kepha i-divisor ekulesi simo inombolo engaguquki, okusho ukuthi impahla yokuhlobana ayisebenzi kuyo. Ngakho-ke, sahlukanisa okuqukethwe ngamaseli wekholomu kwaba okuphindaphindiwe.

Indlela yesi-5: Ukwehlukanisa ikholamu ngeselula

Kepha ukuthi wenzeni uma udinga ukwahlukanisa ikholomu kokuqukethwe kuseli elilodwa. Ngempela, ngokuya ngomgomo wokuhlobana kwezixhumanisi, izixhumanisi zesabelo nehlukanisi zizoguqulwa. Sidinga ukwenza ikheli leseli lapho isehlukanisi silungisiwe.

1. Setha ikhesa kuseli eliphezulu kakhulu kukholamu ukubonisa umphumela. Sibeka isibonakaliso "=". Sichofoza ekubekweni kwesabelo, lapho kutholakala khona inani eliguquguqukayo. Sibeka ukubambeka (/). Chofoza kuseli lapho kuhlala khona umuntu ohlukanisa njalo.



2. Ukuze wenze ireferensi ekuhlukaniseni ngokuphelele, okungukuthi, njalo, beka uphawu lwedola ($) kwifomula ephambi kokuxhumanisa kweseli ngokuqondile nangokuma ngokuqondile. Manje leli kheli lizohlala lingashintshiwe lapho umaki wokugcwalisa ekopishwa.



3. Chofoza inkinobho Ngenaukubonisa imiphumela yokubala yomugqa wokuqala esibukweni.



4. Usebenzisa umaki wokugcwalisa, kopisha ifomula kumaseli asele ekholamu ngemiphumela ejwayelekile.

Ngemuva kwalokho, umphumela wayo yonke ikholamu usulungile. Njengoba ubona, kuleli cala, ikholomu ihlukaniswe yaba yiseli elinekheli elinqunyelwe.

Isifundo: Izixhumanisi ezingaphelele nezihlobene ku-Excel

Indlela yesi-6: Umsebenzi wokuvikela

Ukuhlukaniswa kwe-Excel nakho kungenziwa ngokusebenzisa umsebenzi okhethekile obizwa KHAWULA. Ubumfihlo balomsebenzi ukuthi lihlanganyela, kepha ngaphandle kwensalela. Okusho ukuthi, uma usebenzisa le ndlela yokuhlukanisa, umphumela uyohlala waba yisamba. Ngasikhathi sinye, ukusondeza kwenziwa hhayi ngokuya ngemithetho yezibalo eyemukelwa kumuntu osondele kakhudlwana, kepha kumodulus encane. Okusho ukuthi, inani le-5.8 umsebenzi ngeke lisondele ku-6, kodwa liye ku-5.

Ake sibheke ukusetshenziswa kwalomsebenzi ngesibonelo.

1. Chofoza kuseli lapho kuzobukiswa khona umphumela wokubala. Chofoza inkinobho "Faka umsebenzi" ngakwesokunxele sebha yefomula.



2. Iyavula Isici Wizard. Kuluhlu lwemisebenzi asinikeza yona, sifuna into ethile CHASTNOE. Khetha bese uchofoza inkinobho. "Kulungile".



3. Iwindi lokuphikisana ngomsebenzi liyavula KHAWULA. Lo msebenzi unezimpikiswano ezimbili: inombolo Angeniswe emasimini enamagama ahambelana nawo. Ensimini Inombolo yethula isehlukaniso. Ensimini Isikhombi - Isahlukanisi. Ungafaka izinombolo ezithile namakheli amaseli lapho idatha itholakala khona. Ngemuva kokuthi wonke amanani afakiwe, chofoza inkinobho "Kulungile".

Ngemuva kwalezi zinyathelo, umsebenzi KHAWULA yenza ukucubungula idatha futhi ikhiphe impendulo esitokisini esichazwe esinyathelweni sokuqala sale ndlela yokuhlukanisa.

Ungafaka futhi lo msebenzi ngesandla ngaphandle kokusebenzisa iWizard. I-syntax yayo imi ngolu hlobo:

= PRIVATE (inombolo

Isifundo: Umsebenzi Wizard e-Excel

Njengoba ukwazi ukubona, indlela esemqoka yokuhlukanisa ohlelweni lweMicrosoft Office ukusetshenziswa kwamafomula. Umfuziselo wokwehlukana phakathi kwabo ukwenaba - "/". Ngasikhathi sinye, ngezinhloso ezithile, ungasebenzisa umsebenzi inqubo yokuhlukanisa. KHAWULA. Kepha, udinga ukubheka ukuthi uma kubalwa ngale ndlela umehluko utholakala ngaphandle kwensalela, inani eliphelele. Ngasikhathi sinye, ukusondeza kwenziwa hhayi ngokuya ngemigomo evunyelwe ngokuvamile, kodwa kunamba encane kunani eliphelele.