Igikorwa cya "Njyanama", akenshi gikoreshwa muri Excel, ni iciri ingagi. Niba utaragira ibitekerezo byibanze kubyerekeye imirimo ijyanye niri tsinda, menyera nibisobanuro byabo mumabwiriza yerekanwe hepfo.
Munsi yimirima, ibisubizo biragaragara, bimaze kwerekana uburyo bwiza bwimikorere. Noneho ntibishoboka kongeramo ikindi kintu, bityo formulaire igomba kwagura ibizaganirwaho muburyo bubiri bukurikira.
Ihitamo 1: Imiterere yinyandiko
Tuzasesengura uko tumeze mugihe hari inkingi ebyiri zifite indangagaciro zimwe na zimwe zamezi yacu. Birakenewe gukora icyitegererezo cyabo kugirango ibisubizo ari agaciro ka karuseli zingahe zihuye nibintu runaka. Ibintu bibiri bihujwe na formula imwe yoroshye.
- Kora igice cya mbere cyibikorwa bya "Njyanama" ugaragaza inkingi yambere nkinzitizi. Imikorere ubwayo ifite isura isanzwe: = kubarwa (A2: A25; "Ibipimo").
- Ongeraho ikimenyetso cyo kwiyongera ("+"), kizakora nkigihuza cyibintu bibiri.
- Ako kanya nyuma yacyo, andika igice cya kabiri - = kubarwa (B2: B25; "Ibipimo") - hanyuma ukande urufunguzo rwinjiza.
- Nibiba ngombwa, ongeraho umubare winyungu wongeyeho bande nibipimo byanze bikunze muburyo bumwe.
Reba ibisubizo byerekanwe mu kagari keretse. Niba ikosa ryaramutse gitunguranye, menya neza ko wangije neza syntax yimikorere, kandi selile murwego rufite imiterere ikwiye.
Ihitamo rya 2: Imiterere yimibare
Hamwe namagambo yuyu mubare, ni kimwe, ariko iki gihe reka dusuzume urugero rwibisobanuro birambuye byo gukusanya intoki yimirimo, ukurikije buri kantu.
- Nyuma yo gutangaza "invisi" mu minyururu, shiraho umubare w'imibare "A1: A25", aho aho kuba selile zagenwe, gusimbuza ibikenewe.
- Ako kanya hejuru yurwego nta mwanya, ongeraho ikimenyetso ";", utangaza gufunga.
- Nyuma yacyo, andika numero ushaka kubara.
- Shira ikimenyetso "+" hanyuma wongere igice cya kabiri cya formula muri ubwo buryo.
- Mugihe ukimara gukanda urufunguzo rwa ENTER, umubare ugaragara muri selire zizaba ibisubizo byimibare nibipimo bibiri byerekanwe.