Izixhumanisi ze-cyclic kuMicrosoft Excel

Kuyamukelwa ngokuvamile ukuthi izixhumanisi ze-cyclic ku-Excel ziyinkulumo eyiphutha. Impela, kaningi lokhu kuyiqiniso, kodwa hhayi njalo. Kwesinye isikhathi kusetshenziswa ngamabomu impela. Ake sibheke ukuthi izixhumanisi ze-cyclic ziyini, uzidala kanjani, uzithola kanjani ezinye ezikhona embhalweni, ukuthi usebenza kanjani nazo, noma ukuthi uzisusa kanjani uma kunesidingo.

Kusetshenziswa izikhombo eziyindilinga

Okokuqala, ake sithole ukuthi isixhumanisi esiyindilinga siyini. Eqinisweni, lokhu kuyinkulumo ethi, ngokusebenzisa amafomula kwamanye amaseli, ibhekisa kuyo uqobo. Kungaba futhi isixhumanisi esitholakala kwinto eshidi kuyo uqobo.

Kumele kwaziwe ukuthi ngokuzenzakalelayo, izinhlobo zanamuhla ze-Excel zivimba ngokuzenzakalelayo inqubo yokwenza umsebenzi we-cyclic. Lokhu kungenxa yokuthi izinkulumo ezinjalo zinephutha elikhulu, futhi ukulengula kukhiqiza inqubo eqhubekayo yokulandisa nokubala, okudala umthwalo owengeziwe ohlelweni.

Dala isixhumanisi esiyindilinga

Manje ake sibone ukuthi ungayakha kanjani inkulumo elula ye-cyclic. Lokhu kuzoba ukuxhumana okukhona kwiseli efanayo elibhekisa kuyo.

1. Khetha into eshidi A1 bese ubhala le nkulumo elandelayo kuyo:

   = A1

   Okulandelayo, chofoza inkinobho Ngena kwikhibhodi.



2. Ngemuva kwalokho, kuvela ibhokisi lezinkomba ze-cyclic phrase. Chofoza inkinobho kuyo. "Kulungile".



3. Ngakho-ke, sathola ukusebenza kwe-cyclic ephepheni lapho iseli elibhekisa kulo uqobo.

Ake senze lo msebenzi kancane bese sakha inkulumo eyi-cyclic evela kumaseli amaningana.

1. Kunoma iyiphi into eshidi, bhala inombolo. Kukhale cell A1, kanye nenombolo 5.



2. Kuya kwesinye iseli (B1) bhala isisho esithi:

   = C1



3. Kwinto elandelayo (C1) sibhala ifomula enjalo:

   = A1



4. Ngemuva kwalokho sibuyela esitokisini A1lapho inombolo isethwe khona 5. Sibhekisela entweni ekuyo. B1:

   = B1

   Chofoza inkinobho Ngena.



5. Ngakho-ke, i-loop ivaliwe, futhi sathola ireferensi eyindilinga yeklasi Ngemuva kokuthi iwindi lesexwayiso selivaliwe, sibona ukuthi uhlelo lwaphawula isixhumanisi se-cyclic ngemicibisholo eluhlaza okwesibhakabhaka eshidini, elibizwa ngokuthi imicibisholo yomkhondo.

Manje ake siqhubekele phambili ekwenzeni i-cyclic expression usebenzisa itafula lesibonelo. Sinethebula lokuthengisa ukudla. Inamakholomu amane lapho kukhonjiswa khona igama lezimpahla, inani lemikhiqizo ethengisiwe, intengo nenani lemali evela ekuthengisweni kwevolumu yonke. Ithebula kwikholamu lokugcina selivele linemininingwane. Babala imali ngokunyusa inani ngenani.

1. Ukuze uvule ifomula kulayini wokuqala, khetha ucezu lweshidi nenani lezinto zokuqala ezise-akhawuntini (B2) Esikhundleni senani le-static (6) sifaka ifomula lapho, ezocubungula inani lezimpahla ngokuhlukanisa inani eliphelele (D2) ngentengo (C2):

   = D2 / C2

   Chofoza inkinobho Ngena.



2. Sithole isixhumanisi sokuqala esiyindilinga, ubudlelwano lapho imvamisa buboniswa khona ngomcibisholo wokulandela. Kepha njengoba ubona, umphumela unephutha futhi ulingana no-zero, njengoba sekushiwo ngaphambili, i-Excel ivimba ukwenziwa kwemisebenzi ye-cyclic.



3. Kopisha isichasiselo kuwo wonke amanye amaseli kukholamu nenombolo yemikhiqizo. Ukuze wenze lokhu, beka ikhesa ekhoneni elingezansi kwesokudla kwento esevele ifomula. Isikhombisi siguqulwa sibe yisiphambano, esivame ukubizwa ngokuthi umaka wokugcwalisa. Bamba phansi inkinobho yegundane kwesobunxele bese udonsela lesi siphambano ekugcineni kwetafula phansi.



4. Njengoba ubona, le nkulumo ikopishwe kuzo zonke izakhi zekholomu. Kepha, buhlobo bodwa obumakiwe ngomcibisholo wokulandela. Qaphela lokhu ngekusasa.

Sesha izixhumanisi eziyindilinga

Njengoba sibonile ngenhla, hhayi kuzo zonke izimo lolu hlelo luphawula ubudlelwane besethenjwa eliyindilinga lezinto, noma ngabe liseshidi. Ngokuthi iqiniso lokuthi iningi lemisebenzi yokujikeleza iyalimaza, kufanele isuswe. Kepha kulokhu kufanele kutholakale kuqala. Ungakwenza kanjani lokhu uma izinkulumo zingamakiwe ngomugqa ngemicibisholo? Ake sibhekane nale nkinga.

1. Ngakho-ke, uma uqala ifayela le-Excel, iwindi lolwazi livula ukuthi liqukethe isixhumanisi esiyindilinga, kungakuhle-ke ukulithola. Ukuze wenze lokhu, iya kuthebhu Amafomula. Chofoza ubambo kunxantathu, olubekwe ngakwesokudla kwenkinobho "Bheka amaphutha"etholakala kwibhulokhi yamathuluzi Ukuncika Kwefomula. Imenyu iyavula lapho kufanele ungene khona entweni "Izixhumanisi eziyisiyingi". Ngemuva kwalokho, uhlu lwamakheli wezinto zeshidi lapho uhlelo luthole izinkulumo ze-cyclic luvula kumenyu elandelayo.



2. Uma uchofoza ikheli elithile, kukhethwa iseli elihambisanayo eshidini.

Kukhona enye indlela yokuthola ukuthi isixhumanisi esiyindilinga sikuphi. Umlayezo ngale nkinga kanye nekheli lale nto equkethe le nkulumo itholakala ohlangothini lwesobunxele sebha yesimo, etholakala ezansi kwewindi le-Excel. Kuliqiniso, ngokungafani nenguquko yangaphambilini, ibha yesimo ngeke iveze amakheli wazo zonke izinto eziqukethe izixhumanisi eziyindilinga, uma ziningi, kepha inye kuphela yazo evela phambi kwabanye.

Ngaphezu kwalokho, uma usencwadini equkethe i-cyclic expression, hhayi eshidini lapho itholakala, kepha kolunye, khona-ke kuleli cala kuphela umlayezo ophathelene nokuba khona kwephutha ngaphandle kwekheli uzoboniswa kubha yesimo.

Isifundo: Ungazithola kanjani izixhumanisi eziyindilinga e-Excel

Lungisa izixhumanisi ze-cyclic

Njengoba kushiwo ngenhla, ngobuningi bamacala, ukusebenza kwe-cyclical kubi okufanele ichithwe. Ngakho-ke, kunengqondo ukuthi ngemuva kokutholakala kokuxhumeka kwe-cyclic, kuyadingeka ukuyilungisa ukuze ilethe ifomula kwifomu elijwayelekile.

Ukuze ulungiselele ukuncika kwe-cyclic, kuyadingeka ukulandelela konke ukuxhumana kwezitokisi. Noma isheke likhombise iseli ethile, iphutha kungenzeka lingahlali lodwa, kodwa kolunye uhlangothi lwentambo yokuncika.

1. Esimweni sethu, ngaphandle kokuthi uhlelo lukhombe ngokunembile kwelinye lamaseli aku-loop (D6), iphutha langempela likhona kwesinye iseli. Khetha into D6ukuthola ukuthi yimaphi amaseli adonsa inani kuwo. Sibheka isichasiselo esisebhomeni lebha formula. Njengoba ukwazi ukubona, inani elikulesi sici sephepha lakhiwa ngokuphindaphinda okuqukethwe amaseli B6 futhi C6.



2. Iya esitokisini C6. Khetha bese ubheka umugqa wamafomula. Njengoba ukwazi ukubona, leli yinani elijwayelekile le-tuli (1000), okungewona umkhiqizo wokubala ifomula. Ngakho-ke, singasho ngokuqiniseka ukuthi into ebekiwe ayinalo iphutha elenza ukudala imisebenzi ye-cyclic.



3. Iya kuseli elilandelayo (B6) Ngemuva kokugqamisa kubha yefomula, siyabona ukuthi iqukethe isisho esibaliwe (= D6 / C6), edonsa idatha kusuka kwezinye izinto zethebula, ikakhulukazi, kusuka esitokisini D6. Ngakho-ke iseli D6 kubhekiswa kudatha yento B6 futhi okuphambene nalokho, okubangela ukuqaqa.

   

   Lapha sibala ubudlelwane ngokushesha okukhulu, kepha empeleni zikhona izimo lapho amaseli amaningi ebandakanyeka enqubweni yokubala, hhayi izinto ezintathu, njengoba senzile. Lapho-ke ukusesha kungathatha isikhathi esiningi, ngoba kuzofanele ufunde isifundo ngasinye se-cyclicity.

4. Manje sidinga ukuqonda ukuthi yiliphi iseli (B6 noma D6) iqukethe iphutha. Yize, ngokusemthethweni, lokhu akuyona neze iphutha, kepha ukusetshenziswa ngokweqile kwezixhumanisi, okuholela ku-loop. Ngesikhathi senqubo yokunquma ukuthi iyiphi iseli okufanele ihlelwe, kufanele kusetshenziswe logic. Akukho algorithm ecacile yezenzo. Kuwona womabili la mazwe, lokhu okubonakalayo kuzohluka.

   Isibonelo, uma etafuleni lethu inani eliphelele kufanele libalwe ngokuphindaphinda inani lempahla ethengisiwe ngenani lentengo yalo, khona-ke singasho ukuthi isixhumanisi esibala inani lemali ethengisiwe isiyonke sibabazekayo. Ngakho-ke, siyayisusa bese siyisusa esikhundleni senani lokuhlala.



5. Senza umsebenzi ofanayo kuzo zonke ezinye izinkulumo ze-cyclic, uma zisekeshidi. Ngemuva kokuthi yonke inkomba eyisiyingi isusiwe encwadini, umyalezo mayelana nokuba khona kwale nkinga kufanele unyamalale kubha yesimo.

   Ngaphezu kwalokho, noma ngabe izinkulumo ze-cyclic zisuswe ngokuphelele, ungathola usebenzisa ithuluzi lokuhlola iphutha. Iya kuthebhu Amafomula bese uchofoza unxantathu osuvele usujwayele ngakwesokudla kwenkinobho "Bheka amaphutha" eqenjini lamathuluzi Ukuncika Kwefomula. Uma kumenyu evulayo, "Izixhumanisi eziyisiyingi" ngeke isebenze, lokho kusho ukuthi sizisusile zonke izinto ezinjalo kudokhumenti. Ngaphandle kwalokho, kuzodingeka ukuthi usebenzise inqubo yokususa ezintweni ezisohlwini ngendlela efanayo naleyo ebikhe yacatshangelwa ngaphambilini.

Imvume ye-Loopback

Engxenyeni eyedlule yesifundo, sikhulume ikakhulu ngokuthi ungaziphatha kanjani izixhumanisi eziyindilinga, noma ukuthi ungazithola kanjani. Kepha, ngaphambili ingxoxo ibiphinde ibe ngeqiniso lokuthi kwezinye izimo, ngokungafani nalokhu, zingaba wusizo futhi zisetshenziswe ngonembeza ngumsebenzisi. Isibonelo, imvamisa le ndlela isetshenziselwa ukubalwa kwe-iterative ekwakheni amamodeli ezomnotho. Kepha inkinga ukuthi, kungakhathalekile ukuthi usebenzisa ibinzana eliyisiyingi ngonembeza noma ungazi, i-Excel ngokwakhona isazovimba ukusebenza kuyo, ukuze kungaholeli ekugcobeni ngokweqile kohlelo. Kulokhu, inkinga yokukhubaza ukhiye onjalo ngokufanele iba efanele. Ake sibheke ukukwenza.

1. Okokuqala, hambisa kuthebhu Ifayela Izicelo ze-Excel.



2. Okulandelayo, chofoza entweni "Izinketho"etholakala ohlangothini lwesobunxele lwewindi elivulayo.



3. Iwindows ongakhetha i-Excel iyaqala. Sidinga ukuya kuthebhu Amafomula.



4. Kusefasiteleni elivula ukuthi kungenzeka kuvunyelwe ukwenziwa kwemisebenzi ye-cyclic. Siya kwibhlokhi efanele lewindi, lapho izilungiselelo ze-Excel uqobo zitholakala khona. Sizosebenza nebhulokhi yezilungiselelo Ukubalwa kwamapharamithaelisendaweni ephezulu kakhulu.

   Ukuze unike amandla ukusetshenziswa kwe-cyclic expression, hlola ibhokisi eliseduze kwepharamitha Nika amandla i-Iterative Computing. Ngaphezu kwalokho, inani lomkhawulo we-iterations nephutha elihlobene lingasetwa kwibhloko efanayo. Ngokuzenzakalelayo, amanani abo ayi-100 no-0.001, ngokulandelana. Ezimweni eziningi, la maparamitha awadingi ukushintshwa, noma ngabe kunesidingo noma uma afisa, ungenza ushintsho kulezi zinkambu. Kepha lapha kufanele kubhekwe ukuthi ama-iterations amaningi kakhulu angaholela kumthwalo omkhulu kuhlelo nakuhlelo lonke, ikakhulukazi uma usebenza nefayela eliqukethe izinkulumo eziningi ze-cyclic.

   Ngakho-ke, hlola ibhokisi eliseduze kwepharamitha Nika amandla i-Iterative Computing, bese ukuze izilungiselelo ezintsha ziqale ukusebenza, chofoza inkinobho "Kulungile"etholakala ngaphansi kwewindows ongakhetha kukho.



5. Ngemuva kwalokho, siya ngokuzenzakalelayo eshidini lencwadi yamanje. Njengoba ubona, kumaseli lapho amafomula we-cyclic etholakala khona, manje amanani abalwa kahle. Uhlelo aluvimbi ukubalwa kubo.

Noma kunjalo, kubalulekile ukuqaphela ukuthi ukufakwa kokusebenza kwe-cyclic akufanele kuhlukunyezwe. Sebenzisa lesi sici kuphela uma umsebenzisi eqinisekile ngokuphelele ngesidingo saso. Ukufakwa okungenakuqhathaniswa kokusebenza kwe-cyclic ngeke kuholele kumthwalo omningi kuphela ohlelweni futhi kwehlise ukubalwa lapho kusetshenziswa idokhumenti, kepha umsebenzisi angafaka ngokungananazi inkulumo eyiphutha ye-cyclic, okuzothi ngokuzenzakalelayo ivinjelwe uhlelo.

Njengoba sikwazi ukubona, ngobuningi bamacala, izinkomba eziyindilinga kuyinto yomcimbi odinga ukulungiswa. Lokhu, okokuqala, kuyadingeka ukuthola ubudlelwane be-cyclic uqobo, bese ubala iseli lapho iphutha liqukethwe khona, futhi, ekugcineni, ukulisusa ngokwenza ushintsho olufanele. Kepha kwezinye izimo, ukusebenza kwe-cyclic kungaba wusizo ekubaleni futhi kwenziwa ngumsebenzisi ngonembeza. Kepha noma kunjalo, umuntu kufanele asondele ekusetshenzisweni kwabo ngokuqapha, ukumisa kahle i-Excel futhi azi isilinganiso ngokungeza izixhumanisi ezinjalo, okuthi, uma zisetshenziswa ngobuningi, zinganciphisa uhlelo.