Momwe mungasinthire VKontakte mumzinda

Pogwiritsira ntchito mayina mu Excel, ngati maselo omwe amatsindiridwa ndi woyendetsa alibe kanthu, padzakhala zero mu malo owerengera osasintha. Zokongola, izi sizikuwoneka bwino, makamaka ngati pali maulendo ambiri ofanana ndi zero zomwe zili patebulo. Inde, ndipo wogwiritsa ntchitoyo ndi kovuta kuti ayendetse deta poyerekeza ndi mkhalidwe, ngati malo otero angakhale opanda kanthu. Tiyeni tione momwe mungatulutsire mawonedwe osasintha mu Excel.

Zero kuchotsa machitidwe

Excel imapereka mphamvu zothetsera zero mu maselo m'njira zingapo. Izi zingatheke mwa kugwiritsa ntchito ntchito yapadera kapena kugwiritsa ntchito maonekedwe. N'zotheka kutsegula mawonedwe a deta yotere mu pepala lonse.

Njira 1: Zosintha za Excel

Padziko lonse, nkhaniyi ingathetsekedwe mwa kusintha kusintha kwa Excel kwa pepala lokha. Izi zimakuthandizani kupanga maselo onse okhala ndi zero opanda kanthu.

  1. Kukhala mu tab "Foni", pitani ku gawoli "Zosankha".
  2. Muwindo la kuyambira, timasunthira ku gawoli. "Zapamwamba". Kumanja kwawindo pawindo tikuyang'ana malo ozungulira "Onetsani zosankha za pepala lotsatira". Sakanizani bokosi pafupi ndi chinthucho. "Onetsani zero mu maselo omwe ali ndi zero zamtengo wapatali". Kuti mubweretse kusintha kosintha musaiwale kutsegula batani. "Chabwino" pansi pazenera.

Pambuyo pazigawozi, maselo onse a pepala lomwe lilipo omwe ali ndi zero zamtengo wapatali adzawonetsedwa opanda kanthu.

Njira 2: Gwiritsani ntchito Kujambula

Mukhoza kubisala miyezo ya maselo opanda kanthu mwa kusintha maonekedwe awo.

  1. Sankhani mtundu umene mukufuna kubisala maselo ndi zero zoyenera. Dinani pa chidutswa chosankhidwa ndi batani lamanja la mouse. Mu menyu yachidule, sankhani chinthucho "Sungani maselo ...".
  2. Zowonetsera zojambulazo zimayambika. Pitani ku tabu "Nambala". Kusinthana kwa chiwerengero cha chiwerengero chiyenera kukhazikitsidwa "Zopanga Zonse". Kumanja kwawindo pazenera Lembani " Lowani mawu otsatirawa:

    0;-0;;@

    Kusunga kusintha kunalowa pakhomopo "Chabwino".

Tsopano malo onse omwe ali ndi zero zamtengo adzakhala opanda.

Phunziro: Kupanga tebulo la Excel

Njira 3: Kujambula Momwemo

Mukhozanso kugwiritsa ntchito chida champhamvu ngati maonekedwe ovomerezeka kuti muchotse zeros zowonjezera.

  1. Sankhani zamtundu umene zitu zikhoza kukhala. Kukhala mu tab "Kunyumba", dinani pa batani pa riboni "Mafomu Okhazikika"yomwe ili pamakonzedwe "Masitala". Mu menyu yomwe imatseguka, pendani muzinthu "Malamulo a kusankha kusankhidwa" ndi "Ofanana".
  2. Zowonetsera zojambula zimatsegula. Kumunda "Pangani maselo omwe ali EQUAL" lowetsani mtengo "0". M'dongosolo labwino mundandanda wotsika pansi dinani pa chinthucho "Maonekedwe apangidwe ...".
  3. Windo lina likuyamba. Pitani kwa izo mu tab "Mawu". Dinani pa mndandanda wotsika. "Mtundu"momwe timasankha mtundu woyera, ndipo dinani pa batani "Chabwino".
  4. Pobwerera kuwindo lakupangidwira lapitalo, dinani pa batani. "Chabwino".

Tsopano, pokhapokha kuti phindu mu selo liri zero, silidzakhala losawoneka kwa wogwiritsa ntchito, chifukwa mtundu wa fayilo yake idzaphatikizana ndi mtundu wachikulire.

Phunziro: Mafomu omvera mu Excel

Njira 4: Gwiritsani ntchito Ntchito IF

Njira ina yobisala zero imaphatikizapo kugwiritsa ntchito wogwiritsa ntchito NGATI.

  1. Sankhani selo yoyamba kuchokera kumtunda momwe zotsatira za mawerengedwe zimachokera, ndipo ngati n'kotheka padzakhala zeros. Dinani pazithunzi "Ikani ntchito".
  2. Iyamba Mlaliki Wachipangizo. Fufuzani pa mndandanda wa ochita ntchito "NGATI". Pambuyo pofotokozedwa, dinani pa batani. "Chabwino".
  3. Festile yotsutsana ndi ogwira ntchito imatsekedwa. Kumunda "Mawu a Boolean" lowetsani ndondomeko yomwe imawerengera mu selo lolunjika. Ndicho chiwerengero cha kuwerengera kwa fomu iyi yomwe pamapeto pake ikhoza kupereka zero. Pazochitika zonse, mawu awa adzakhala osiyana. Pambuyo pokhapokha chithunzichi mu gawo lomwelo ife tikuwonjezera mawuwo "=0" popanda ndemanga. Kumunda "Kufunika ngati zoona" ikani danga - " ". Kumunda "Kufunika ngati zabodza" timabwereza ndondomekoyi kachiwiri, koma popanda mawu "=0". Deta itatha, dinani pakani "Chabwino".
  4. Koma vutoli pakali pano likugwiritsidwa ntchito pa selo imodzi yokha. Kuti mufanizire fomuyi ndi zinthu zina, ikani cholozera kumbali ya kumanja ya selo. Kugwiritsa ntchito chizindikiro chodzaza mu mawonekedwe a mtanda kumachitika. Gwiritsani botani lamanzere la mchenga ndi kukokera chithunzithunzi pamtunda wonse womwe uyenera kutembenuzidwa.
  5. Pambuyo pake, m'maselo amenewo omwe chifukwa cha kuwerengera kudzakhala zero zoyenera, mmalo mwa chiwerengero "0" padzakhala malo.

Mwa njira, ngati muzokambirana mabokosi m'munda "Kufunika ngati zoona" Ngati muyika dash, ndiye pamene mukuwonetsa zotsatira mu maselo okhala ndi chiwerengero cha zero padzakhala dash osati malo.

Phunziro: Excel ntchito mu Excel

Njira 5: Gwiritsani ntchito ntchito ECHRISE

Njira yotsatira ndi kuphatikiza kwakukulu kwa ntchito. NGATI ndi Ndizo.

  1. Monga momwe zinalili kale, tsegulani zenera zotsutsa za IF IF ikugwira ntchito mu selo yoyamba ya mndandanda womwe ukugwiritsidwa ntchito. Kumunda "Mawu a Boolean" lembani ntchito Ndizo. Ntchitoyi imasonyeza ngati chinthucho chidzaza ndi deta kapena ayi. Kenaka mutsegule mabotolo mmunda womwewo ndikulowetsa adiresi ya selo, yomwe, ngati ilibe kanthu, ikhoza kupanga chandamale selo zero. Tsekani mabotolo. Izi ziri, makamaka, woyendetsa Ndizo adzawone ngati pali deta iliyonse m'deralo. Ngati ali, ntchitoyi idzabwezera mtengo "WOONA", ngati sichoncho, ndiye - "ZINTHU".

    Koma zikhulupiliro za zifukwa ziwiri zotsatirazi NGATI timasinthasintha malo. Ndiko, kumunda "Kufunika ngati zoona" tchulani fomu yowerengera, ndi kumunda "Kufunika ngati zabodza" ikani danga - " ".

    Deta itatha, dinani pakani "Chabwino".

  2. Mofanana ndi njira yapitayi, lembani fomuyi pambali yonseyo pogwiritsira ntchito chikhomo chodzaza. Pambuyo pake, zikhalidwe za zero zidzachoka kumalo omwe atchulidwa.

Phunziro: Wowonjezera Wogwira Ntchito

Pali njira zambiri zochotsera chiwerengero cha "0" mu selo ngati chiri ndi chiwerengero cha zero. Njira yosavuta ndikutetezera mawonedwe a zero mu zochitika za Excel. Koma ziyenera kudziwika kuti zidzatha ponseponse. Ngati kuli kofunika kugwiritsa ntchito chiwonetsero chokha kumalo enaake, ndiye kuti pakuyimira izi, kufotokozera mwachidwi ndi kugwiritsa ntchito ntchito kudzapulumutsa. Njira imodzi mwa njira zomwe mungasankhire zimadalira mkhalidwe weniweni, komanso maluso omwe munthu akugwiritsa ntchito komanso zomwe akufuna.