Umsebenzi we-INDIRECT ku-Microsoft Excel

Omunye wemisebenzi eyakhelwe ngaphakathi ye-Excel E-INDIA. Umsebenzi wayo ukubuyela entweni eshidi lapho ibekwe khona, okuqukethwe kweseli lapho isixhumanisi sikhonjiswe khona ngendlela yokuphikisana ngefomethi yombhalo.

Kungabonakala ukuthi akukho lutho olukhethekile kulokhu, ngoba kungenzeka ukuthi kuboniswe okuqukethwe kweseli elilodwa kwelinye ngezindlela ezilula. Kepha, njengoba kuvela, ukusebenzisa lo opharetha kufaka ama-nuances awenza ehlukile. Kwezinye izimo, le formula ingaxazulula izinkinga ezingenakuxazululwa ngezinye izindlela, noma kube nzima kakhulu ukuzenza. Masithole ngemininingwane eminingi ukuthi uyini opharetha. E-INDIA nokuthi ingasetjenziswa kanjani ekwenzeni.

Ukusetshenziswa kwefomula ye-INDIRECT

Igama le-opharetha elinikeziwe E-INDIA imele kanjani Isixhumanisi Esimbili. Empeleni, lokhu kukhombisa inhloso - ukukhipha idatha ngesixhumanisi esibekiwe kusuka kwesinye iseli kuya kwesinye. Ngaphezu kwalokho, ngokungafani neminye imisebenzi esebenza ngezixhumanisi, kufanele ikhonjiswe ngefomethi yombhalo, okungukuthi, imakwe ngamamaki wokucaphuna kuzo zombili izinhlangothi.

Lo opharetha ungokwesigaba semisebenzi. Izinkomba kanye nokufika futhi ine-syntax elandelayo:

= INDIRECT (cell_link; [a1])

Ngakho-ke, ifomula inezimpikiswano ezimbili kuphela.

Ukuxabana Isixhumanisi Seseli kwethulwe njengesixhumanisi sento yeshidi, imininingwane equkethe lapho ufuna ukubonisa khona. Ngasikhathi sinye, isixhumanisi esichaziwe kufanele sibe nokubukeka kombhalo, okungukuthi, “ukusongwa” ngamamaki wokucaphuna.

Ukuxabana "A1" kuyakhethwa futhi ngobuningi bamacala awudingi ukukhonjiswa nhlobo. Kungaba nezincazelo ezimbili "IQINISO" futhi FALSE. Esimweni sokuqala, opharetha uchaza izixhumanisi kwisitayela "A1", okungukuthi, lesi sitayela sifakwa ku-Excel ngokuzenzakalelayo. Uma inani lempikiswano lingacacisiwe nakancane, khona-ke lizocatshangelwa ngokufana "IQINISO". Esimweni sesibili, izixhumanisi zichazwa ngesitayela "R1C1". Lesi sitayela sezixhumanisi kufanele sifakwe ngokuqondile kuzilungiselelo ze-Excel.

Kalula nje E-INDIA Kuluhlobo lokuxhumeka okulinganayo kusuka kwesinye iseli kuya kwesinye ngemuva kophawu olulinganayo. Isibonelo, ezimweni eziningi, isisho

= INDlamo ("A1")

izolingana nenkulumo

= A1

Kepha ngokungafani nenkulumo "= A1" opharetha E-INDIA awukhishwe esitokisini esithile, kodwa ezixhumanisini zento eshidi.

Cabanga ukuthi kusho ukuthini lokhu ngesibonelo esilula. Ezitokisini B8 futhi B9 kuthunyelwe ngokufanele okubhalwe phansi "=" ifomula nomsebenzi E-INDIA. Womabili amafomula abhekisela entweni ethile. B4 futhi ubonise okuqukethwe kwayo ephepheni. Ngokwemvelo, lokhu okuqukethwe kuyafana.

Faka enye into engenalutho etafuleni. Njengoba ubona, imigqa iguqukile. Kwindlela esetshenziswayo okulinganayo inani lihlala lifana, ngoba libhekisela kuseli lokugcina, noma ngabe izixhumanisi zalo ziguqukile, kepha idatha ekhonjiswe opharetha E-INDIA seshintshile. Lokhu kungenxa yokuthi ayibhekiseli entweni eshidi, kepha kulokuxhumanisa. Ngemuva kokungeza ulayini wekheli B4 iqukethe enye into eshidi. Okuqukethwe manje sekuyifomula nemibukiso ekhasini lokusebenzela.

Lo opharetha uyakwazi ukubonisa kwesinye iseli hhayi izinombolo kuphela, kodwa futhi nombhalo, umphumela wokubala amafomula namanye amanani atholakala kutho lweshidi elikhethiwe. Kepha ekusebenzeni, lo msebenzi awuvamile ukusetshenziswa ngokuzimela, futhi kaningi uyingxenye ebalulekile yamafomula ayinkimbinkimbi.

Kumele kwaziwe ukuthi opharetha usebenza izixhumanisi zamanye amakhasi okusebenza futhi nokuqukethwe kwamanye amabhuku okusebenza e-Excel, kepha kulokhu kufanele kwethulwe.

Manje ake sibheke izibonelo ezithile zokusebenzisa opharetha.

Isibonelo 1: ukusetshenziswa komsebenzisi oyedwa

Ukuqala, cabanga ngesibonelo esilula kakhulu lapho kusebenza khona E-INDIA yenza ngokuzimela ukuze uqonde ubuningi bomsebenzi wakhe.

Sinethebula lokuphikisana. Umsebenzi ukwedatha imephu yeseli lokuqala lekholamu lokuqala liye entweni yokuqala yekholamu ehlukile kusetshenziswa ifomula efundwayo.

1. Khetha into yokuqala engenalutho lapho sihlela ukufaka ifomula. Chofoza isithonjana "Faka umsebenzi".



2. Iwindows liqala ukukhuphuka. Umsebenzi Wizards. Siqhubekela esigabeni Izinkomba kanye nokufika. Ukusuka ohlwini, khetha inani "INDIA". Chofoza inkinobho "Kulungile".



3. Iwindi lokuphikisana lesisebenzi esichaziwe liqala. Ensimini Isixhumanisi Seseli liyadingeka ukukhombisa ikheli laleyo nto eshidini esizokubonisa okuqukethwe kuyo. Vele, ingafakwa ngesandla, kepha okulandelayo kuzoba okusebenzayo futhi okulula kakhulu. Setha ikhesa endle, bese uqhafaza kwesobunxele kwinto ehambisanayo eshidini. Njengoba ubona, ngokushesha emva kwalokho ikheli lakhe lavezwa enkundleni. Ngemuva kwaloko, kuzinhlangothi zombili, khetha isixhumanisi esinamamaki wokucaphuna. Njengoba sikhumbula, lesi yisici sokusebenza nengxabano yaleli formula.

   Ensimini "A1", njengoba sisebenza ngohlobo olujwayelekile lwezixhumanisi, singabeka inani "IQINISO", kepha ungayishiya ingenalutho ngokuphelele, esizokwenza. Lokhu kuzoba yizenzo ezifanayo.

   Ngemuva kwalokho chofoza inkinobho "Kulungile".



4. Njengoba ukwazi ukubona, manje okuqukethwe kweseli lokuqala lekholamu lokuqala kwetafula kukhonjiswa kutho lweshidi lapho ifomula itholakala E-INDIA.



5. Uma sifuna ukufaka lo msebenzi kumaseli atholakala ngezansi, khona-ke kulokhu kuzofanele sifake ifomula entweni ngayinye ngokwahlukana. Uma sizama ukuyikopisha kusetshenziswa umaki wokugcwalisa noma enye indlela yokukopisha, kuzovezwa igama elifanayo kuzo zonke izinto zekholomu. Iqiniso ngukuthi, njengoba sikhumbula, isixhumanisi sisebenza njengengxabano ngefomu lombhalo (elisongwe ngamaphuzu wokucaphuna), okusho ukuthi ngeke lihambisane.

Isifundo: I-Excel Feature Wizard

Isibonelo 2: ukusebenzisa opharetha kwifomula eyinkimbinkimbi

Manje ake sibheke isibonelo sokusetshenziswa kaningi kosebenzisa opharetha E-INDIAlapho iyingxenye yefomula eyinkimbinkimbi.

Sinethafa lomholo lanyanga zonke lebhizinisi. Sidinga ukubala inani lemali yesikhathi esithile, isibonelo, Mashi - Meyi noma uJuni - Novemba. Vele, ngalokhu ungasebenzisa ifomula elula yensiza, kepha kulokhu, uma udinga ukubala umphumela ophelele wesikhathi ngasinye, kuzofanela sishintshe le formula ngaso sonke isikhathi. Kepha uma usebenzisa umsebenzi E-INDIA uzokwazi ukushintsha ububanzi obufingqiwe ngokumane usho inyanga ehambisanayo kumaseli ahlukile. Ake sizame ukusebenzisa le ndlela ukwenza kuqala ukubala inani lesikhathi kusukela ngoMashi kuya kuMeyi. Lokhu kuzosebenzisa ifomula ngenhlanganisela yabasebenza ISUM futhi E-INDIA.

1. Okokuqala, ezintweni ngazinye eshidini sifaka amagama wezinyanga zokuqala nezokuphela kwesikhathi lapho kuzokubalwa khona, ngokulandelana Mashi futhi Meyi.



2. Manje nikeza igama kuwo wonke amaseli kukholamu Imali engenayo, okuzofana negama lenyanga ehambisanayo. Lokho wukuthi, into yokuqala kwikholamu Imali engenayooqukethe usayizi wemali okufanele ubizelwe Janawarikwesibili - UFebhuwari njll.

   Ngakho-ke, ukunikeza igama entweni yokuqala yekholamu, likhethe bese uqhafaza inkinobho yegundane elifanele. Imenyu yokuqukethwe iyavula. Khetha into ekuyo "Nikeza igama ...".



3. Iwindi lokudala igama liyaqala. Ensimini "Igama" faka igama Janawari. Azikho ezinye izinguquko ezidingekayo efasiteleni, noma ngabe kungenzeka, ungabheka ukuthi izixhumanisi zensimu "Ububanzi" lihambisana nekheli leseli eliqukethe imali kaJanuwari. Ngemuva kwalokho chofoza inkinobho "Kulungile".



4. Njengoba ubona, manje lapho le nto ikhethiwe kufasitela legama, akuyona ikheli layo eliboniswayo, kodwa igama esilinike lona. Senza umsebenzi ofanayo nazo zonke ezinye izinto zekholomu. Imali engenayouyiqambe ngokulandelana UFebhuwari, Mashi, Ephreli njll. kuze kube nguDisemba kuhlangene.



5. Khetha iseli okuzokhonjiswa kulo ingqikithi yamanani wenkathi eshiwo, bese uyikhetha. Bese uchofoza isithonjana "Faka umsebenzi". Itholakala kwesobunxele sebha yefomula ngakwesokunene sensimu lapho kuboniswa khona amagama amaseli.



6. Ewindini elivuliwe Umsebenzi Wizards hambisa esigabeni "Izibalo". Lapho, sikhetha igama ISUM. Chofoza inkinobho "Kulungile".



7. Ukulandela lesi senzo, iwindi lokuphikisana ngopharetha liqala ISUMUmsebenzi okuwukuphela kwakhe ukukala amanani akhonjisiwe. I-syntax yalomsebenzi ilula kakhulu:

   = SUM (inombolo1; inombolo2; ...)

   Ngokuvamile, inani lokuphikisana lingafinyelela inani 255. Kepha zonke lezi zingxabano ziyafana. Zifanekisela inombolo noma izixhumanisi zeseli okule nombolo lelo. Bangasebenza futhi njengefomula eyakhelwe ngaphakathi ebala inombolo oyifunayo noma ekhombisa ikheli lezinto zeshidi lapho litholakala khona. Kukule khwalithi yomsebenzi owakhelwe ngaphakathi lapho opharetha azosetshenziswa yithi E-INDIA kuleli cala.

   Setha isikhombisi esigangeni "Inombolo1". Bese uqhafaza isithonjana ngesimo sonxantathu olungene ngaphakathi kwesokudla kwenkambu yegama. Uhlu lwemisebenzi esetshenziswa kakhulu kamuva luyakhonjiswa. Uma phakathi kwabo kukhona igama "INDIA", bese uchofoza ngokushesha kuyo ukuya kuwindi lokuphikisana lalomsebenzi. Kepha kungenzeka ukuthi ngeke uluthole kulolu hlu. Kulokhu, chofoza igama "Ezinye izinto ..." ezansi kohlu.



8. Iwindows elijwayelekile liyaqala. Umsebenzi Wizards. Siqhubekela esigabeni Izinkomba kanye nokufika bese ukhetha igama le-opharetha lapho E-INDIA. Ngemuva kwalesi senzo, chofoza inkinobho "Kulungile" phansi kwewindi.



9. Ukuqaliswa Kwe-Window Ye-Operator Argument E-INDIA. Ensimini Isixhumanisi Seseli khombisa ikheli lezinto zeshidi eliqukethe igama lenyanga yokuqala yebanga okuhloswe ngalo ukubala inani. Uyacelwa ukuthi uqaphele ukuthi kuleli cala awudingi ukucaphuna isixhumanisi, ngoba kule ndaba ikheli ngeke kube izixhumanisi zeseli, kodwa okuqukethwe kulo, okuvele kunefomethi yombhalo (igama Mashi) Insimu "A1" shiya singenalutho, ngoba sisebenzisa uhlobo olujwayelekile lokuqondisa ukuqanjwa.

   Ngemuva kokuthi ikheli selikhonjisiwe endle, musa ukushesha ukucindezela inkinobho "Kulungile", ngoba lokhu kungumsebenzi odaliwe, nezenzo zawo zihlukile ku-algorithm ejwayelekile. Chofoza igama ISUM emugqeni wefomula.



10. Ngemuva kwalokho, sibuyela ewindini lokuphikisana ISUM. Njengoba ubona, enkundleni "Inombolo1" opharetha usevele ubonisiwe E-INDIA nokuqukethwe kwayo. Sifaka ikhesa ensimini efanayo ngokushesha ngemuva komlingiswa wokugcina kurekhodi. Beka uphawu lwekholoni (:) Lolu phawu lisho uphawu lwekheli lohla lwamaseli. Ngaphezu kwalokho, ngaphandle kokususa isikhombisi endle, chofoza futhi isithonjana esesikhathini sikunxantathu ukukhetha imisebenzi. Lesi sikhathi ohlwini lwabasebenzisi abasanda kusetyenziswa "INDIA" kumele kube khona, ngoba sisanda kusetyenziswa lesi sici. Sichofoza igama.



11. Iwindi lokuphikisana opharetha liyavula futhi E-INDIA. Sifaka insimu Isixhumanisi Seseli ikheli lezinto eziseshidi lapho igama lenyanga eqeda isikhathi sokukhokha likhona. Futhi, izixhumanisi kufanele zifakwe ngaphandle kwamaphuzu wokucaphuna. Insimu "A1" shiya kungenalutho futhi. Ngemuva kwalokho chofoza inkinobho "Kulungile".



12. Njengoba ubona, ngemuva kwalezi zenzo, uhlelo lubala futhi lubonise umphumela wokungeza imali yenkampani yesikhathi esichaziwe (Mashi - Meyi) entweni ebekhethiwe ngaphambili lapho ifomula ngokwayo itholakala khona.



13. Uma siguqula kumaseli lapho kufakwa khona amagama wezinyanga zokuqala nezokuphela kwesikhathi sokukhokha, kwabanye, ngokwesibonelo, NgoJuni futhi Novemba, khona-ke umphumela uzoshintsha ngokufanele. Inani lemali yesikhathi esichaziwe lizongezwa.

Isifundo: Ungayibala kanjani inani ku-Excel

Njengoba ubona, naphezu kweqiniso lokuthi umsebenzi uyasebenza E-INDIA ayikwazi ukubizwa ngokuthi iyenye yezithandwa kakhulu phakathi kwabasebenzisi, kepha-ke, kuyasiza ukuxazulula imisebenzi yokuhlukahluka kobunzima ku-Excel kulula kakhulu kunokuba ingenziwa kusetshenziswa amanye amathuluzi. Ngaphezu kwakho konke, le opharetha iyasebenziseka amafomula eziyinkimbinkimbi lapho kuyingxenye yesisho. Kepha noma kunjalo, kufanele kuphawulwe ukuthi wonke amandla opharetha E-INDIA kunzima ukuqonda. Lokhu kumane kuchaze ukuthandwa okuphansi kwalomsebenzi olusizo phakathi kwabasebenzisi.