Amafomula kanye nomatikuletsheni ku-Excel: ukuthi ayini nokuthi asetshenziswa kanjani

I-Excel iphinde inikeze imisebenzi yamalungu afanayo ekuvumela ukuthi wenze izibalo kusethi eyodwa noma amaningi amanani.

Kulesi sihloko sizobheka imisebenzi ye-matrix.

Una Ifomula yohlu lwe-Excel yenza izibalo eziningi kusethi eyodwa noma amaningi amanani futhi ibuyisela umphumela owodwa noma ngaphezulu.

Isibonelo somsebenzi we-Matrix

Ake sikubone ngesibonelo:

Ake sithi usebenza kuspredishithi esingakwesokudla futhi ufuna ukusebenzisa umsebenzi we-Excel wokuguqula ukuze ukopishe okuqukethwe kwamaseli B1:B3 kumaseli A5:C5.

Uma nje uthayipha umsebenzi

=TRASPOSE( B1:B3 )

kumaseli A5:C5 (njengoba kukhonjisiwe ngezansi), uzothola inani le-Excel #VALORE! umlayezo wephutha, ngoba kulokhu amaseli asebenza ngokuzimela ngakho-ke umsebenzi awuwenzi umqondo weseli ngalinye.

Ukuze senze umqondo womsebenzi we-Transpose, sidinga ukwenza amaseli A5:C5 sebenza ndawonye njenge-ARRAY. Ngakho-ke kufanele sifake umsebenzi njengefomula yohlu lwe-Excel.

Ifomula yamalungu afanayo ifakwa ngokucindezela inhlanganisela yokhiye Ctrl + Shift + Enter.

Ungabona ukuthi ifomula ifakwe njengefomula yamalungu afanayo, njengoba i-Excel ifaka izikaki ezigoqekile ezizungeze ifomula njengoba kuboniswe kubha yefomula yesipredishithi semiphumela ngenhla.

Ifaka amafomula afanayo e-Excel

Ukuze kuthathwe njengefomula yamalungu afanayo, ifomula kufanele ifakwe kanje:

• Gqamisa ububanzi bamaseli lapho ufuna ukufaka khona ifomula yamalungu afanayo;
• Thayipha ifomula yamalungu afanayo kuseli lokuqala (noma, uma isivele ibhalwe kuseli lokuqala, faka leli seli kumodi yokuhlela ngokucindezela okuthi F2 noma ngokuchofoza ibha yefomula);
• I-Premere Ctrl + Shift + Enter .

Uzoqaphela ukuthi i-Excel ibeka ngokuzenzakalelayo izikaki { } ezizungeze amafomula afanayo. Sicela uqaphele ukuthi lezi kumele ifakwe yi-Excel, ngokulandela izinyathelo ezichazwe ngenhla.

Uma uzama ukuthayipha ama-curly braces ngokwakho, i-Excel ngeke ihumushe ifomula njengefomula yamalungu afanayo.

Ukuhlela amafomula afanayo e-Excel

I-Excel ngeke ikuvumele ukuthi uhlele kuphela ingxenye yohlu lwamaseli aqukethe ifomula yamalungu afanayo, njengoba amaseli wonke esebenza ndawonye njengeqembu.

Ngakho-ke, ukuze uhlele ifomula yohlu lwe-Excel, udinga:

1. Yenza izinguquko ezidingekayo kuseli ngalinye ngalinye eliqukethe ifomula yamalungu afanayo;
2. Cindezela okuthi Ctrl + Shift + Enter ukuze ubuyekeze wonke amalungu afanayo.

Isusa amafomula afanayo e-Excel

Ukwengeza, i-Excel ngeke ikuvumele ukuthi ususe ingxenye yefomula yohlu lwe-Excel. Udinga ukususa ifomula kuwo wonke amaseli ewaphethe.

Ngakho-ke, uma ufuna ukususa ifomula yohlu ohlwini lwamaseli, udinga ukugqamisa lonke uhla lwamaseli, bese ucindezela ukhiye. Del.

Isibonelo sesi-2 samafomula e-matrix Excel

Cabanga ukuthi usebenza kuspredishithi esingezansi futhi ufuna ukuphindaphinda inani ngalinye kumaseli A1: A5 ngamavelu ahambisanayo kumaseli B1: B5, bese wengeza wonke lawa manani.

Enye indlela yokufeza lo msebenzi ukusebenzisa ifomula yamalungu afanayo:

=SUM( A1:A5 * B1:B5 )

Lokhu kuboniswa kubha yefomula yesipredishithi semiphumela ngezansi.

Qaphela ukuthi nakuba ifomula yamalungu afanayo kusipredishithi esingenhla ifakwe kuphela kuseli eyodwa, usadinga ukufaka ifomula usebenzisa u-Ctrl+Shift+Enter ye-Excel ukuze uyitolike njengefomula yamalungu afanayo.

Ercole Palmeri