Ukuhlela amafomula afanayo ku-Excel

Ezifundweni ezedlule, sixoxe ngemiqondo eyisisekelo nolwazi oluphathelene nezinhla ku-Excel. Kulesi sifundo, sizoqhubeka nokufunda amafomula afanayo, kodwa ngokugcizelela kakhulu ekusebenziseni kwawo okungokoqobo. Ngakho-ke, uyishintsha kanjani ifomula yamalungu afanayo ekhona kakade ku-Excel?

Imithetho yokuhlela amafomula afanayo

Uma ifomula yamalungu afanayo ifakwa kuseli eyodwa, ukuyihlela ku-Excel ngokuvamile akunzima kakhulu. Into eyinhloko lapha ukuthi ungakhohlwa ukuqedela ukuhlela ngenhlanganisela eyinhloko Ctrl + Shift + Faka.

Uma ifomula ingamaseli amaningi, okungukuthi ibuyisela amalungu afanayo, khona-ke ubunzima obuthile buvela ngokushesha, ikakhulukazi kubasebenzisi abasaqalayo. Ake sibheke imithetho embalwa okumele uyiqonde ngaphambi kokuthi uqale ukuhlela uhlu.

1. Awukwazi ukushintsha okuqukethwe kweseli elilodwa eliqukethe ifomula yamalungu afanayo. Kodwa iseli ngalinye lingaba nokufometha kwalo.
2. Awukwazi ukususa amaseli ayingxenye yefomula yamalungu afanayo. Ungasusa kuphela wonke amalungu afanayo.
3. Awukwazi ukuhambisa amaseli ayingxenye yefomula yamalungu afanayo. Kodwa ungakwazi ukuhambisa lonke uhlu.
4. Awukwazi ukufaka amaseli amasha, okuhlanganisa imigqa namakholomu, kububanzi bamalungu afanayo.
5. Awukwazi ukusebenzisa amafomula ohlu lwamaseli amaningi kumathebula adalwe ngomyalo Ithebula.

Njengoba ubona, yonke imithetho ebalwe ngenhla igcizelela ukuthi uhlu luphelele. Uma ungalandeli okungenani owodwa kule mithetho engenhla, i-Excel ngeke ikuvumele ukuthi uhlele uhlu futhi izokhipha isexwayiso esilandelayo:

Ukukhetha uhlu ku-Excel

Uma udinga ukushintsha ifomula yamalungu afanayo, into yokuqala okufanele uyenze ukukhetha ububanzi obuqukethe amalungu afanayo. Ku-Excel, kunezindlela okungenani ezi-3 zokwenza lokhu:

1. Khetha uhla lwamalungu afanayo ngesandla, okungukuthi usebenzisa igundane. Lena indlela elula, kodwa kwezinye izimo engafaneleki neze.
2. Ukusebenzisa ibhokisi lengxoxo Khetha iqembu lamaseli. Ukuze wenze lokhu, khetha noma iyiphi iseli okungeyelunga:Bese nakuthebhu ethi Ikhaya ohlwini lokudonsela phansi Thola bese ukhetha ukuchofoza Khetha iqembu lamaseli.

   

   Ibhokisi lengxoxo lizovuleka Khetha iqembu lamaseli. Setha inkinobho yomsakazo ku-Current Array bese uchofoza OK.

   

   Uhlu lwamanje luzogqanyiswa:

   

3. Ukusebenzisa izinhlanganisela eziyinhloko CTRL+/. Ukuze wenze lokhu, khetha noma iyiphi iseli ohlwini bese ucindezela inhlanganisela.

Ungasusa kanjani ifomula yamalungu afanayo

Into elula ongayenza nge-array ku-Excel ukuyisusa. Ukuze wenze lokhu, vele ukhethe uhlu olufunayo bese ucindezela inkinobho Susa.

Ungahlela kanjani ifomula yamalungu afanayo

Isibalo esingezansi sibonisa ifomula yamalungu afanayo engeza amanani obubanzi obubili. Kungabonakala emfanekisweni ukuthi lapho sifaka ifomula, senze iphutha elincane, umsebenzi wethu ukuwulungisa.

Ukuze uhlele ifomula yamalungu afanayo, yenza okulandelayo:

1. Khetha ububanzi belungu elifanayo usebenzisa noma yiziphi izindlela ezaziwa nguwe. Esimweni sethu, lolu wububanzi C1:C12.
2. Shintshela kumodi yokuhlela yefomula ngokuchofoza ibha yefomula noma ngokucindezela inkinobho F2. I-Excel izosusa ama-curly braces azungeze ifomula yohlu.
3. Yenza izinguquko ezidingekayo kufomula:
4. Bese ucindezela inhlanganisela yokhiye Ctrl + Shift + Fakaukulondoloza izinguquko. Ifomula izohlelwa.

Ishintsha usayizi wefomula yamalungu afanayo

Kaningi kunesidingo sokunciphisa noma sokwandisa inani lamaseli kufomula yamalungu afanayo. Ngizosho ngokushesha ukuthi lokhu akuwona umsebenzi olula futhi ezimweni eziningi kuzoba lula ukususa uhlu oludala bese udala entsha.

Ngaphambi kokususa amalungu afanayo amadala, kopisha ifomula yawo njengombhalo bese uyisebenzisa kuhlelo olusha. Ngamafomula anzima, le ndlela izosindisa isikhathi esiningi.

Uma udinga ukushintsha indawo yamalungu afanayo ekhasini lomsebenzi ngaphandle kokushintsha ubukhulu bawo, vele uwususe njengobubanzi obujwayelekile.

Kunezindlela ezimbalwa zokuhlela amasayizi afanayo ongawathola ewusizo. Izindlela zinikezwe kulesi sifundo.

Ngakho-ke, namuhla ufunde ukuthi ungakhetha kanjani, ususe futhi uhlele amafomula ahlukahlukene, futhi ufunde nemithetho ewusizo yokusebenza nawo. Uma ufuna ukufunda okwengeziwe ngama-arrays ku-Excel, funda lezi zihloko ezilandelayo:

• Isingeniso samafomula afanayo ku-Excel
• Amafomula we-Multicell array ku-Excel
• Amafomula ohlu lweseli eyodwa ku-Excel
• Izinhlaka zama-constants ku-Excel
• Ukusebenzisa amafomula afanayo ku-Excel
• Izindlela zokuhlela amafomula afanayo ku-Excel