Uyini umsebenzi wesimboli se-@ ku-Excel kanye ne-inclicte intersection?

Informatec Digital » Izinsiza » Uyini umsebenzi wesimboli se-@ ku-Excel kanye ne-inclicte intersection?

Uma usebenzisa i-Excel nsuku zonke futhi ngokuzumayo uqale ukubona uphawu lwe-@ kumafomula akho , ungesabi: akuyona iphutha noma into engavamile, yi-implicit intersection operator. Lolu phawu oluncane selube yisihluthulelo, ikakhulukazi njengoba ama-dynamic arrays ethulwa ku-Excel 365 kanye ne-Excel 2021.

Ngemuva kwalowo mfanekiso kulele i-logic i-Excel ebilokhu iyisebenzisa buthule iminyaka eminingi ukuze yehlise amabanga nama-array abe yinani elilodwa . Ushintsho luwukuthi le logic ayisafihliwe, futhi uhlelo lukukhombisa ngokusobala ukuthi le mpikiswano yenzeka kuphi. Ukuyiqonda kahle kuzokusiza ukulawula indlela amafomula akho abalwa ngayo, ugweme amaphutha okugcwala, futhi ekugcineni, ube namaspredishithi ahlanzekile kakhulu futhi abikezelwayo.

Kuyini ukuhlangana okungacacile ku-Excel?

Lokho okubizwa ngokuthi i-infict intersection umthetho i-Excel ewusebenzisayo ukusuka "kumanani amaningi angenzeka" iye "kweyodwa kuphela" lapho ifomula ibhekisela kububanzi noma ku-array, kodwa iseli lingabonisa umphumela owodwa kuphela. Ngamanye amazwi, i-Excel kufanele inqume ukuthi yiliphi inani elithile okufanele ilisebenzise kuzo zonke lezo ezinikezwa yi-range noma ku-array.

Sekuyiminyaka eminingi, lesi sinqumo senziwa ngaphandle kokuba umsebenzisi aqaphele noma yini ekhethekile: ubhale ifomula bese i-Excel yenza izibalo zayo zangaphakathi, isebenzisa i-inclic intersection noma nini lapho kudingeka. Ngokufika kwama-dynamic arrays, lokhu kuziphatha kwadingeka kucaciswe, futhi yilapho i- @ operator ingena khona njengesibonakaliso se-inclic intersection.

I-logic ngemuva kwe-excel implicit intersection yakudala ingafingqwa kanje: lapho ifomula ikhiqiza amanani amaningi angaba khona, i-Excel iwanciphisa ngokuzenzakalelayo abe yinani elilodwa uma iseli lingaklanyelwe ukuphatha imiphumela eminingi. Lena indlela yokuphepha yokuqinisekisa ukuthi amafomula ayaqhubeka nokusebenza endaweni lapho iseli ngalinye, ngokomthetho, libonisa inani elilodwa kuphela.

Ezinguqulweni zanamuhla ezifana ne-Microsoft 365, amafomula "angagcwala" futhi agcwalise amaseli amaningi ngesikhathi esisodwa, kodwa i-Excel isadinga indlela yokwazi ukuthi sikufuna nini lokho kuziphatha okuguqukayo nokuthi sikufuna nini. Yingakho uphawu lwe-@ lusetshenziswa ukuphoqa inani elilodwa ukuthi libuyiselwe , kugcinwa i-inclicte intersection logic uma kudingeka.

Indlela i-incript intersection esebenza ngayo ku-Excel 2019 kanye nezinguqulo zangaphambilini

Ezinguqulweni zangaphambi kwama-array aguquguqukayo (isibonelo, i-Excel 2019 nangaphambilini), i-inclic intersection kwakuyindlela ejwayelekile yokuziphatha . Yayisetshenziswa njalo noma ngabe awuzange wenze lutho olukhethekile. Noma nini lapho ifomula isebenza ngama-range noma ama-array, i-Excel yayinquma ukuthi yiliphi inani okufanele ilisebenzise ngokwemithetho yangaphakathi ethile.

Lena kwakuyimithetho eyisisekelo i-Excel eyayiyisebenzisa ngaphandle kokwazisa umsebenzisi:

• Uma umphumela wawuyinani elilodwa, lelo nani labuyiselwa ngqo, ngaphandle kwesidingo sendawo ekhethekile yokuhlangana.
• Uma ifomula ibhekisela kububanzi (isibonelo, A1:A10), i-Excel isebenzise inani leseli ebangeni elihambisana nomugqa (noma ikholomu) lapho ifomula yayitholakala khona.
• Uma kusetshenziswe i-matrix Kusukela kumanani amaningana, i-Excel ithathe isici esitholakala ekhoneni eliphezulu kwesobunxele lalolo hlu njengomphumela.

Cabanga ubhala ifomula efana ne-=A1:A10 kuseli emgqeni 5. Kulezo zinguqulo "ezindala" ze-Excel, ubungeke ubone lutho olungavamile : inani lika-A5 lizoboniswa nje, ngoba liyi-intersection phakathi kobubanzi buka-A1:A10 nomugqa lapho ifomula itholakala khona . Lokho kwakuyi-intersection engacacile esebenza.

Esinye isibonelo esivamile: uma ufaka i-=B2:B5*C2:C5 kuseli, i-Excel isebenzisa kuphela amanani ahambisana nomugqa ofanayo nefomula . Uthola umphumela owodwa, futhi ukuze uthole eminye kufanele uhudule ifomula phansi. Ngokuzenzakalelayo, uhlelo "alwandisi" yonke imiphumela engenzeka kwamanye amaseli.

Uma ufuna ukuya phambili futhi usebenze ne-Excel nalo lonke uhla ngesikhathi esisodwa, kwadingeka usebenzise amafomula e-array yakudala: ukhethe uhla lokukhipha, wabhala ifomula, futhi waqinisekisa nge -Ctrl + Shift + Enter . Le nhlanganisela yatshela i-Excel ukuthi ingasebenzisi i-inclic intersection, kodwa ibale inkulumo njenge-array ephelele bese ibuyisa imiphumela eminingi kumaseli amaningana.

Ukuhlangana okungabonakali ku-Excel 365 kanye nezinguqulo ezinama-array ashukumisayo

Ngokwethulwa kwama -dynamic arrays ku-Microsoft 365 kanye ne-Excel 2021 , injini yokubala yashintsha ifilosofi yayo. Manje, lapho ifomula ingabuyisa imiphumela eminingi, umthetho uphambene nalokho: I-Excel "iyawakhipha" futhi iwasabalalise kumaseli amaningana ngokuzenzakalelayo.

Lokhu kuziphatha kwaziwa ngokuthi i-spill . Uma ubhala ifomula ebuyisela uhlu lwezinto eziningi, uzobona ibhulokhi lamaseli ligcwala futhi indawo ethintekile igqanyiswa ngokubonakalayo ngomngcele oluhlaza okwesibhakabhaka. Akusadingeki usebenzise i-Ctrl+Shift+Enter yakudala ukuze uthole imiphumela eminingi.

Kulo modeli omusha, uma ufuna ukuphinda indlela endala yokusebenza (ukubala inani elilodwa kuphela ngomugqa noma ikholomu), udinga ukutshela i-Excel ngokusobala. Lokhu kufezwa kusetshenziswa i- @ operator, evula indlela engaqondakali yaleyo ngxenye yefomula.

Ngamanye amazwi: ngaphambilini, bekufanele "uphoqe" i-Excel ukuthi ibalwe ngama-array aphelele; manje sekufanele "uphoqe" i-Excel ukuthi iziphathe ngendlela yendabuko lapho isisho sikhiqiza imiphumela engaphezu kweyodwa. Uphawu lwe-@ luphatha lolu shintsho : uma ulufaka, uthola inani elilodwa kuphela; uma ulususa, ifomula ingachichima.

Imininingwane ebalulekile ukuthi amafomula abhalwe ezinguqulweni ezindala futhi avulwe ku-Excel 365 angabonakala kuzimpawu (@) ongazange uzifake ngempela. Lokhu akubangelwa ukuthi ukuziphatha kwefomula kushintshile; kunalokho, i-Excel manje ikukhombisa ngokusobala ukuthi le mpikiswano engacacile , eyayifihliwe ngaphambilini, yayisenzeka kuphi.

Indima yesimboli se-@ njengomqhubi we-intersection ongabonakali

Uphawu lwe-@, ngokobuchwepheshe, luyi- inclic implict intersection operator olimini olusha lwefomula ye-Excel. Lwafakwa kanye nama-dynamic array ukuze kuboniswe ngokucacile amaphuzu lapho i-Excel inciphisa khona ububanzi noma i-array ibe yinani elilodwa.

I-syntax evamile ilula kakhulu: ubeka uphawu lwe-at (@) ngaphambi nje kobubanzi, uhlu, noma umsebenzi ongabuyisa amanani amaningi . Isibonelo, ungathola amafomula afana ne- =@A1:A10 noma i- =@INDEX(A1:A10,B1). Kuzo zombili izimo, i- @ ikhombisa ukuthi, yize umphumela ongaba khona uyiqoqo lamanani, i-Excel kufanele ibuyisele kuphela inani elihambisana nendawo yokuhlangana (noma isici esiphezulu kwesobunxele uma kuyi-array emsulwa).

Uma usebenza ngamathebula ahlelekile, lo opharetha uvela nasezinkulumweni ezifana nokuthi =. Lapho, umlayezo uyafana: uthi ifomula kufanele isebenzise inani elivela kuleyo kholomu emgqeni ofanayo nefomula , hhayi ikholomu yonke.

Ngaphakathi, ulimi lwefomula yesimanje ye-Excel lufana kakhulu nolwangaphambilini, kodwa manje lusebenzisa uphawu lwe-@ ukuphawula izindawo lapho i-inclusive intersection yayisetshenziswa khona buthule ngaphambilini . Lokhu kusho ukuthi uma uvula ifayela elidala kunguqulo enama-array aguquguqukayo, ungabona la ma-insection angabonakali ngaphambilini edwetshwe.

Ngaphezu kwalokho, uma udala amafomula amasha ku-Excel 365, unganquma ngobuhlakani ukuthi ufuna ukuziphatha kwe-array kuphi nokuthi ukhetha ukuqhubeka kuphi usebenzisa i-classic single-result logic , ngokumane ungeze noma ususe uphawu lwe-@ ezindaweni ezibalulekile.

Izibonelo ezisebenzayo ze-@ operator kumafomula

Ukuze uqonde kangcono indima yesimboli se-at (@), kuyasiza ukubukeza ukuthi amanye amafomula ajwayelekile aguqulwa kanjani uma evulwa ku-Excel ngama-array aguquguqukayo. Amaningi ahlala engashintshi; nokho, amanye aboniswa ngesimboli se-intersection esingabonakali phambi kwawo.

Ezinye izibonelo ezibalulekile zingaba yilezi:

• =ISAMBA(A1:A10) → =ISAMBA(A1:A10)
  Akukho shintsho, ngoba i-SUM yakhelwe ukusebenza ngama-range nama-array. Ukusebenzisa i-inclic intersection ku-agumenti yayo akunamsebenzi: umsebenzi usuvele ulindele amanani amaningi.
• =A1+A2 → =A1+A2
  Uphawu luka-No at luvela lapha futhi, njengoba ifomula ihlobene kuphela namanani ngamanye, hhayi amabanga aphelele. Akukho kuhlangana okungacacile okungenzeka.
• =A1:A10 → =@A1:A10
  Kulesi simo, umqhubi uyavela. I-Excel iyaqonda ukuthi kungenzeka ukuhlangana okungacacile nokuthi kumele ibuyisele inani lobubanzi elihambisana nomugqa lapho ifomula itholakala khona.
• =ÍNDICE(A1:A10;B1) → =@ÍNDICE(A1:A10;B1)
  Umsebenzi we-INDEX ungabuyisa ububanzi obuphelele noma i-array uma kusetshenziswa izimpikiswano ezithile (isibonelo, uma u-0 echazwe emgqeni noma kukholomu). Ngakho-ke, i-Excel imaka ithuba lokuhlangana okungacacile kokukhipha kwe-array okungenzeka.
• =DESREF(A1:A2;1;1) → =@DESREF(A1:A2;1;1)
  I-OFFSET ingakhiqiza uhla lwamaseli amaningi. Uma lokhu kwenzeka, uphawu lwe-@ luqinisekisa ukuthi i-Excel ibuyisa inani elilodwa, isebenze ukuhlangana okungacacile phezu kobubanzi obubuyisiwe.
• =MYUDF() → =@MYUDF()
  Imisebenzi echazwe ngumsebenzisi (ama-UDF) ingahlelwa ukuze ibuyisele ama-array. Uma lokho kwenzeka, i-Excel isebenzisa uphawu lwe-@ ukukhombisa ukuthi ifomula yokuqala ithembele endaweni ehlanganisiwe ukuze ikhiqize umphumela owodwa kuphela.

Njengoba ubona, ukuba khona kophawu lwe-@ akusho ukuthi i-logic yefomula iyashintsha ngobusuku obubodwa; imane nje yenza kubonakale ukuziphatha obekwenzeka ngemuva kwezigcawu ngaphambilini ngaphandle kokwazi kwakho . Lokhu kukusiza ukuthi uqonde kangcono ukuthi kungani ifomula ibuyisa inani elilodwa kuphela ngisho nalapho isebenza ngama-range amakhulu impela.

Ingabe uphawu lwe-@ lungasuswa kufomula?

Ezimweni eziningi ungasusa umqhubi we-@ ngaphandle kokushintsha ukubala, kodwa hhayi njalo. Konke kuncike ekutheni ingxenye yefomula engakwesokudla kophawu lwe-@ ibuya ini : kungakhathaliseki ukuthi iyinani elilodwa, noma ingabe ingaguqulwa ibe ububanzi noma uhlu.

Amathuba ayisisekelo yilawa:

• Uma inkulumo ibuyisa inani elilodwa Ngokwemvelo, ukususa uphawu lwe-@ ngeke kube nomthelela emphumeleni. Kuleso simo, ukuhlangana okucatshangelwe akunezeli lutho, ngoba akukho lutho "oluzoncishiswa."
• Uma inkulumo ibuyisela ububanzi noma uhluUkususa uphawu lwe-@ kungabangela ukuthi ifomula igcwale kakhulu, kugcwaliswe amaseli aseduze ngawo wonke amanani avela kumphumela we-array.

Ezinguqulweni zanamuhla, lokhu kugcwala kuyinto evamile futhi ngokuvamile kuyafiseleka. Kodwa qaphela: uma uvula ifayela kunguqulo ye-Excel engasekeli ama-array aguquguqukayo, ifomula eyayisebenzisa uphawu lwe-@ ngaphambilini kodwa engasasebenzisi ingase ibe ifomula ye-array yakudala , efakwe kuma-braces ajikajika {} ukuze kugcinwe ukuvumelana kokubala.

Uma i-Excel iguqula leyo fomula ibe yinguqulo endala, yenza kanjalo ngokunembile ukuze ivimbele ukuhlangana okungacacile ukuthi kuphinde kuqaliswe futhi futhi kushintshe umphumela. Lokhu kulondoloza ukuziphatha okwakunakho ekuqaleni ku-Excel ngama-array aguquguqukayo.

Ngakho-ke, ngaphambi kokususa ngokungahleliwe zonke izimpawu ze-at ozibonayo, kungumqondo omuhle ukubukeza ngokucophelela ukuthi ifomula ngayinye yenzani nokuthi ingabe isebenza ngama-range noma ama-matrices amakhulu kunalokho okubonakala sengathi ayasebenza.

I-Excel ilufaka nini ngokuzenzakalelayo uphawu lwe-@?

I-Excel ibeka ngokuzenzakalelayo i-incript intersection operator ikakhulukazi uma ithola amafomula endabuko avuliwe endaweni enama-array aguquguqukayo . Umgomo ukukukhombisa ngokusobala ukuthi lezo zindlela ezingabonakali zenzeke kuphi kumodeli endala.

Lokhu kwenzeka ikakhulukazi ngemisebenzi ekwazi ukubuyisela amabanga noma ama-array amaseli amaningana, isibonelo:

• INDEX, ikakhulukazi uma enye yezimpikiswano zabo zesikhundla ingu-0.
• OFFSET, okuvame ukubuyisa ububanzi obushintshiwe obunamaseli amaningi.
• Imisebenzi echazwe ngumsebenzisi (ama-UDF) yakhelwe ukubuyisela ama-matrices.

Ezimweni eziningi zalezi, ifomula yokuqala yabhalwa kucatshangelwa imodeli yakudala, lapho iseli ngalinye lingaqukatha inani elilodwa kuphela . I-Excel ixazulule ukungqubuzana okungenzeka kusetshenziswa i-inclic intersection ngaphandle kokukutshela. Uma uvula lelo fayela elifanayo enguqulweni enama-dynamic arrays, uhlelo "lwembula" leyo intersection ngokungeza uphawu lwe-@ ezindaweni ezidingekayo.

Nokho, kunezimo ezicacile. Isibonelo, uma ifomula isebenzisa umsebenzi owamukela ama-array noma ama-range njengokufaka, njenge-SUM noma i-AVERAGE, i-Excel ayidingi ukubeka uphawu lwe-@ ngaphambi kwalezo zimpikiswano: umsebenzi usuvele ulindele ama-range aphelele futhi uwaphatha ngendlela efanele ngaphandle kwesidingo sezindawo ezengeziwe zokuhlangana.

Ngamafuphi, uma ubona uphawu lwe-at ongakhumbuli uluthayipha, kungenzeka kakhulu ukuthi i-Excel yalufaka lapho uvula incwadi yokusebenzela endala ukuze ikusize uqonde kahle ukuthi lokho kwehla kwamanani kwenzeka kuphi ezingeni lomugqa noma lekholomu.

Ukusebenzisa i-opharetha ethi @ kumafomula amasha nahlanganisiwe

Uma uqala ukudala amafomula amasha ku-Excel ngama-array aguquguqukayo, ungahlanganisa ukubalwa kwama-array "ahlanzekile" nama-intersection angacacile . Kodwa-ke, izinguqulo ezindala ze-Excel azizange ziphathe lezi zinhlobo zamafomula axubile, okwenza kudingeke ukusetshenziswa kwendlela yokuhambisana.

Uma ubhala into efana ne-=A1:A10+@A1:A10, uhlanganisa ingxenye ebalwa njenge-array (A1:A10) nenye ingxenye ephoqa i-inclic intersection (@A1:A10). I-Excel 365 iyakubona lokhu futhi ingaphakamisa inguqulo ehlukile yefomula esebenzisa i-inclic intersection kuphela noma ukubalwa kwe-array kuphela, igwema ukuhlanganiswa okungaqondakali ezinguqulweni ezindala ze-Excel.

Uma ukhetha ukungasinaki isincomo bese unamathela kufomula exubile, akukho okuzokwenzeka uma nje uqhubeka nokusebenzisa inguqulo yesimanje. Kodwa-ke, uma kamuva uvula leyo ncwadi kuhlelo olungaphambi kwama-dynamic arrays, cishe uzobona into efana ne- =A1:A10+_xlfn.SINGLE(A1:A10) , lapho i-@ operator iba yi-call kumsebenzi we-compatibility marker SINGLE.

Ezinguqulweni ezindala ze-Excel, lapho uhlola ifomula ene-_xlfn.SINGLE(), ngokuvamile uzothola amaphutha afana ne-#NAME? noma i-#VALUE!, ngoba uhlelo aluqapheli umsebenzi noma indlela exubile. Lokhu kuyinkomba ecacile yokuthi usebenzisa izakhiwo ezenzelwe isizukulwane esisha sama-array ashukumisayo.

Ngakho-ke, uma usebenza ngamafayela azojikeleza phakathi kwezinguqulo ezahlukene, kubalulekile ukuqaphela kakhulu ukuthi i-@ operator ithinta kanjani ukuhambisana nokuthi ucabangele ukuthi kungcono yini ukwenza amafomula abe lula noma ukugcina inguqulo efanayo evumelaniswe nama-Excels amadala.

Uphawu lwe-@ kumathebula e-Excel kanye nezinkomba ezihlelekile

Esikhathini eside ngaphambi kokuba kuqalwe ama-dynamic array, uphawu lwe-@ lwase lusetshenziswa kakade ezikhombweni ezihlelekile kumathebula e-Excel . Uma uke wasebenza ngamathebula (Faka > Ithebula), cishe uke wabona amafomula abukeka kanje.

Kulo mongo, uphawu lwe-at (@) lubonisa ukuthi ifomula ihlolwa ezingeni lomugqa . Okusho ukuthi, kukholomu ecacisiwe, ifomula izosebenzisa inani elivela kumugqa oqukethe ifomula, hhayi lonke ikholomu. Isibonelo, isisho esifana nesithi =* sibala umkhiqizo womugqa osebenzayo kuphela, bese i-Excel ikopisha ngokuzenzakalelayo i-logic kwezinye imigqa etafuleni.

Uma ushiya uphawu lwe-@ bese ubhekisela ngqo kusihloko sekholomu, i-Excel ihumusha lokhu njengokusho ukuthi ufuna ukusebenza nekholomu yonke, okungaholela ekugcwaleni ngokweqile noma emaphutheni uma umphumela ungangeni ngaphakathi kobubanzi obutholakalayo. I-opharetha ye-@ iklanyelwe ngokunembile ukugcina ububanzi bokubala bukhawulelwe kumugqa ohambisanayo.

Uma ubhala lezi zinhlobo zamafomula ezinguqulweni zanamuhla, i-Excel iyaqhubeka nokusebenzisa i-syntax efanayo ngoba ihambisana kahle nomqondo wokuhlangana okungabonakali: imayelana nokukhetha inani elivela kububanzi (ikholomu yethebula) elihambisana nomugqa lapho ifomula itholakala khona.

Lokhu kuqhubeka kusho ukuthi uphawu lwe-at manje lunencazelo ephindwe kabili: ngakolunye uhlangothi, lusebenza njengomqhubi ojwayelekile wokuhlangana okungacacile olimini olusha lwe-matrix; ngakolunye uhlangothi, lugcina indima efanayo njengoba luhlala lunjalo ngaphakathi kwezinkomba zethebula ezihlelekile, luqinisa ukuhambisana kwemodeli.

Ukuhlangana okungabonakali ngokumelene nokuchitheka noma ukusabalala kwemiphumela

Ukuze uqonde ngokugcwele injongo ye-@, kuyasiza ukuyiqhathanisa nomphumela we-spillover. Ngandlela thile, ziyizinhlangothi ezimbili zohlamvu lwemali olufanayo: i-inclic intersection inciphisa imiphumela ; i-spillover, ngakolunye uhlangothi, iyayandisa.

Ezinguqulweni zanamuhla ze-Excel, umthetho ozenzakalelayo uthi spillover : uma ifomula ikhiqiza amanani amaningi, "achitheka" kumaseli aseduze. Lokhu kwenza kube lula kakhulu ukusebenza nemisebenzi emisha efana ne-FILTER, SEQUENCE, RANDOMAR, SORT, SORTBY, noma i-UNIQUE, eklanyelwe ngqo ukugcwalisa ngokuzenzakalelayo amabhlogo aphelele amaseli.

Ukuhlangana okungabonakali, okuphoqelelwe ngo-@, kwenza okuphambene nalokho: kutshela uhlelo ukuthi, yize isisho singabuyisa izinto eziningana, sinesithakazelo kuphela kwesinye sazo , ngokuvamile esifanelana nomugqa wamanje. Lena indlela yokuqhubeka nokusebenza umugqa nomugqa, njengoba kwakwenziwa ngokwesiko, ngaphakathi kwendawo ebheka ngokuzenzakalelayo amasethi edatha amakhulu.

Uma ungasebenzisi uphawu lwe-@ ngendlela efanele lapho kudingeka khona, ungase uhlangabezane namaphutha okugcwala (#OVERFLOW!) lapho umphumela wefomula ungangeni kumaseli atholakalayo. Kodwa-ke, uma uwusebenzisa kahle, ungathola okungcono kakhulu kuzo zombili lezi zindawo: i-spill lapho udinga ukugcwalisa wonke ama-array, kanye ne-inclusive intersection lapho ufuna kuphela inani elithile kusuka kububanzi obukhulu.

Empeleni, ukufunda ukudlala ngale mibono emibili—ukuchichima ama-matrices noma ukuwanciphisa—kuyisihluthulelo sokufunda i-Excel yesimanje nokugwema izimanga ezingathandeki kumaspredishithi akho.

Uphawu lwe-@ ngale kwamafomula: ukukhulunywa ngakho kumazwana

Ku-Excel ye-Microsoft 365 kanye nenguqulo yewebhu, uphawu lwe-@ luphinde lusetshenziswe "kwezenhlalo" oluqondiswe emsebenzini wokubambisana . Alusetshenziswa kuphela kumafomula, kodwa futhi nokukhuluma ngabanye abantu abangaphakathi kwamazwana ebhukwini lomsebenzi.

Uma ufaka amazwana kuseli bese uthayipha u-@ ulandelwe igama lomuntu osebenza naye, i-Excel ikukhombisa uhlu lwabasebenzisi abangaba khona ukuze ukhethe ukuthi ubani ozokhuluma ngaye. Uma umkhetha, lowo muntu uthola i-imeyili enesixhumanisi esiqondile sokuphawula , okusheshisa kakhulu ukubuyekezwa kanye nokusebenza ngokubambisana.

Lolu hlelo lokukhuluma lusebenza ngendlela efanayo nalokho osuvele ukukubona ezinkundleni zokuxhumana noma kwamanye amathuluzi okubambisana. Nakuba lungahlobene nhlobo nokuhlangana okungacacile ngokombono wobuchwepheshe, luyisici esibalulekile sokusetshenziswa kwe-@ symbol ohlelweni lwesimanje lwe-Excel.

Ukwazi ukuthi i-@ isebenza nini njengomqhubi wefomula nokuthi nini njengethuluzi lokubambisana kubalulekile ekugwemeni ukudideka, ikakhulukazi uma wabelana ngezincwadi zomsebenzi nabasebenzisi abangajwayelene nalezi zici ezintsha.

Ama-parenthesis kanye nohlelo lokuhlola kumafomula

Nakuba uphawu lwe-@ luyinto egxilwe kuyo kulesi sihloko, kubalulekile ukukhumbula ukuthi i-Excel ithembele kakhulu odabeni lokuhlolwa kwamafomula , ikakhulukazi olulawulwa ukusetshenziswa kwama-parentheses. Lokhu kuthonya ngqo indlela imisebenzi yakudala ehlanganiswa ngayo nama-range nama-array.

Isibonelo, esishoni esilula njenge-=5+2*3, i-Excel ilandela uhlelo olujwayelekile lokusebenza: iyaphindaphinda kuqala bese ingeza kamuva, okuholela ku-11. Uma ufuna ukuthi ingeze kuqala bese iphindaphinda, kufanele ubhale u-=(5+2)*3, okubuyisela u-21. Ama-parentheses aphoqa i-Excel ukuthi ibale leyo ngxenye ngaphambi kokunye.

Kumafomula ayinkimbinkimbi kakhulu, into efana ne-=(B4+25)/SUM(D5:F5) ikhombisa ngokusobala ukuthi i-Excel kufanele ihlanganise i-B4+25, bese ibala isamba sobubanzi i-D5:F5, bese ekugcineni ihlukanisa imiphumela yomibili. Lesi sakhiwo sisiza ukugwema ukudideka kanye nokuhlanganiswa okungalungile kwamanani ebanga, ama-array, kanye nama-scalar.

Uma ukuhlangana okungacacile noma ukugcwala kakhulu kudlala indima, ama-parentheses abekwe kahle avumela ukulawula okukhulu ukuthi yiziphi izingxenye ezihlolwa njenge-matrix, ezincishiswa zibe yinani elilodwa, nokuthi yonke leyo miphumela ihlanganiswa kanjani ngokulandelana. Kungenye ingxenye yephazili eyenza amafomula akho abe namandla futhi afundeke kalula.

Ukuqonda ukuthi i-@, ama-parentheses, kanye nohlelo lokuhlola kuhlobene kanjani kukubeka esimweni esingcono kakhulu sokuklama amafomula asebenza ngendlela efanayo ezimweni ezahlukene futhi avumelane kahle nezinguquko phakathi kwezinguqulo ezindala nezintsha ze-Excel.

Konke lokhu kuziphatha okuzungeze uphawu lwe-@, i-inclic intersection, ama-dynamic arrays, kanye ne-calculation order kwenza i-Excel ibe ithuluzi elinamandla kakhulu, kodwa futhi ibe nzima kakhulu uma kuziwa ekuqondeni okwenzekayo ngaphansi kwe-hood. Ukuqonda kahle le mibono kuzokuvumela ukuthi unqume ukuthi ufuna ifomula isebenze nini "njengamafomula endabuko" nokuthi ufuna isebenzise nini ngokugcwele amakhono e-array kanye nokubambisana kwezinguqulo zamanje.

I-athikili ehlobene:

Ikholomu Nomugqa ku-Excel: Ungawasebenzisa Kanjani Ukuze Udale AmaSpredishithi Aphumelelayo