Korana na cyclic references muri excel

Bikekwa ko amafaranga ya cyclic arenze urugero ari imvugo itari yo. Mubyukuri, kenshi cyane ibi nibyo rwose, ariko ntabwo buri gihe. Rimwe na rimwe, bakoresha babishoboye. Reka tumenye uko guhuza kclic nuburyo bwo kubakora uburyo bwo kubona bimaze kuba murinditse uburyo bwo gukorana nabo cyangwa uburyo bwo kubikuraho.

Gukoresha Amashanyarazi

Mbere ya byose, menya neza nincle. Mubyukuri, iyi mvugo, binyuze mubice biri mu zindi selile, bivuga ubwabyo. Kandi, birashobora kuba umurongo uherereye mubibabi ubwabyo bivuga.

Twabibutsa ko muburyo busanzwe, verisiyo igezweho ya Excel ihita ihagarika inzira yo gukora ibikorwa bya cyclical. Ibi biterwa nuko imvugo nkiyi mubagore benshi bitabaye amakosa, kandi kurongora bitanga inzira ihoraho yo kwisubiraho no kubara, bitera umutwaro winyongera kuri sisitemu.

Gukora ihuza rya cyclic

Noneho reka turebe uburyo bwo gukora imvugo yoroshye ya cyclicstst. Iyi izaba ihuriro riri muri selire imwe ryerekezaho.

1. Turagaragaza ikintu cyurupapuro rwa A1 hanyuma wandike imvugo ikurikira muriyo:

   = A1.

   Ibikurikira, kanda kuri buto yinjira kuri clavier.



2. Nyuma yibyo, imvugo ya cyclic iburira ikiganiro agasanduku kagaragaye. Kanda muri yo kuri buto "OK".



3. Rero, twakiriye imikorere ya cyclilic kurupapuro aho ukorera ryerekeza.

Igikorwa gito cyoroshye no gukora imvugo ya cyclic muri selile nyinshi.

1. Mu kintu icyo ari cyo cyose cy'urupapuro, andika umubare. Reka bibe akagari A1, na nimero ya 5.



2. Mu kindi selile (B1) Andika imvugo:

   = C1.



3. Mubice bikurikira (c1) tuzandika formulaire:

   = A1.



4. Nyuma yibyo, dusubira muri selire A1, aho umubare washyizweho 5. Bivuga kuri Element B1:

   = B1.

   Kanda kuri buto ya Enter.



5. Rero, ukwezi gufunze, kandi twakiriye ihuza ryamagare ya kera. Nyuma yidirishya ryo kuburira rifunze, tubona ko gahunda yanditseho ingwate ya cyclic ifite imyambi yubururu kurupapuro, yita imyambi.

Ubu tumaze guhindukira gushiraho imvugo ya cyclic kurugero rw'ameza. Dufite imbonerahamwe yo gushyira mu bikorwa ameza. Igizwe ninkingi enye, zerekana izina ryibicuruzwa, umubare wibicuruzwa byagurishijwe, igiciro namafaranga yinjiza kuva kugurisha amajwi yose. Imbonerahamwe mu nkingi iheruka ifite formula. Babara amafaranga winjiza ugwiza umubare wigiciro.

1. Kugirango urekure formula kumurongo wambere, tugaragaza ikintu cyimpapuro hamwe numubare wibicuruzwa byambere (B2). Aho kuba agaciro gahamye (6), andika formulayo, zizasuzuma umubare wibicuruzwa ugabana amafaranga yose (D2) kubiciro (C2):

   = D2 / C2

   Kanda kuri buto ya Enter.



2. Twahinduye ihuza rya mbere rya Cyclic, umubano umenyereye umwambi. Ariko nkuko tubibona, ibisubizo ni amakosa kandi bingana na zeru, nkuko bimaze kuvugwa mbere, Excel ihagarika irangizwa ryibikorwa bya Cyclic.



3. Gukoporora imvugo mubindi bigo byose byinkingi hamwe nubunini bwibicuruzwa. Kugirango ukore ibi, shyira indanga kuruhande rwiburyo bwiburyo bwicyo kintu kimaze kubamo formula. Indanga yahinduwe kumusaraba, yahamagariwe guhamagara ikimenyetso cyuzuye. Kuraho buto yimbeba yibumoso hanyuma ukure uyu musaraba kugeza kumpera yimbonerahamwe hasi.



4. Nkuko mubibona, imvugo yandukuwe kubintu byose byinkingi. Ariko, umubano umwe gusa urangwa numwambi. Reba ejo hazaza.

Shakisha amahuza ya cyclic

Nkuko tumaze kuba hejuru, ntabwo mubibazo byose gahunda iranga umubano wa cyclic yerekanwe nibintu, kabone niyo byaba kurupapuro. Urebye ko mu bikorwa byinshi bya Cyclic byangiza, bigomba kuvaho. Ariko kubwibyo bagomba kubanza kubona. Nigute wabikora niba imvugo idahwitse numurongo wambaye imyenda? Reka duhangane n'iki gikorwa.

1. Noneho, niba utangiye dosiye ya Excel, ufite idirishya ryamakuru ikubiyemo umurongo wa cyclic, birakenewe kugirango ubone. Gukora ibi, kwimuka kuri tab "formulaire". Kanda kuri rubbon kuri mpandeshatu, iherereye iburyo bwa "Kugenzura amakosa", iherereye "kwishingikiriza" ibikoresho. Ibikubiyemo bifungura indanga igomba kwakirwa kuri "amahuza ya cyclic". Nyuma yibyo, menu ikurikira ifungura urutonde rwa aderesi yimpapuro gahunda yavumbuye imvugo yamenyo.



2. Iyo ukanze kuri aderesi yihariye, selile ihuye yatoranijwe kurupapuro.

Hariho ubundi buryo bwo kumenya aho umurongo wa cyclic uherereye. Ubutumwa buvuga iki kibazo na aderesi yibintu birimo imvugo nkiyi iherereye kuruhande rwibumoso bwibanze, iri hepfo yidirishya. Nukuri, bitandukanye na verisiyo yabanjirije, ibintu byose ntabwo ibintu birimo amashanyarazi azerekanwa kumurongo, niba hari benshi muribo, ariko umwe muribo, wagaragaye imbere yabandi.

Byongeye kandi, niba uri mu gitabo kirimo imvugo ya cyclic, ntabwo iri kurupapuro aho iherereye, hanyuma muriki gihe, gusa, gusa ubutumwa bujyanye no kuba hari ikosa rizerekanwa mumiterere yumurongo.

Isomo: Nigute Wabona Amahuza ya Cyclic kuri Excel

Gukosora Amashanyarazi

Nkuko byavuzwe haruguru, mu gihe kinini cy'imanza, ibikorwa bya cyclic ni bibi, bikagomba kuvaho byoroshye. Kubwibyo, birasanzwe ko nyuma yo guhuza Cyclic bigaragaye, birakenewe gukosora kugirango uzane formula muburyo busanzwe.

Kugirango ukosore ko urwenya rwishingiwe, ugomba gukurikirana imikoranire yose ya selile. Nubwo cheque yerekanye selile yihariye, noneho ikosa ntirishobora gutwikirwa muri yo ubwaryo, ariko mubindi bintu byurunigi rwumunyururu.

1. Kuri twe, nubwo gahunda yerekanaga neza imwe muri selile za Cycle (D6), ikosa nyaryo riri mu rindi selile. Hitamo ikintu cya D6 kugirango umenye selile ikurura agaciro. Turareba imvugo mu mugozi wa formula. Nkuko tubibona, agaciro muri uru rupapuro rwakozwe mukugwiza ibikubiye muri selile B6 na C6.



2. Jya muri selire ya C6. Turabigaragaza kandi tureba umugozi wa formula. Nkuko tubibona, niyo gaciro gasanzwe ihamye (1000), ntabwo ari ibicuruzwa bibarira formulaire. Kubwibyo, ni byiza kuvuga ko ibintu byagenwe bitarimo amakosa atera ibikorwa bya Cyclic.



3. Jya mu kagari kakurikira (B6). Nyuma yo gutoranya kumurongo, tubona ko ikubiyemo imvugo ibarwa (= D6 / C6), ikuramo amakuru mubindi bikoresho, byumwihariko, kuva muri selire ya D6. Rero, selile ya D6 yerekeza ku makuru y'ibihe B6 na ubundi, bitera imisanzure.

   

   Hano umubano twabaze vuba, ariko mubyukuri hari ibibazo mugihe selile nyinshi zigira uruhare mubikorwa byo kubara, ntabwo ari ibintu bitatu nkuko dufite. Noneho ubushakashatsi bushobora gufata igihe kirekire, kuko bugomba kwiga buri kintu cyose cyclical.

4. Noneho dukeneye kumva selile (B6 cyangwa D6) ikubiyemo ikosa. Nubwo, kumugaragaro, ntabwo ari amakosa, ariko gukoresha cyane ibyerekeranye nabyo biganisha ku kugerekaho. Mugihe cyo gukemura icyo kigo kigomba guhindurwa, ugomba gusaba logique. Nta algorithm isobanutse kubikorwa. Muri buri kibazo, iyi logique izaba iyayo.

   Kurugero, niba imbonerahamwe yacu yasangiye amafaranga yose agomba kubarwa mugwiza umubare wibicuruzwa byagurishijwe cyane kubiciro byayo, noneho dushobora kuvuga ko ihuza ryo kubara umubare wimibare yose yo kugurisha birenze urugero. Kubwibyo, turayikuraho kandi tubisimbuze bifite akamaro karahamye.



5. Igikorwa nkiki gikorwa hejuru yizindi mvugo zose zamagare niba ziri kurupapuro. Nyuma rwose amahuza yose yamenetse yasibwe mu gitabo, ubutumwa bujyanye no kuba iki kibazo bugomba kuzimira kumiterere yimiterere.

   Byongeye kandi, imvugo ya Cyclic yakuweho rwose, urashobora kumenya ukoresheje ibikoresho byo kugenzura amakosa. Jya kuri tab "formulas" hanyuma ukande inyabutatu umaze kumenyera iburyo bwa "Kugenzura amakosa" mu itsinda ryigikoresho "Bitewe n'amashyirahamwe" . Niba "ihuza rya cyclic" muri menu yo kwiruka ntabwo rikora, noneho, bivuze ko twakuye ibintu nkibi byose kuva inyandiko. Mu rubanza rutandukanye, uzakenera gushyira mubikorwa inzira yo gukuraho kubintu byerekanwe, kimwe kimwe.

Uruhushya rwo gukora ibikorwa bya Cyclic

Mu gice cyabanjirije iyi somo, twabibwiye, cyane cyane uburyo bwo guhangana nibisobanuro bya cyclic, cyangwa uburyo bwo kubibona. Ariko, mbere yaho, ikiganiro nacyo kijyanye nibyo mubihe bimwe na bimwe, kubinyuranye, birashobora kuba ingirakamaro kandi babishoboye numukoresha. Kurugero, kenshi ubu buryo bukoreshwa mubibara mugihe wubaka icyitegererezo cyubukungu. Ariko ibibazo ni uko, utitaye ko ubishaka cyangwa utabishaka ukoresha imvugo ya Cyclic, Excel izakomeza kubuza ibikorwa byabisanzwe, kugirango utabaze kubijyanye no kurenza urugero bwa sisitemu. Muri iki gihe, ikibazo cyo guhagarika ihatirwa kiba ngombwa. Reka turebe uko twabikora.

1. Mbere ya byose, twimukira muri tab ya "dosiye" ya Expl Porogaramu.



2. Ibikurikira, kanda kuri "Ibipimo" byimbere kuruhande rwibumoso bwidirishya ryakinguye.



3. Idirishya ryimisozi ritangira gukora. Tugomba kujya muri tab "formulaire".



4. Ni mu idirishya rifungura zizemererwa gukora ishyirwa mu bikorwa ry'ibikorwa bya Cyclic. Jya kumurongo wiburyo wiyi idirishya, aho igenamiterere ryingenzi riri mu buryo butaziguye. Tuzakorana hamwe na "Ikiganiro kibara" Igenamiterere, riherereye hejuru.

   Kwemerera gukoresha imvugo ya Cyclic, ugomba kwinjizamo amatiku yerekeye "Gushoboza kubara" Ibipimo byimibare ". Mubyongeyeho, murwego rumwe, urashobora gushiraho umubare ntarengwa wimiterere hamwe nikosa rigereranijwe. Mburabuzi, indangagaciro zabo ni 100 na 0.001. Mubihe byinshi, ibi bipimo ntibikeneye guhinduka, nubwo bibaye ngombwa, birashoboka kugira icyo mpindura mumirima yagenwe. Ariko hano birakenewe gusuzuma ko ibintu byinshi bishobora kuganisha kumutwaro ukomeye kuri gahunda na sisitemu muri rusange, cyane cyane iyo ukorana na dosiye ashyizwemo amagambo menshi ya Cyclic ashyirwa.

   Rero, dushyireho amatiku yerekeye kubara "bishoboza kubara" Ibipimo, hanyuma igenamiterere rishya ritangira gukurikizwa, kanda kuri buto ya "OK", iherereye munsi yidirishya rya Excel.



5. Nyuma yibyo, duhita tujya kurupapuro rwigitabo cyubu. Nkuko tubibona, muri selile formulane ya cyclic iherereye, noneho indangagaciro zibarwa neza. Porogaramu ntabwo ihagarika kubara muri bo.

Ariko birakwiye ko tumenya ko kwinjiza ibikorwa bya Cyclic bitagomba guhohoterwa. Koresha iyi mikorere ikurikira gusa iyo umukoresha yizeye rwose ko akeneye. Kwinjiza ibikorwa bidafite ishingiro ntibishobora kuganisha gusa ku mutwaro ukabije kuri sisitemu kandi ugabanye kubara iyo ukorana inyandiko, ariko umukoresha ashobora utabishaka akora imvugo itari yo, ibisanzwe bizahagarikwa na gahunda.

Nkuko tubibona, murwego rwinshi rwimanza, ibijyanye na siclic ni ibintu ukeneye kurwana. Kubwibyo, mbere ya byose, ugomba kumenya umubano wamagare ubwayo, hanyuma ubare selile aho ikosa ririmo, hanyuma uyikureho muguhindura neza. Ariko mubihe bimwe, ibikorwa bya Cyclic birashobora kuba ingirakamaro mugihe kubara no gukoreshwa numukoresha ubishaka. Ariko nubwo bimeze bityo, birakwiye gukoresha imikoreshereze hamwe no kwitonda, gushiraho neza kandi uzi igipimo cyo hiyongereyeho ibintu, ibyo bikoreshwa mubwinshi, birashobora kudindiza imikorere ya sisitemu.