Omunye wemisebenzi ejwayelekile eyenziwa lapho usebenza ngamatrices ukuphindaphinda komunye wabo ngomunye. Uhlelo lwe-Excel luyisisombululo esinamandla se-tular, esakhiwe, kufaka phakathi ukusebenza kumatrices. Ngakho-ke, unamathuluzi akuvumela ukuba uwandise ndawonye. Ake sithole ukuthi lokhu kungenziwa kanjani ngezindlela ezihlukahlukene.
Inqubo Yokuphindaphinda Matrix
Masinyane kufanele ngithi akuwona wonke amamatiriyali anganwetshanzana, kodwa kuphela labo abahlangabezana nesimo esithize: inani lamakholomu womunye we-matrix kufanele alingana nenani lemigqa yenye futhi ngokuphambene nalokho. Ngaphezu kwalokho, ukutholakala kwezinto ezingenalutho kumatrices kukhishwe. Kulokhu, futhi, yenza umsebenzi odingekayo ngeke usebenze.
Azikho izindlela eziningi zokwandisa ama-matrices ku-Excel - kuphela amabili. Futhi bobabili baxhunywe nokusetshenziswa kwe-Excel imisebenzi eyakhelwe ngaphakathi. Ake sihlole ngokuningiliziwe ngayinye yalezi zinketho.
Indlela 1: umsebenzi MUMMY
Inketho elula futhi ethandwa kakhulu phakathi kwabasebenzisi ukusebenzisa lolu msebenzi. Umama. I-Operator Umama ibhekisela eqenjini lemisebenzi yamathematika. Umsebenzi wakhe nje ukuthola umkhiqizo wamathuluzi amabili. I-Syntax Umama inefomu elilandelayo:
= MUMNAGE (i-array1; i-array2)
Ngakho-ke, lo opharetha unezimpikiswano ezimbili, ezibhekisela emigqeni yamatrices amabili okufanele wande.
Manje ake sibone ukuthi umsebenzi usetshenziswa kanjani. Umama ngesibonelo esithile. Kunamatrices amabili, inani lemigqa yalo elilodwa elihambisana nenamba yamakholomu kwenye futhi ngokuphambene nalokho. Sidinga ukwandisa lezi zakhi ezimbili.
- Khetha ibanga lapho umphumela wokubuyabuyelela uzoboniswa khona, uqala kusuka kuseli eliphezulu elingakwesokunxele. Ubukhulu balolu bubanzi kufanele buhambelane nenani lemigqa ematriki yokuqala kanye nenani lamakholomu okwesibili. Sichofoza kusithonjana "Faka umsebenzi".
- Kuvunyelwe Umsebenzi weWebhu. Hambisa ukuvimba "Isibalo", chofoza igama "UMUMNOZH" bese uchofoza inkinobho "Kulungile" phansi kwefasitela.
- Ifasitela yeziphakamiso zomsebenzi odingekayo uzosungulwa. Kuleli festile kunezinkambu ezimbili zokungena amakheli wezinhlamvu zamatrix. Faka i-cursor ensimini "I-Array1"futhi, ubambe inkinobho yegundane lesokunxele, ukhethe yonke indawo ye-matrix yokuqala eshadini. Emva kwalokho, izixhumanisi zayo zizoboniswa endle. Faka i-cursor ensimini "Massiv2" futhi ngokufanayo ukhethe ububanzi besigaba sesibili.
Emva kokubili izingxabano zingenwe, ungasheshi ukucindezela inkinobho "Kulungile"njengoba sisebenzelana nomsebenzi ohlangene, okusho ukuthi ukuthola umphumela oqondile, ukhetho olujwayelekile lokuqedela umsebenzi no-opharetha ngeke lusebenze. Lo opharetha akuhloswe ukubonisa umphumela kuseli elilodwa, ngoba liwukhombisa ebangeni lonke eshadini. Ngakho esikhundleni sokucindezela inkinobho "Kulungile" Cindezela inhlanganisela yenkinobho Ctrl + Shift + Faka.
- Njengoba ungabona, ngemuva kwalolu hlu olukhethiwe lugcwele idatha. Lona umphumela wokuphindaphinda izigaba zamatriki. Uma ubheka ibha yefomula, ngemuva kokukhetha noma yiziphi izakhi zalolu hlu, sizobona ukuthi ifomula ngokwalo ihlanganiswe ngamabhontshisi angama-curly. Lesi isici somsebenzi wokuhlanganisa, okungeziwe ngemuva kokucindezela inhlanganisela yekhiye Ctrl + Shift + Faka ngaphambi kokukhipha umphumela kushidi.
Isifundo: Umsebenzi we-MUMNAGE ku-Excel
Indlela 2: Ukusebenzisa ifomula ye-Compound
Ngaphezu kwalokho, kunenye indlela yokwandisa izibalo ezimbili. Kuyinkimbinkimbi kunokwedlule, kodwa futhi kufanele ukhulume njengenye indlela. Le ndlela ihilela ukusetshenziswa kwefomula yamakhemikhali amaningi, azoba nomsebenzi SUMPRODUCT futhi ihlanganiswe kuyo njengengxabano yomqhubi IZITHUTHUKO.
- Ngalesi sikhathi, sikhetha kuphela isici esingaphezulu kwesokunxele sezingqamuzana zamaseli angenalutho kushidi, esikulindele ukusebenzisa ukubonisa umphumela. Chofoza kusithonjana "Faka umsebenzi".
- Umsebenzi weWebhu iqala Ukuthuthela ebhokisini lama-opharetha "Isibalo"kodwa manje sikhetha igama SUMPRODUCT. Sichofoza inkinobho "Kulungile".
- Ukuvula iwindi lempikiswano lomsebenzi ongenhla kwenzeka. Lo opharetha uklanyelwe ukwandisa izigaba ezahlukene komunye nomunye. I-syntax yayo ilandelayo:
= I-SUMPRODUCT (i-array1; i-array2; ...)Njengengxabano evela eqenjini "Uhlu" ukubhekisela ebangeni elithile okumele landiswe lisetshenziswe. Ingqikithi yeziphakamiso ezinjalo kuya ku-255 zingasetshenziswa. Kodwa kithi, njengoba sibhekene namatrices amabili, sidinga nje izingxabano ezimbili.
Faka i-cursor ensimini "Massive1". Lapha kuzodingeka ufake ikheli lomugqa wokuqala we-matrix yokuqala. Ukuze wenze lokhu, ubambe inkinobho yegundane lesokunxele, udinga nje ukuyikhetha eshadini ene-cursor. Lapha izixhumanisi zalolu hlu zizoboniswa ensimini ehambelana nefasitela yeziphakamiso. Ngemuva kwalokho, kufanele ulungise izixhumanisi zokuxhumana eziholele kukholomu, okungukuthi, lezi zixhumanisi kufanele zenziwe ngokuphelele. Ukuze wenze lokhu, ngaphambi kwezinhlamvu ezenzakalweni ezifakiwe ensimini, setha uphawu lwe-dollar ($). Ngaphambi kwezixhumanisi eziboniswe kumanani (imigqa), lokhu akufanele kwenziwe. Ngaphandle kwalokho, ungakhetha yonke inkulumo endle bese ucindezela inkinobho yomsebenzi kathathu F4. Kulesi simo, kuphela izixhumanisi zamakholomu ziyoba ngokuphelele.
- Emva kwalokho setha isikhangiso ensimini "Massiv2". Ngalokhu kuxabana kuyoba nzima kakhulu, ngoba ngokuvumelana nemithetho yokuphindaphindiwe kwe-matrix, i-matrix yesibili idinga ukuba "ifakwe". Ukuze wenze lokhu, sebenzisa umsebenzi osikiwe IZITHUTHUKO.
Ukuze uye kuso, chofoza isithonjana ngendlela yesonxantathu, eqondiswa ngecala elibukhali eliphansi, elise kwesokunxele kwibha yefomula. Uhla lwefomula elisanda kusetshenziselwa luvulwa. Uma uthola kulo igama "IZITHUTHUKO"ke uchofoze kuso. Uma ususebenzise lo mqhubi isikhathi eside noma ungakaze uyisebenzise nhlobo, ngeke uthole igama elichazwe kulolu hlu. Kulokhu, chofoza into. "Ezinye izici ...".
- Iwindi elijwayele kakade livuleka. Amakhosi omsebenzi. Lesi sikhathi sithuthela esigabeni "Izixhumanisi nezigaba" bese ukhetha igama "IZITHUTHUKO". Chofoza inkinobho "Kulungile".
- Iwindi lempikiswano yokusebenza iqalisiwe. IZITHUTHUKO. Lo opharetha uhloselwe ukuhambisa amatafula. Okusho ukuthi, ukubeka kalula, kususa amakholomu nemigqa. Yilokho esikudingayo ukukwenza ngokuphikisana kwesibili ko-opharetha. SUMPRODUCT. Umsebenzi we-syntax IZITHUTHUKO okulula kakhulu:
= TRANSPORT (i-array)Okungukuthi, ukuphikisana okuphela kwalokhu opharetha kubhekisela ohlwini olufanele "lufakwe". Kunalokho, kithi, hhayi ngisho nendawo yonke, kodwa kuphela kukholomu yayo yokuqala.
Ngakho, setha isikhangiso ensimini "Uhlu" bese ukhetha ikholomu yokuqala ye-matrix yesibili eshadini inkinobho yegundane lesokunxele egcinwe phansi. Ikheli lizovela ensimini. Njengokwesikhashana esidlule, lapha, futhi, kudingeka wenze izixhumanisi ezithile ngokuphelele, kodwa manje akuzona izixhumanisi zamakholomu, kodwa amakheli emigqa. Ngakho-ke, sibeka isibonakaliso se-dollar phambi kwezinombolo kusixhumanisi esiboniswa ensimini. Ungakhetha futhi yonke inkulumo bese uchofoza kabili ukhiye F4. Ngemuva kokuthi izakhi ezidingekayo zaqala ukuba nezindawo eziphelele, ungacindezeli inkinobho "Kulungile", kanye nendlela eyedlule, sebenzisa inhlanganisela eyinhloko Ctrl + Shift + Faka.
- Kodwa ngalesi sikhathi, asigculanga uhlu olulodwa, kodwa kuphela iseli elilodwa, esasibiwe ngaphambili uma sishayela Amakhosi omsebenzi.
- Sidinga ukugcwalisa idatha ngobukhulu obufanayo obufanayo njengendlela yokuqala. Ukuze wenze lokhu, kopisha ifomula etholakalayo esitokisini kuya kulelo elinganayo, elizolingana nenani lemigqa yesibalo sokuqala nenombolo yamakholomu wesibili. Esimeni sethu, sithola imigqa emithathu namakholomu amathathu.
Ukukopisha, masisebenzise uphawu lokugcwalisa. Hambisa isikhombisi ekhoneni elingaphansi kwesokudla leseli lapho ifomula itholakala khona. I-cursor iguqulwa ku-cross cross. Lona uphawu lokugcwalisa. Bamba inkinobho yesinxele yesinxele bese uhudula isikhombisi ngaphezu kobubanzi obuphezulu. Iseli yokuqala kanye nefomula kufanele ibe yingxenye ephezulu kwesokunxele se-array.
- Njengoba ungabona, ibanga elikhethiwe ligcwele idatha. Uma siwaqhathanisa nomphumela esiwutholile ngokusebenzisa opharetha Umama, khona-ke sizobona ukuthi amanani afana ngokuphelele. Lokhu kusho ukuthi ukuphindaphinda kwamatrices amabili kulungile.
Isifundo: Ukusebenza nama-arrays ku-Excel
Njengoba ungabona, naphezu kokuthola umphumela olinganayo, sebenzisa lo msebenzi ukuwandisa amatrices Umama kulula kakhulu kunokusebenzisa ifomula ye-compound ye-opharetha ngenhloso efanayo SUMPRODUCT futhi IZITHUTHUKO. Noma kunjalo, lokhu okunye futhi akukwazi ukushiywa kungalindelekile lapho uhlola wonke amathuba okuphindaphinda amatrikhi ku-Microsoft Excel.
