Njengase-Excel, phinda ikholomu ngekholomu nekholomu ngenombolo

Labo bantu abavame ukusebenza kukhompyutha, ngokushesha noma kamuva bazohlangana nohlelo olufana ne-Excel. Kodwa ingxoxo kulesi sihloko ngeke ihambisane nazo zonke izinzuzo nezindleko zohlelo, kodwa mayelana nengxenye yayo ehlukile "Ifomula." Yiqiniso, ezikoleni nasemayunivesithi ezifundweni zabafundi be-computer nesayensi nabafundi baqeqeshwe ngalesi sihloko, kodwa kulabo abakhohliwe, - isihloko sethu.

Ingxoxo iyoba yindlela yokwandisa ikholomu ku-Excel ngekholomu. Imfundo eningiliziwe izohlinzekwa ngendlela yokwenza lokhu, ngokuhlaziywa kwesinyathelo ngesinyathelo kwento ngayinye, ngakho wonke umuntu, ngisho nomfundi wokuqala, uzokwazi ukuqonda lo mbuzo.

Hlanganisa ikholomu ngekholomu

Njengoba ku-Excel, yandisa ikholomu ngekholomu, sizokhipha isibonelo. Ake sicabange ukuthi encwadini ye-Excel udale ithebula ngezindleko nokulingana komkhiqizo. Futhi une iseli ngezansi ngenani eliphelele. Njengoba ungacabanga, udinga ukwandisa ngokushesha amakholomu amabili okuqala bese uthola inani lawo.

Ngakho, nansi imfundo yesinyathelo ngesinyathelo:

1. Khetha iseli oyifunayo bese uchofoze kusithonjana somsebenzi, esitholakala phezulu kwethuluzi lamathuluzi.
2. Ngaphambi kokuba ube iwindi lapho uzodinga ukhethe "Ezinye imisebenzi".
3. Okulandelayo, kumele ukhethe kusuka eqenjini lemisebenzi yezibalo.
4. Khetha "SUMPRODUCT".

Emva kwalokho, iwindi lizovela licela ukuthi ukhethe ibanga nedatha edingekayo, lapha ungaya ngezindlela ezimbili. Owokuqala ubonisa ukuthi usebenzisa isikhombisi ukuze ukhethe ikholomu yokuqala (izindleko) futhi uhla lwayo luzocaciswa ku- "I-Array 1", kanti okwesibili (intengo) kuzocaciswa ku- "Uhlu 2". Njengoba ubona, ububanzi bubekiwe kumpawu (C2: C6). Indlela yesibili isho ukuthi uzofaka lezi zimiso ngesandla, akukho umehluko kulokhu.

Manje uyazi indlela eyodwa yokwandisa ikholomu ngekholomu ku-Excel, kodwa akuyena owodwa kuphela, futhi sizoxoxa ngalokhu okulandelayo kumbhalo ngezansi.

Indlela yesibili yokwandisa

Ukwandisa amakholomu ngendlela yesibili, kuzodingeka futhi ukhethe iqembu "lemisebenzi" yezibalo, kodwa manje udinga ukusebenzisa "UMSEBENZI". Manje ngaphambi kwakho kunezinsimu ezimbili: "Inamba 1" ne "Inombolo 2". Chofoza ku- "Inombolo 1" futhi ukhethe inani lokuqala kusukela kukholomu yokuqala, uphinda ngokuphindaphindiwe izinyathelo nge "Inombolo 2", khetha nje inani lokuqala lekholomu yesibili.

Ngemva kokuchofoza okuthi "Kulungile" esitokisini ngefomula, umkhiqizo wezindinganiso ezikhethiwe kubonakala, kuhlala kuphela ukuqedela kabusha amaseli, ukwenza lokhu, ukuhambisa isikhombisi emkhawulweni ongakwesokudla kweseli bese uyihudula phansi kwinombolo edingekayo yamaphuzu.

Manje usufunde indlela yesibili yokuphindaphinda ikholomu ku-Excel ngekholomu. Manje ake sikhulume ngokuthi singandisa kanjani inombolo ngekholomu.

Hlanganisa ikholomu ngenombolo

Ngakho, ungayandisa kanjani ikholomu ku-Excel ngenombolo? Eqinisweni, kungcono nakakhulu. Ukwenza lokhu:

1. Khetha iseli lapho umphumela uzobe khona.
2. Bhala uphawu "olulingana" kulo.
3. Sebenzisa isikhombisi ukuze ukhethe inani lokuqala kusuka kukholomu, bese ukhetha inombolo lapho leli nani lizophindwa khona.
4. Ngemuva kwalokho, susa isikhombisi kule namba bese ucindezela ukhiye we-F4.
5. Manje nje udinga ukuhambisa isikhombisi ekhoneni elingezansi elingakwesokudla leseli ngempendulo bese uyihudula kwinombolo edingekayo yamaphuzu.