Iifomyula kunye neematriki kwi-Excel: yintoni na kwaye zisetyenziswe njani

I-Excel ikwabonelela ngemisebenzi yoluhlu ekuvumela ukuba wenze izibalo kwiseti enye okanye ngaphezulu yamaxabiso.

Kweli nqaku siza kujonga imisebenzi ye-matrix.

Omnye Ifomula yoluhlu lwe-Excel yenza izibalo ezininzi kwiseti enye okanye ngaphezulu yamaxabiso kwaye ibuyisela isiphumo esinye okanye ngaphezulu.

Umzekelo womsebenzi weMatrix

Masiyibone ngomzekelo:

Masithi usebenza kwi-spreadsheet ekunene kwaye ufuna ukusebenzisa i-Excel's transpose function ukukopa imixholo yeeseli B1:B3 kwiiseli A5:C5.

Ukuba uchwetheza nje umsebenzi

=TRASPOSE( B1:B3 )

kwiiseli A5:C5 (njengoko kubonisiwe ngezantsi), uya kufumana ixabiso le-Excel #VALORE! umyalezo wemposiso, kuba kulo mzekelo iiseli zisebenza ngokuzimeleyo kwaye ke umsebenzi awenzi ngqiqo kwiseli nganye.

Ukwenza ingqiqo yomsebenzi weTranspose, kufuneka senze iiseli A5:C5 sebenza kunye njenge-ARRAY. Ke ngoko kufuneka singenise umsebenzi njengefomula yoluhlu lwe-Excel.

Ifomula yoluhlu ifakwe ngokucinezela indibaniselwano yesitshixo Ctrl + Shift + Enter.

Uyabona ukuba ifomyula ifakwe njengefomula yoluhlu, njengoko i-Excel ifaka iibrayisi ezigobileyo malunga nefomula njengoko kubonisiwe kwibha yefomula ye-spreadsheet yeziphumo apha ngasentla.

Ukufaka iifomyula ze-Excel

Ukuze ithathwe njengefomula yoluhlu, ifomula kufuneka ifakwe ngolu hlobo lulandelayo:

• Phawula uluhlu lweeseli apho ufuna ukufaka khona ifomula yoluhlu;
• Chwetheza uluhlu lwefomula kwiseli yokuqala (okanye, ukuba sele ichwetheziwe kwiseli yokuqala, faka le seli kwindlela yokuhlela ngokucinezela F2 okanye ucofa ibha yefomula);
• I-Premere Ctrl + Shift + Enter .

Uya kuqaphela ukuba i-Excel ibeka ngokuzenzekelayo iibrayisi {} malunga neefomula zoluhlu. Nceda uqaphele ukuba ezi kufuneka zifakwe yi-Excel, ngokulandela la manyathelo achazwe ngasentla.

Ukuba uzama ukuchwetheza iibrayisi ezigobileyo ngokwakho, i-Excel ayiyi kutolika ifomula njengefomula yoluhlu.

Ukuhlela iifomula zoluhlu lwe-Excel

I-Excel ayizukuvumela ukuba uhlele kuphela inxalenye yoluhlu lweeseli eziqulathe ifomula yoluhlu, kuba iiseli zisebenza kunye njengeqela.

Ke ngoko, ukuhlela uluhlu lwefomula ye-Excel, kufuneka:

1. Yenza utshintsho olufunekayo kwiseli nganye equlethe uluhlu lwefomula;
2. Cinezela Ctrl + Shift + Faka ukuze uhlaziye uluhlu luphela.

Ukuphelisa iifomyula ze-Excel

Ukongeza, i-Excel ayiyi kukuvumela ukuba ucime inxalenye yefomula yoluhlu lwe-Excel. Kufuneka ucime ifomula kuzo zonke iiseli ezikuyo.

Ke ngoko, ukuba ufuna ukususa ifomula yoluhlu kuluhlu lweeseli, kufuneka uqaqambise lonke uluhlu lweeseli, emva koko ucinezele isitshixo. Del.

Umzekelo 2 weefomyula zematriki Excel

Khawufane ucinge ukuba usebenza kumzekelo wespredishithi ongezantsi kwaye ufuna ukuphindaphinda ixabiso ngalinye kwiiseli. A1: A5 kunye namaxabiso ahambelanayo kwiiseli B1: B5, uze udibanise onke la maxabiso.

Enye indlela yokufezekisa lo msebenzi kukusebenzisa ifomula yoluhlu:

=SUM( A1:A5 * B1:B5 )

Oku kuboniswe kwibha yefomula yeziphumo zespreadsheet ngezantsi.

Qaphela ukuba nangona ifomula yoluhlu kwi-spreadsheet engentla ifakwe kuphela kwiseli enye, kusafuneka ufake ifomula usebenzisa u-Ctrl+Shift+Enter ye-Excel ukuyitolika njengefomula yoluhlu.

Ercole Palmeri