Lapho usebenzisa amafomula ku-Excel, uma amaseli abhekiswe ku-opharetha engenalutho, ama-zeros azovela endaweni yokubala ngokuzenzakalelayo. Ngokuhle, lokhu akubukeki kukuhle kakhulu, ikakhulukazi uma ithebula linamabanga amaningi afanayo anamanani zero. Futhi kuba nzima kakhulu ngomsebenzisi ukuthola imininingwane yedatha ngokuqhathaniswa nesimo uma lezo zindawo zingenalutho ngokuphelele. Ake sibheke ukuthi yiziphi izindlela ongasusa ngazo ukubonisa kwedatha e-null ku-Excel.
I-Zero Removal Algorithms
I-Excel inikeza amandla okususa ama-zeros kumaseli ngezindlela eziningana. Lokhu kungenziwa ngokusebenzisa imisebenzi ekhethekile nokufomatha ukusebenzisa. Kungenzeka futhi ukukhubaza ukuboniswa kwemininingwane enjengaleyo ephepheni.
Indlela yoku-1: Izilungiselelo ze-Excel
Emhlabeni jikelele, le nkinga ingaxazululwa ngokushintsha izilungiselelo ze-Excel zeshidi lamanje. Lokhu kukuvumela ukuthi wenze wonke amaseli aqukethe ama-zeros angenalutho.
- Ukuba kuthebhu Ifayelaiya esigabeni "Izinketho".
- Ewindini eliqala, dlulela esigabeni "Kuthuthukile". Engxenyeni engakwesokudla yewindows sifuna ibhulokhi yezilungiselelo "Khombisa izinketho zeshidi elilandelayo". Ungahloli ibhokisi eliseduze "Khombisa ama-zeros kumaseli aqukethe amanani ayize". Ukuze uguqule ukusebenza kwezilungiselelo ungakhohlwa uchofoze inkinobho "Kulungile" phansi kwewindi.
Ngemuva kwalezi zenzo, wonke amaseli eshidi lamanje aqukethe amanani we-zero azoboniswa njeng angenalutho.
Indlela 2: faka ukufometha
Ungafihla amanani amaseli angenalutho ngokushintsha ifomethi yawo.
- Khetha ibanga ofuna ukufihla ngalo amaseli ngamanani zero. Sichofoza kucezu olukhethiwe ngenkinobho yegundane elifanele. Kumenyu yokuqukethwe, khetha "Ifomethi yeseli ...".
- Iwindi lokufometha liqalisiwe. Hambisa kuthebhu "Inombolo". Ukushintsha ifomethi yenombolo kumele kusethelwe kuyo "Zonke izinhlobo". Engxenyeni engakwesokudla yewindi enkundleni "Thayipha" faka le nkulumo elandelayo:
0;-0;;@Ukuze ulondoloze izinguquko zakho, chofoza inkinobho "Kulungile".
Manje zonke izindawo ezinamanani we-null azobe engenalutho.
Isifundo: Ifometha amatafula ku-Excel
Indlela 3: ukufometha okunemibandela
Ungasebenzisa futhi ithuluzi elinamandla njengokufometha okunemibandela ukususa ama-zeros angeziwe.
- Khetha ibanga lapho amanani we-zero angaba khona. Ukuba kuthebhu "Ikhaya"chofoza inkinobho kubambo Ukufomatha okunemibandelaetholakala kubhlokhi lezilungiselelo Izitayela. Kumenyu evulayo, dlula ezintweni Imithetho Yokukhetha Iseli futhi "Okufanayo".
- Iwindi lokufometha liyavula. Ensimini "Amaseli efomethi ayi-EQUAL" faka inani "0". Ensimini efanele ohlwini lokudonsa phansi, chofoza entweni "Ifomethi yangokwezifiso ...".
- Kuvulwa elinye iwindi. Iya kuthebhu ekuyo Ifonti. Chofoza ohlwini olwehliswayo "Umbala"lapho sikhetha khona umbala omhlophe bese uqhafaza inkinobho "Kulungile".
- Ukubuyela ewindini lokufomatha langaphambilini, chofoza inkinobho "Kulungile".
Manje, inqobo nje uma inani leseli lingu-zero, khona-ke ngeke libonakale kumsebenzisi, ngoba umbala wefonti yakhe uzohlangana nombala wangemuva.
Isifundo: Ukufomatha okunemibandela ku-Excel
Indlela 4: ukusebenzisa umsebenzi we-IF
Enye indlela yokufihla ama-zeros kubandakanya ukusebenzisa opharetha UMA.
- Sikhetha iseli lokuqala kusuka ebangeni lapho imiphumela yokubala iboniswa khona, futhi lapho izeros zingakhona khona. Chofoza isithonjana "Faka umsebenzi".
- Kuqala Isici Wizard. Siseshela uhla lwemisebenzi ethunyelwe UMA. Ngemuva kokuthi ikhethiwe, chofoza inkinobho "Kulungile".
- Iwindi lokuphikisana okusebenzayo liyasebenza. Ensimini Isisho esinengqondo faka ifomula ebala esitokisini esiqondiwe. Kungumphumela wokubala le formula engagcina inikeze zero. Ngecala ngalinye elithile, le nkulumo izokwehluka. Masinyane ngemuva kwaleli formula, enkombeni efanayo, engeza isisho "=0" ngaphandle kwezingcaphuno. Ensimini "Okusho ukuthi uma kuyiqiniso" beka isikhala - " ". Ensimini "Okusho uma kungamanga" siphinda ifomula futhi, kepha ngaphandle kokuveza "=0". Ngemuva kokuthi idatha ifakiwe, chofoza inkinobho "Kulungile".
- Kepha lesi simo kuze kube manje sisebenza kuseli elilodwa kuphela ebangeni. Ukukopisha ifomula kwezinye izinto, beka ikhesa ekhoneni elingezansi kweseli. Umaka wokugcwalisa ngendlela yesiphambano uyasebenza. Bamba phansi inkinobho yegundane kwesobunxele bese uhudula isikhombisi kulo lonke uhla okufanele luguqulwe.
- Ngemuva kwalokho, kulawo maseli lapho umphumela wokubala uzoba ngu-zero, esikhundleni senombolo "0" kuzoba nesikhala.
By indlela, uma kuwukuphikisana iwindi enkundleni "Okusho ukuthi uma kuyiqiniso" setha ideshi, lapho-ke lapho kukhipha umphumela kumaseli ngenani le-zero ngeke kube khona isikhala, kepha udeshi.
Isifundo: Umsebenzi we- 'IF' ku-Excel
Indlela yesi-5: sebenzisa umsebenzi ongu-NUMBER
Indlela elandelayo luhlobo lokuhlanganiswa kwemisebenzi. UMA futhi NUMBER.
- Njengasesibonelweni esedlule, vula iwindi lokuphikisana komsebenzi IFA esitokisini sokuqala sebanga elisetshenzisiwe. Ensimini Isisho esinengqondo bhala umsebenzi NUMBER. Lo msebenzi ukhombisa ukuthi into ethile igcwaliswa ngemininingwane noma cha. Ngemuva kwalokho ensimini efanayo sivula amabakaki bese singena ikheli leselula, okuthi, uma lingenalutho, lenze ukuthi ingqangi yeseli ibe ngu-zero. Sivalela amabakaki. Lokho, empeleni, ku-opharetha NUMBER izobheka ukuthi ikhona yini imininingwane etholakala endaweni echaziwe. Uma kunjalo, khona-ke umsebenzi uzobuyisa inani "IQINISO"uma kungenjalo, - FALSE.
Futhi nawa amanani ezimpikiswano ezimbili ezilandelayo zomsebenzi UMA sihlela kabusha. Okusho ukuthi, enkundleni "Okusho ukuthi uma kuyiqiniso" khombisa ifomula yokubala, nasensimini "Okusho uma kungamanga" beka isikhala - " ".
Ngemuva kokuthi idatha ifakiwe, chofoza inkinobho "Kulungile".
- Njengasekuqaleni kwendlela, kopisha ifomula kulo lonke uhla usebenzisa uphawu lokugcwalisa. Ngemuva kwalokho, amanani we-zero azonyamalala endaweni echaziwe.
Isifundo: Umsebenzi Wizard e-Excel
Kunezindlela eziningi zokususa idijithi "0" esitokisini uma inenani le-zero. Indlela elula ukukhubaza ukubonisa ama-zeros kuzilungiselelo ze-Excel. Kepha-ke kufanele kukhunjulwe ukuthi ziyonyamalala kulo lonke ishidi. Uma udinga ukusebenzisa ukuvala kuphela endaweni ethile, khona-ke kulokhu kufometha amabanga, ukufomatha okunemibandela nokusetshenziswa kwemisebenzi kuzokusiza. Yikuphi kulezi zindlela ongazikhetha kuzo ngokuya ngesimo esithile, nakumakhono omuntu siqu nokukhethwayo.
