Uma usebenzisa amafomula ku-Excel, uma amaseli abhekiswa opharetha asinalutho, kuzoba khona ama-zero endaweni yokubala ngokuzenzakalelayo. Ngokweqile, lokhu akubukeka kuhle kakhulu, ikakhulu uma kunezinhlobo eziningi ezifanayo nezindinganiso zero etafuleni. Yebo, futhi umsebenzisi kunzima kakhulu ukuhamba ngedatha uma kuqhathaniswa nesimo, uma izindawo ezinjalo zingenalutho. Ake sithole ukuthi ungasusa kanjani isibonakaliso sedatha engafanele ku-Excel.
I-Zero Ukususwa kwe-Algorithms
I-Excel inikeza ikhono lokususa ama-zero kumaseli ngezindlela eziningana. Lokhu kungenziwa ngokusebenzisa imisebenzi ekhethekile noma ngokusebenzisa ukufometha. Kungenzeka futhi ukukhubaza ukubonisa kwedatha enjalo kushidi lonke.
Indlela 1: Izilungiselelo ze-Excel
Emhlabeni wonke, le nkinga ingaxazululwa ngokushintsha izilungiselelo ze-Excel zephepha langamanje. Lokhu kukuvumela ukuthi wenze ngokuphelele wonke amaseli aqukethe ama-zero angenalutho.
- Ukuba ngaphakathi kuthebhu "Ifayela", iya esigabeni "Izinketho".
- Esikhathini sewindi lokuqalisa, sithuthela esigabeni. "Okuthuthukisiwe". Ngakwesokudla kwefasitela sibheka ibhokisi lezilungiselelo "Bonisa okukhethwa kukho kwekhasi elilandelayo". Ungawukhiphe ibhokisi eceleni kwento. "Bonisa ama-zero kumaseli aqukethe ama-zero amanani". Ukuletha izinguquko kuzilungiselelo ungakhohlwa ukuchofoza inkinobho. "Kulungile" phansi kwefasitela.
Ngemva kwalezi zenzo, wonke amaseli wekhasi lamanje eliqukethe amanani we-zero azoboniswa engenalutho.
Indlela 2: Sebenzisa ukufometha
Ungafihla amanani wamaseli angenalutho ngokushintsha ifomethi yawo.
- Khetha ibanga ofuna ukufihla amangqamuzana anamazinga e-zero. Chofoza kusiqephu esikhethiwe nge inkinobho yegundane kwesokudla. Kumenyu yesimo, khetha into "Fometha amaseli ...".
- Iwindi yokufometha iqaliswa. Hambisa kuthebhu "Inombolo". Umshini wokushintsha ifomethi kufanele usethelwe "Zonke amafomethi". Ngakwesokudla kwefasitela ensimini "Thayipha" Faka inkulumo elandelayo:
0;-0;;@Ukuze ulondoloze izinguquko fakiwe chofoza inkinobho "Kulungile".
Manje zonke izindawo eziqukethe ama-value amanani azobe zingenalutho.
Isifundo: Ukufometha kwethebula kwe-Excel
Indlela 3: Ukufometha okunemibandela
Ungasebenzisa futhi ithuluzi elinamandla njengendlela yokufometha okunemibandela ukuze ususe ama-zero engeziwe.
- Khetha ibanga lapho izindinganiso zero zingatholakala khona. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho ku-ribbon "Ukufometha okunemibandela"esitholakala ekuvimbeleni amasethingi "Izitayela". Emenyu evulekayo, hamba ngalezi zinto "Imithetho yokukhethwa kweseli" futhi "Kulingana".
- Iwindi yokufometha ivula. Ensimini "Fometha amaseli a-EQUAL" faka inani "0". Endaweni efanele ohlwini lokuhlaziya chofoza into "Ifomethi yangokwezifiso ...".
- Enye iwindi ivula. Yiya kuso kuthebhu "Ifonti". Chofoza kuhlu lokudonsa phansi. "Umbala"lapho sikhetha khona umbala omhlophe, bese uchofoza inkinobho "Kulungile".
- Ukubuyela efasiteleni lokufometha langaphambilini, chofoza inkinobho. "Kulungile".
Manje, uma ngabe inani eliselifini liyizinga, ngeke libonakale kumsebenzisi, ngoba umbala wefonti yakhe izohlangana nombala wangemuva.
Isifundo: Ukufometha okunemibandela ku-Excel
Indlela 4: Sebenzisa umsebenzi we-IF
Enye indlela yokufihla i-zeros ihilela ukusebenzisa opharetha IF.
- Khetha iseli lokuqala kusukela ebangeni lapho imiphumela yezibalo zikhishwa khona, futhi uma kunokwenzeka kuyoba khona ama-zeros. Chofoza kusithonjana "Faka umsebenzi".
- Iqala Umsebenzi weWebhu. Yenza usesho ohlwini lwemisebenzi ye-opharetha "UMA". Ngemva kokugqanyiswa, chofoza inkinobho. "Kulungile".
- Iwindi lempikiswano ye-Operator ivuliwe. Ensimini "Inkulumo ye-boolean" faka ifomula elibala esitokisini esilitshe. Kungumphumela wokubala kwaleli fomula ekugcineni kunganikeza zero. Esimweni ngasinye, le nkulumo izohluka. Masinyane emva kwalolu fomula ensimini efanayo sengeza le nkulumo "=0" ngaphandle izingcaphuno. Ensimini "Vumela uma kuyiqiniso" faka isikhala - " ". Ensimini "Vumela uma kungamanga" siphindaphinda le fomula futhi, kodwa ngaphandle kwenkulumo "=0". Ngemuva kwedatha efakiwe, chofoza inkinobho "Kulungile".
- Kodwa lesi simo okwamanje sisebenza kuphela kuseli elilodwa ebangeni. Ukuze ukopishe ifomula kwezinye izakhi, faka isikhombisi ekhoneni elingaphansi kwesokudla leseli. Ukusebenza komaka wokugcwalisa ngesimo sesiphambano kwenzeka. Bamba inkinobho yesinxele yesinxele bese uhudula isikhombisi phezu kobubanzi obufanele ukuguqulwa.
- Ngemuva kwalokho, kulawo maseli lapho ngenxa yokubala kuyoba khona izindinganiso zero, esikhundleni sedijithi "0" kuyoba khona isikhala.
Ngendlela, uma ebhokisini lama-arguments ensimini "Vumela uma kuyiqiniso" Uma usetha ideshi, ke uma ubonisa umphumela kumaseli anenani le-zero kuyoba nedashi kunesikhala.
Isifundo: Umsebenzi we-Excel ku-Excel
Indlela 5: sebenzisa umsebenzi i-ECHRISE
Indlela elandelayo iyinhlanganisela ekhethekile yemisebenzi. IF futhi Kuyinto.
- Njengokwesibonelo esedlule, vula iwindi lezimangalo zomsebenzi we-IF esitokisini sokuqala kobubanzi obucutshungulwayo. Ensimini "Inkulumo ye-boolean" bhala umsebenzi Kuyinto. Lo msebenzi ubonisa ukuthi ngabe into igcwele idatha noma cha. Bese uvule amabakaki ensimini efanayo bese ufaka ikheli leseli, okungukuthi, uma lingenalutho, lingenza i-target target cell zero. Vala amabakaki. Yilokho, empeleni, opharetha Kuyinto uzohlola uma kukhona idatha endaweni ecacisiwe. Uma kunjalo, umsebenzi uzobuyisela inani "TRUE", uma kungenjalo, "FALSE".
Kodwa izindinganiso zezizathu ezimbili ezilandelayo ze-opharetha IF sishintsha izindawo. Okusho ukuthi, ensimini "Vumela uma kuyiqiniso" ucacise ifomula yokubala, nasensimini "Vumela uma kungamanga" faka isikhala - " ".
Ngemuva kwedatha efakiwe, chofoza inkinobho "Kulungile".
- Njengoba nje ngendlela eyedlule, kopisha ifomula kulo lonke uhla usebenzisa uphawu lokugcwalisa. Emva kwalokhu, izindinganiso zero zizophela kwendawo ecacisiwe.
Isifundo: I-Excel Function Wizard
Kunezindlela eziningi zokususa idijithi "0" esitokisini uma inenani lezinga. Indlela elula ukukhubaza ukuboniswa kwama-zero kuzilungiselelo ze-Excel. Kodwa kufanele kuphawulwe ukuthi zizophela emhlabeni wonke. Uma kudingekile ukuthi usebenzise ukuvala ukuphela kuphela endaweni ethile, ngakho-ke kulesi simo ukufometha, ukufometha okunemibandela nokusebenza kwemisebenzi kuzokusiza. Iyiphi yalezi zindlela ongakhetha kuzo ixhomeke esimweni esithile, kanye namakhono omuntu womuntu kanye nezintandokazi zakhe.
