Kulesi sifundo, sizojwayelana nefomula yohlu lweseli eyodwa futhi sihlaziye isibonelo esihle sokusetshenziswa kwayo ku-Excel. Uma ungakawajwayele neze amafomula ahlukahlukene, sincoma ukuthi uqale uvule isifundo, esichaza izimiso eziyisisekelo zokusebenza ngama-arrays ku-Excel.
Ukusebenzisa I-Single Cell Array Formula
Uma ufunda isifundo mayelana namafomula ohlu lwamaseli amaningi, khona-ke isibalo esingezansi sibonisa ithebula osulijwayele kakade. Kulokhu umsebenzi wethu ukubala izindleko eziphelele zazo zonke izimpahla.
Kunjalo, singenza ngendlela yakudala futhi simane sifice amanani asuka ebangeni lamaseli D2:D6. Ngenxa yalokho, uzothola umphumela oyifunayo:
Kodwa kunezimo lapho ukubala okuphakathi (kithi, lolu uhla D2:D6) alwenzi noma yimuphi umqondo, akulula noma akunakwenzeka nhlobo. Kulokhu, ifomula yohlelo lweseli elilodwa isiza, ezokuvumela ukubala umphumela ngefomula eyodwa nje. Ukufaka ifomula enjalo ku-Excel, landela lezi zinyathelo:
- Khetha iseli lapho ofuna ukuthi umphumela uvele khona:
- Faka ifomula elandelayo:
- Njengoba lena kuyifomula yamalungu afanayo, okokufaka kufanele kuqedwe ngokucindezela inhlanganisela Ctrl + Shift + Faka. Ngenxa yalokho, sizothola umphumela ofana nalowo obalwe ngaphambili.
Isebenza kanjani le fomula yamalungu afanayo?
- Le fomula iqala ngokuphindaphinda amanani ahambisanayo ebubanzi obubili:
- Futhi ngokusekelwe kudatha etholiwe, idala uhlu olusha oluqondile olutholakala kuphela ku-RAM yekhompyutha:
- Bese umsebenzi ISUM ihlanganisa amanani alolu hlelo futhi ibuyisela umphumela.
Amafomula afanayo - Lena enye yezinto eziyinkimbinkimbi kakhulu, futhi ngesikhathi esifanayo ewusizo, amathuluzi ku-Microsoft Excel. Amafomula ohlu lweseli elilodwa akuvumela ukuthi wenze izibalo ezingeke zenziwe nganoma iyiphi enye indlela. Ezifundweni ezilandelayo, sizobheka izibonelo ezinjalo ezimbalwa.
Ngakho-ke, kulesi sifundo, uye wajwayelana namafomula ohlu lweseli elilodwa futhi wahlaziya isibonelo sokuxazulula inkinga elula. Uma ufuna ukufunda okwengeziwe ngama-arrays ku-Excel, funda lezi zihloko ezilandelayo:
- Isingeniso samafomula afanayo ku-Excel
- Amafomula we-Multicell array ku-Excel
- Izinhlaka zama-constants ku-Excel
- Ukuhlela amafomula afanayo ku-Excel
- Ukusebenzisa amafomula afanayo ku-Excel
- Izindlela zokuhlela amafomula afanayo ku-Excel