Mukamagwiritsa ntchito mawonekedwe mu Excel, ngati maselo otchulidwa ndi opereshawo alibe, zeros zimawonekera m malo owerengera pokhapokha. Zokongola, izi sizimawoneka zokongola kwambiri, makamaka ngati tebulo ili ndi magulu ofanana ndi zero. Ndipo ndizovuta kwambiri kuti wogwiritsa ntchito azitha kudziwa zomwe akuyerekeza ndi momwe zinthuzo zingakhalire zopanda anthu. Tiyeni tiwone momwe mungachotsere kuwonetsa kwa data ya Excel.
Zero Kuchotsa Algorithms
Excel imapereka mphamvu yochotsa ma zelo mu maselo m'njira zingapo. Izi zitha kuchitika pogwiritsa ntchito ntchito zapadera ndikugwiritsa ntchito mitundu. Ndikothekanso kuletsa kuwonetsedwa kwa deta yonseyo papepala.
Njira 1: Zikhazikiko za Excel
Padziko lonse lapansi, nkhaniyi ingathetsedwe ndikusintha mawonekedwe a Excel pa pepala lapano. Izi zimakuthandizani kuti mupange maselo onse opanda ziphuphu opanda kanthu.
- Kukhala mu tabu Fayilopitani pagawo "Zosankha".
- Pa zenera lomwe likuyamba, sinthani ku gawo "Zotsogola". Gawo lamanja la zenera tikuyang'ana bar block "Onetsani zosankha za pepala lotsatira". Tsegulani bokosi pafupi "Onetsani zeros zomwe zili ndi ma cell opanda". Kubweretsa kusintha kwa masanjidwewo musaiwale kudina batani "Zabwino" pansi pazenera.
Pambuyo pa izi, maselo onse a pepala lomwe lili ndi zero zero amawonetsedwa ngati kanthu.
Njira 2: kutsatira mawonekedwe
Mutha kubisa zama cell opanda kanthu posintha mawonekedwe awo.
- Sankhani mtundu womwe mukufuna kubisa maselo okhala ndi zero. Timadina pachidutswa chosankhidwa ndi batani loyenera la mbewa. Pazosankha zofanizira, sankhani "Mtundu wamtundu ...".
- Tsamba losintha limayambitsidwa. Pitani ku tabu "Chiwerengero". Kusintha kwa mtundu wa manambala kuyenera kukhazikitsidwa "Makonda onse". Gawo lamanja la zenera m'mundawo "Mtundu" lembani mawu otsatirawa:
0;-0;;@Kuti musunge zosintha zanu, dinani batani "Zabwino".
Tsopano magawo onse omwe ali ndi mfundo zachabechabe adzakhala opanda ntchito.
Phunziro: Kukhazikitsa matebulo ku Excel
Njira 3: kusinthasintha
Mutha kugwiritsanso ntchito chida champhamvu choterechi poyerekeza ndi momwe mungachotsere ziro zowonjezera.
- Sankhani mtundu womwe zingakhale ndi mfundo z zero. Kukhala mu tabu "Pofikira"dinani pa batani pa riboni Njira Zakukonzeranilomwe lili muzosungirako Masitaelo. Pazosankha zomwe zimatseguka, pitani pazinthuzo Malamulo Osankha Maselo ndi "Zofanana".
- Tsamba losintha likutsegulidwa. M'munda "Maselo amtundu omwe ali ndi EQUAL" lowetsani mtengo wake "0". M'munda woyenera mumndandanda wotsika, dinani chinthucho "Makonda mawonekedwe ...".
- Windo linanso limatseguka. Pitani ku tabu mmenemo Font. Dinani pamndandanda wotsitsa "Mtundu"momwe timasankhira mitundu yoyera ndikudina batani "Zabwino".
- Kubwereranso ku zenera lolowera kale, dinani batani "Zabwino".
Tsopano, pokhapokha ngati mtengo mu cell ndi zero, ndiye kuti sungawonekere wosuta, popeza mtundu wa mawonekedwe ake umakaphatikizidwa ndi mtundu wakumbuyo.
Phunziro: Zowongolera mu Excel
Njira 4: kutsatira ntchito ya IF
Njira ina yobisalira zeros imaphatikizapo kugwiritsa ntchito wothandizira NGATI.
- Timasankha khungu loyamba kuchokera pazomwe zimawerengera zotsatira, ndi pomwe zigawo zidzakhalapo. Dinani pachizindikiro "Ikani ntchito".
- Iyamba Fotokozerani Wizard. Timafufuza mndandanda wa ntchito zoyendetsedwa nazo NGATI. Akasankhidwa, dinani batani "Zabwino".
- Windo la wotsutsana likuyambitsidwa. M'munda Mawu omveka lowetsani formula yomwe imawerengera chandamale chandamale. Ndizotsatira kuwerengera formula iyi yomwe pamapeto pake imapereka zero. Pa vuto lililonse, mawuwa angakhale osiyana. Atangochita izi, m'munda womwewo, onjezerani mawuwo "=0" opanda mawu. M'munda "Tanthauza ngati zili zoona" ikani danga - " ". M'munda "Tikutanthauza ngati zabodza" sibwerezanso formula, koma osafotokozera "=0". Pambuyo poti pulogalamuyo yaikidwa, dinani batani "Zabwino".
- Koma izi mpaka pano zikugwira ntchito pa selo limodzi m'mlingo. Kuti mumvere fomulo pazinthu zina, ikani cholozera m'makona akumunsi a cell. Chizindikiro chodzaza pamtanda chimayatsidwa. Gwirani pansi batani la mbewa yakumanzere ndikokani cholozera pazonse zomwe zikuyenera kutembenuzidwa.
- Pambuyo pake, m'maselo amenewo momwe zotsatira za kuwerengera zidzakhalire zero, mmalo mwa chiwerengero "0" padzakhala malo.
Mwa njira, ngati pazokangana pamunda "Tanthauza ngati zili zoona" khazikitsani phokoso, ndiye kuti mukatulutsa zotsatira mu maselo okhala ndi zero, sipangakhale malo, koma phokoso.
Phunziro: Ntchito ya 'IF' ku Excel
Njira 5: gwiritsani ntchito ntchito NUMBER
Njira yotsatirayi ndi mtundu wophatikiza ntchito. NGATI ndi NUMBER.
- Monga mu chitsanzo chapitacho, tsegulani zenera la zotsutsana ndi IF mu khungu loyamba la mitundu yomwe yakonzedwa. M'munda Mawu omveka kulemba ntchito NUMBER. Ntchitoyi ikuwonetsa ngati chinthu chimadzazidwa ndi data kapena ayi. Kenako m'munda womwewo timatsegula mabulangete ndikulowetsa adilesi ya cell, yomwe, ngati yopanda kanthu, ingapangitse chandamale cha zero. Timatseka mabatani. Ndiye kuti, wogwiritsa ntchito NUMBER Iwona ngati pali chilichonse chomwe chatchulidwa m'ndimeyo. Ngati alipo, ndiye kuti ntchitoyi ibweza mtengo "ZOONA"Ngati sichoncho, ndiye - FALSE.
Nayi mfundo zam mfundo ziwiri zotsatirazi za wothandizira NGATI timakonzanso. Ndiye kuti m'munda "Tanthauza ngati zili zoona" onetsani njira yowerengera, komanso m'munda "Tikutanthauza ngati zabodza" ikani danga - " ".
Pambuyo poti pulogalamuyo yaikidwa, dinani batani "Zabwino".
- Monga momwe munasinthira kale, koperani formula ina yonse yogwiritsira ntchito chikhomo. Zitatha izi, zofunikira za zero zimasowa m'deralo.
Phunziro: Ntchito Wizard ku Excel
Pali njira zingapo zochotsera manambala "0" mu cell ngati ili ndi zero. Njira yosavuta ndiyo kuletsa kuwonetsedwa kwa zeros mu zoikamo za Excel. Komano ziyenera kukumbukiridwa kuti azisowa mu pepala lonse. Ngati mukufunikira kuyika kuzimitsa padera pamalo ena, pamalopo kuphatikiza kwa masanjidwe, makonzedwe azikhalidwe ndi kugwiritsa ntchito kwa ntchito kudzakuthandizani. Ndi iti mwa njira zomwe mungasankhire zimadalira momwe zinthu zilili, komanso luso la wogwiritsa ntchito komanso zomwe amakonda.
