Shanda ne cyclic mareferensi muExcel

Zvinotendwa kuti cyclic mareferensi mukubudirana pane chirevo chisina kunaka. Chokwadi, kazhinji kazhinji izvi ndizvo chaizvo, asi zvakadaro kwete nguva dzose. Dzimwe nguva vanoshandisa nehana nehana. Ngatitsvagei ndezvipi cyclic links maitiro ekuvaita kuti vagadzire maitiro atove varipo mugwaro rekushanda navo kana kuibvisa.

Shandisa ye cyclic mareferensi

Chekutanga pane zvese, tsvaga kuti chii chinonzi cyclic link. Mukukosha, uku kutaura, uko, kuburikidza nemaforama mune mamwe masero, anoreva pachayo. Zvakare, inogona kunge iri chinongedzo chiri muchimiro cheiyo shizha chaiye iyo iyo pachayo inoreva.

Izvo zvinofanirwa kucherechedzwa kuti nekusarudzika, shanduro dzemazuva ano dzemubiru dzoga dzinovhara maitiro ekuita cyclical kushanda kwesclical. Izvi zvinokonzerwa nenyaya yekuti kutaura kwakadai mukuwanda kukuru kwakashata, uye kushamisika kunobereka mamiriro ezvinhu ekudzokorora uye kuverenga, izvo zvinogadzira imwe mutoro wehurongwa.

Kugadzira cyclic link

Zvino ngatione kuti sei kugadzira iyo yakapfava kutaura kweCyclical. Ichi chichava chinongedzo chiri muchitokisi chimwe chete icho charinoreva.

1. Isu tinoratidza chinhu cheiyo A1 sheet uye nyora zvinotevera kutaura mariri:

   = A1.

   Tevere, tinya pane iyo Enter bhatani pane iyo keyboard.



2. Mushure meizvozvo, iyo cyclic yekutaurirana yambiro dialog box inoonekwa. Dzvanya mariri pa "OK" bhatani.



3. Nekudaro, takagamuchira mashandiro eCyclical pane pepa racho rinoreva kuti sero racho rinoregedza pachayo.

Basa risinganzwisisike rakawanda uye riumba kutaura kwe cyclic kubva pamasero akati wandei.

1. Mune chero chinhu chebepa, nyora nhamba. Ngazvive sero a1, uye nhamba 5.



2. Mune imwe sero (B1) Nyora chirevo:

   = C1.



3. Mune inotevera chinhu (C1) Tichanyorera fomu yakadaro:

   = A1.



4. Mushure meizvozvo, tinodzokera kuchitokisi A1, mune iyo nhamba iyo nhamba yacho 5. Inoreva nezvayo kune iyo element b1:

   = B1.

   Dzvanya pane iyo Enter bhatani.



5. Saka, kutenderera kwakavharwa, uye takagamuchira yekirasi cyclic link. Mushure mekunge hwindo rekunyevera rakavharwa, tinoona kuti chirongwa chakaratidza cyclic bondine nemiseve yebhuruu pane pepa, rinodaidzwa kuti miseve.

Isu tachinjira kugadzira chirevo che cycic pane muenzaniso wetafura. Tine tafura yekuita tafura. Iyo ine makoramu mana, ayo anoratidza zita rezvinhu, huwandu hwezvigadzirwa zvinotengeswa, mutengo uye huwandu hwemari kubva mukutengesa kwese vhoriyamu. Tafura iri muColumn yekupedzisira yatove nemafomula. Ivo vanoverenga mari yekuverenga nekuwanza huwandu hwemutengo.

1. Kusunungura fomula mumutsara wekutanga, isu tinoratidza iyo sheet chinhu nehuwandu hwechigadzirwa chekutanga (B2). Panzvimbo yeiyo Static kukosha (6), isa iyo formula ipapo, iyo ichafunga huwandu hwezvinhu nekukamura huwandu hwakazara (D2) kwemutengo (C2):

   = D2 / C2

   Dzvanya pane iyo Enter bhatani.



2. Isu takatsauka pekutanga cyclic link, hukama umo hunoziva museve museve. Asi sezvatinoona, mhedzisiro yacho inokanganisa uye yakaenzana ne zero, sezvo yakataurwa kare, Excel inovhara kuurayiwa kwe cyclic mashandiro eCyclic.



3. Kopa kutaura kwacho kuita mamwe masero ese ekisimusi ine huwandu hwezvigadzirwa. Kuti uite izvi, isa iyo inotuka kune iyo yepazasi chaiyo kona yeiyo chinhu ichocho chatove neiyo formula. Iyo inotendeuka inoshandurwa kuva muchinjiko, iyo inonzi yekudaidza mucherechedzo unozadza. Bvisa bhatani rekuruboshwe rombo uye dhonza iyi muchinjiro kusvika kumagumo etafura pasi.



4. Sezvauri kuona, kutaura kwacho kwakapepetwa kune zvese zvinhu zvekoramu. Asi, chete hukama chete hwakarongedzwa nemuseve museve. Cherekedza iyo yeramangwana.

Tsvaga yeCyclic Links

Sezvatatoona kumusoro, kwete mune zvese zviitiko chirongwa chinoratidzira hukama hwekono cyclic rezve zvinhu, kunyangwe kana iri papepa. Kupiwa chokwadi chekuti mune yakawandisa vazhinji mashisheni eCyclic inokuvadza, inofanira kubviswa. Asi izvi zvinofanirwa kutanga zvatinowana. Maitiro Ekuita izvi kana mazwi asina kunyorwa nemutsara museve? Ngatitambei nebasa iri.

1. Saka, kana iwe ukatanga faira reExcel, iwe une ruzivo rwunowanikwa rwune cyclic link, inodikanwa kuti iwane. Kuita izvi, fambisa kune "mafomu" tab. Dzvanya pane iyo ribhoni pane iyo triangle, iyo iri kurudyi kweiyo "kutarisa zvikanganiso", iri mu "nzvimbo yekuvimbika" Menyu inovhura menyu iyo iyo iyo iyo iyo iyo iyo iyo inofanirwa kuitirwa ku "Cyclic Links". Mushure meizvozvo, iyo inotevera menyu inovhura runyorwa rwemakero ezvinyorwa zvinhu izvo chirongwa chakawana chirongwa checyclic.



2. Kana uchidzvanya pane yakatarwa kero, sero rinoenderana rinosarudzwa papepa.

Pane imwe nzira yekuziva kuti iyo cyclic link inowanikwa. Iyo meseji nezve dambudziko iri uye kero yeiyo chinhu chine chirevo chakafanana chiri kuruboshwe rwechimiro chemamiriro ezvinhu, iyo iri pazasi pewindows windows. Chokwadi, kusiyana neiyo yapfuura vhezheni, kero dzezvinhu zvese zvine zvirevo zveCyclic zvicharatidzwa pane chinzvimbo bar, kana paine akawanda acho, asi mumwe wavo chete, akaonekwa pamberi pevamwe.

Mukuwedzera, kana iwe uri mubhuku rine chirevo che cyclic, kwete papepa painowanikwa, uye kune rimwe, panguva ino, chete meseji pamusoro pekuvapo kwechikanganiso icharatidzwa mune chimiro chebhari.

Chidzidzo: Ungawana sei Cyclic Links kuti Excel

Kururamisa kwe cyclic mareferensi

Sezvataurwa pamusoro apa, mune yakawanda yakawanda yezviitiko, mashandiro eCyclic akaipa, kubva ipapo anofanira kubviswa zviri nyore. Naizvozvo, zvakangoitika kuti mushure mekunge iyo cyclic yekubatanidza yaonekwa, inodikanwa kuti igadzirise kuunza fomula kune yakajairika fomu.

Kuti ugadzirise iyo cyclical kutsamira, iwe unofanirwa kutsvaga iyo yose yekubatana kwemasero. Kunyangwe kana cheki yacho yakaratidza sero chairo, saka kukanganisa kunogona kunge kusiri kufukidzwa mairi, asi mune chimwe chinhu checheni yekuvimbika.

1. Mukati medu, kunyangwe iyo iyo chirongwa ichi chakanongedzera kune imwe yemasero cycle (D6), iko kukanganisa chaiko kuri mune imwe sero. Sarudza iyo D6 Element kuti uone kuti ndeipi masero anodhonza kukosha. Isu tinotarisa pane chirevo muThemula tambo. Sezvatinoona, kukosha kweiyi pepa chinhu kunoumbwa nekuwanza zviri mukati meB6 uye C6 masero.



2. Enda kune c6 cell. Isu tinoratidzira uye tinotarisa tambo yeFormula. Sezvatinoona, ndiyo nguva yakajairwa nhamba (1000), iyo isiri chigadzirwa chengetedza fomula. Naizvozvo, zvakachengeteka kutaura kuti chinhu chakataurwa hachina zvikanganiso zvichikonzera mashandiro e cyclic.



3. Enda kuchitokisi chinotevera (B6). Mushure mekusarudzwa muFomula mutsara, tinoona kuti ine chirevo chekuverengerwa (= D6 / C6), iyo inodhonza iyo data kubva kune zvimwe zvinhu zvidiki, kunyanya, kubva kuCell Cell. Nekudaro, iyo D6 sero inoreva iyo data yeiyo B6 uye Zvidyo zvinopesana, izvo zvinokonzera kusanzwisisika.

   

   Pano hukama hwatakaverenga nekukurumidza, asi pachokwadi pane zviitiko apo masero mazhinji anobatanidzwa mukuenzanisa, uye kwete zvinhu zvitatu sezvatinazvo. Ipapo kutsvaga kunogona kutora nguva yakareba, nekuti ichafanira kudzidza zvese zvechinyakare chinhu.

4. Zvino isu tinofanirwa kunzwisisa kuti ndeipi sero (b6 kana d6) ine chikanganiso. Kunyangwe, nenzira ino, hazvisi kunyange kukanganisa, asi kungoshandisa zvakanyanyisa kutaurwa kunotungamira kuLooping. Munguva yekuita kwekugadzirisa iyo sero inofanirwa kurongeka, iwe unofanirwa kushandisa pfungwa. Iko hakuna kujeka algorithm yekuita. Panguva dzose, iyi pfungwa ichave yayo.

   Semuenzaniso, kana tafura yedu yakagovana huwandu hwese hunofanirwa kuverengerwa nekuwedzera huwandu hwekutengeserana zvakanyatso kutengesa zvinhu pamutengo wazvo, saka tinogona kutaura kuti chinongedzo chekuverenga huwandu hwehuwandu hwekutengesa hwakanyatsojeka. Naizvozvo, isu tinoibvisa uye tochigadzirisa neyekutangiswa.



5. Kuvhiya kwakadaro kunoitwa pamusoro pezvese zvimwe zvevamwe cyclic kutaura kana vari papepa. Mushure mekunge zvese zvinongedzo zvese zvakabviswa kubva mubhuku, meseji pamusoro pekuvapo kwedambudziko iri kunofanirwa kunyangarika kubva pachimiro.

   Mukuwedzera, kutaura kwemazwi kwakabviswa zvachose, iwe unogona kuwana uchishandisa kukanganisa kwekutarisa chishandiso. Enda ku "Formulas" tab uye tinya iyo triangle yatojaira kwatiri kurudyi kwe "kutarisa zvikanganiso" mubato wechibatsira "Zvichienderana mafomula" . Kana iyo "cyclic inobatanidza" chinhu mumamino menyu haishande, saka, zvinoreva kuti takabvisa zvinhu zvese zvakadai kubva mugwaro. Pane imwe nguva yakatarisana, iwe uchafanirwa kuisa iyo yekubvisa maitiro kune izvo zvinhu zvakanyorwa, zvakafanana nenzira imwechete.

Mvumo yekuurayiwa kwe cyclic mashandiro

Muchikamu chapfuura chechidzidzo, takataura, kunyanya maitiro ekuita ne cyclic mareferenzi, kana kuti adzinga sei. Asi, pakutanga, kukurukurirana kwaive zvakare nezve izvo mune zvimwe zviitiko ivo, pane zvinopesana, zvinogona kubatsira uye kusashandiswa nehana mushandisi. Semuenzaniso, kazhinji nzira iyi inoshandiswa kune iyo Inforive kuverenga kuverenga kana kuvaka mhando dzehupfumi. Asi dambudziko nderekuti, zvisinei nekuti iwe unoshingairira kana kusaziva unoshandisa chirevo che cyclic, Excel icharamba ichivhara kuvhiya, kuti usatungamire kuwandisa kwehurongwa hwehurongwa. Mune ino kesi, mubvunzo wekumanikidzwa uchishungurudza kuvharira kwakadaro kunoenderana. Ngatione kuti ungazviita sei.

1. Chekutanga pane zvese, isu tinofamba kune "faira" tab ye Excel application.



2. Tevere, tinya pane "parameter" chinhu chiri kuruboshwe rwehwindo rakavhurwa.



3. Iyo yeratidziro paramende hwindo rinotanga kumhanya. Tinoda kuenda ku "Formulas" tab.



4. Iyo iri muhwindo iyo inovhurira ichabvumidzwa kuita kuitwa kweiyo cyclic mashandiro. Enda kune yakakodzera block yehwindo iri, uko iyo Excel marongero ari zvakananga. Isu tichashanda ne "komputa paramende" marongero akavhara, iyo iri kumusoro.

   Kuti ubvumire kushandiswa kweiyo cyclic kutaura, iwe unofanirwa kuisa tick nezve "gonesa iyo gadziriro yeiyo gadziriso" paramende. Uye zvakare, mune imwe chete block, iwe unogona kugadzirisa huwandu hwehuwandu hwehupfu uye kukanganisa kwehama. Nekusarudzika, tsika yavo zana uye 0.001, zvichiteerana. Muzhinji, aya paramita haafanire kuchinjwa, kunyange kana zvichidikanwa, zvinokwanisika kuita shanduko kuminda yakatarwa. Asi pano zvakafanira kuti ufunge kuti zvakanyanya kuwandisa kunogona kutungamira kune yakakomba mutoro pachirongwa uye system yacho yakazara, kunyanya kana iwe ukashanda nefaira madzishe manyoro.

   Nekudaro, isu tinoisa tick nezve "kugonesa macomputer qualation" paramende, uyezve izvo zvigadziriso zvitsva zvakapinda musimba, tinya pane iyo "ok" bhatani, iri pazasi pexcel parameter hwindo.



5. Mushure meizvozvo, tinongoenda kune pepa rebhuku razvino. Sezvatinoona, mumasero mune iyo cyclic maoffolas, ikozvino iwo maitiro anoverengerwa nemazvo. Chirongwa ichi hachivhiringidze kuverenga mavari.

Asi zvakadaro zvakakodzera kucherechedza kuti kusanzwisisika kwemabasa eCyclic hakufanirwe kushungurudzwa. Nyorera iyi chimiro chinotevera chete kana mushandisi achivimba chose mukushayiwa kwake. Hazvina musoro kusanzwisisika kwemabasa ekwenzi haakwanisi kutungamira kune zvakanyanyisa mutoro pane system uye kudzora kuverenga kana kusaziva nekuita kutaura kwekutsanangurwa, uko nekukasira kwaizovharwa nechirongwa.

Sezvatinoona, mukuwanda kwazvo kwezviitiko, cyclic mareferensi inonakidza yaunoda kurwa. Neichi chekutanga pane zvese, iwe unofanirwa kuona hukama hwenyama pachake, wozoverenga sero panowanikwa kukanganisa, uye pakupedzisira uzvishandise nekugadzirisa zvakakodzera. Asi mune zvimwe zviitiko, maCyclic mashandiro anogona kubatsira kana kuverenga uye kushandiswa nemushandisi nehana nehana. Asi kunyange zvakadaro, zvakakodzera kushandisa zvavanenge vachingwarira, kurongedza zvakanaka Excel uye kuziva chiyero chekuwedzera kwezviratidzo zvakadaro, izvo, kana zvichishandiswa muhuwandu hwemari, hunogona kudzora kushanda kwehurongwa hwehurongwa.