Nzira yekuwana sei cyclic inobatanidza kuti ibudirire

Anonim

Cyclic link kuMicrosoft Excel

Cyclic mareferensi mareferenzi mune iyo imwe cell kuburikidza nekutevedzana kwekubatana nemamwe masero, pakupedzisira anoreva pachako. Mune zvimwe zviitiko, vashandisi vanoshandisa nehana chishandiso chakadai chekomputa. Semuenzaniso, nzira iyi inogona kubatsira nemuenzaniso. Asi, kazhinji, mamiriro ezvinhu aya anongova chikanganiso mumamiriro ezvinhu anotenderwa mushandisi akaremara kana zvimwe zvikonzero. Panyaya iyi, kubvisa chikanganiso, iwe unofanirwa kuwana pakarepo iyo cyclical link yacho pachayo. Ngatione kuti zvinoitwa sei.

Kuwanikwa kweCyclic Kubatanidza

Kana iyo cyclic link iripo mubhuku, ipapo paunotanga iyo faira, chirongwa mubhokisi dialog ruchayevera nezve chokwadi ichi. Saka, nedudziro yekuvapo chaiko kweiyo formula, hakuzove nematambudziko. Ungawana sei nzvimbo ine dambudziko pane pepa?

Nzira 1: bhatani pane ribhoni

  1. Kuti uzive, umo mhando iyo nzira yakadaro, yekutanga yezvinhu zvese, tinya bhatani seyechena muchena muzvikamu tsvuku mubhokisi rekunyevera dialog, nekudaro kuvhara.
  2. Kuvhara iyo Microsoft Excel Dialog Bhokisi

  3. Enda kune "mafomu" tab. Pamutepi mu "Frenchency Kuvimba" block kune bhatani "Kutarisa zvikanganiso". Dzvanya pane iyo icon muchimiro cheiyo yakatsanangurwa triangle padhuze neiyi bhatani. Mune menyu inoonekwa, sarudza "cyclic links". Mushure mekushandurwa kuri kuita iri kunyorwa muchimiro chemenyu chinoratidza zvese zvinongedzo zvechiuno chechikepe cheCyclic Chimiro mubhuku iri. Kana uchidzvanya pane zvinongedzo zveimwe sero, inova inoshanda pane pepa.
  4. Kutsvaga cyclic mareferenzi muMicrosoft Excel

  5. Nekudzidza mhedzisiro, isu tinogadza kutsamira uye kubvisa chikonzero cheCyclicity kana chakakonzerwa nechikanganiso.
  6. Kubvisa cyclic link muMicrosoft Excel

  7. Mushure mekuita zviito zvinodiwa, dzokera kunotarisa cyclic referenti yekukanganisa bhatani. Ino nguva inoenderana menyu chinhu haifanire kushandira zvachose.

Kuongorora zvakare kweiyo cycle link muMicrosoft Excel

Nzira 2: Trace Arrow

Pane imwezve nzira yekuziva kusavimbika kwakadaro kusingadiwe.

  1. Mune dialog bhokisi rinoshuma pamberi peCyclic Links, tinya iyo "OK" bhatani.
  2. Microsoft Excel dialog box

  3. Museve wekutevera unoonekwa, izvo zvinoratidza kutsamira kwedata rimwe musero rimwe kubva kune rimwe.

Trace museve muMicrosoft Excel

Izvo zvinofanirwa kucherechedzwa kuti nzira yechipiri inowanzooneka inooneka, asi panguva imwechete haiwanzo kupa mufananidzo wakajeka wekusarudzika, kusiyana nechisarudzo chekutanga, kunyanya mune yakaoma mafomu.

Sezvauri kuona, tsvaga iyo cyclic link yekubuda iri nyore, kunyanya kana iwe uchiziva algorithm. Iwe unogona kushandisa imwe yedzidzo mbiri dzekutsvaga kwakadaro. Zvimwe zvakawedzera kuoma kuona kana formula iyi ichidikanwa mune chaicho kana ichingori chikanganiso, pamwe nekugadzirisa chinongedzo chisina kujairika.

Verenga zvimwe