Nigute washyiramo formulaine mubuhungiro

Uburyo 1: Imikorere yinjiza buto

Ihitamo ukoresheje buto idasanzwe kugirango uhamagare "imikorere" ibereye kubakoresha Novice nabadashaka kwandika intoki kuri buri kintu, kwitegereza ibintu byihariye bya gahunda ya gahunda.

1. Iyo winjije formula, selile ihora yatoranijwe cyane cyane, aho agaciro kanyuma kazaba kari mugihe kizaza. Kora ukanze kuri LKM ikwiye.



2. Noneho jya kuri "Shyiramo imikorere" Kanda kuri buto yagenewe iyi buto kumurongo wo hejuru.



3. Ibikurikira ugomba kubona ikintu gikwiye. Kugirango ukore ibi, urashobora kubyinjirizaho ibisobanuro bigufi cyangwa uhitamo icyiciro.



4. Reba kurutonde muri blok hepfo kugirango uhitemo imikorere imwe.



5. Iyo bigenewe hepfo, amakuru make yerekeye ibikorwa kandi ihame ryo gufata amajwi rizerekanwa.



6. Kugirango ubone amakuru yoherejwe kubatezimbere, uzakenera gukanda ku mabaruwa yagaragaye "ubufasha kuri iyi mikorere".



7. Mugihe cyo gutoranya ibikorwa bibaye, idirishya ritandukanye rizagaragara, aho ibitekerezo byayo byuzuye. Kurugero, twafashe formula max, twerekana agaciro ntarengwa kurutonde rwose rwimpaka. Kubwibyo, nkumubare, urutonde rwingirabuzimafatizo rushyizwe mu rugero rwo kubara rwashyizwe hano.



8. Aho kuzuza intoki, urashobora gukanda kumeza hanyuma ugabanye selile zose kugirango winjire kumurongo umwe.



9. Max, nkindi mirimo, kurugero, amafaranga akunze arashobora kuba arimo urutonde rwimpaka nyinshi kandi kubara indangagaciro muribo bose. Kugirango ukore ibi, uzuza gahunda imwe nibikurikira "Umubare2", "Umubare" nibindi.



10. Nyuma yo gukanda buto ya "OK" cyangwa inyandiko yinjijwe, formula yinjijwe muri selire yatoranijwe mbere hamwe nibisubizo biva. Iyo ukanze kuri yo kuri Panel yo hejuru, uzabona syntax yandika formula kandi, nibiba ngombwa, urashobora kuyihindura.

Uburyo 2: Tab tab

Tangira akazi hamwe nibikoresho byo kwinjizamo formulaire, byafatwaga hejuru, ntushobora gusa kubufasha bwo gukora imikorere, ariko nanone muri tab itandukanye aho hari ibindi bikoresho bishimishije.

1. Kanda formulaire tab binyuze kumurongo wo hejuru.



2. Kuva hano urashobora gufungura "shyiramo imikorere", kugirango utangire kubyaza, hitamo formula ituruka mubitabo cyangwa ngo ukoreshe igikoresho cya avosumn, ibyo dusaba gutekereza.



3. Bizaba ngombwa guhitamo selile zose zigomba kuvugwa mu ncamake, hanyuma ukande kumurongo wa avosumn.



4. Formula yinjijwe mu buryo bwikora hamwe nimpaka zose, kandi ibisubizo bizerekanwa kumpera ya selile.

Uburyo 3: Gushiraho intoki ya formula

Rimwe na rimwe biroroshye gukoresha uburyo bw'intoki bwo gushyiramo formulaire, kubera ko Wizard yo kurema adashobora guhangana n'inshingano, kurugero, mugihe bigeze mubihe byinshi mugihe cyangwa ibindi bintu bisanzwe. Mu bihe nk'ibi, uzuza selile wigenga byihuse kandi byoroshye.

1. Nkuko bimaze kuvugwa muburyo bwa mbere, gutangira, hitamo selile aho formula igomba kuboneka.



2. Andika ikimenyetso "=" mu murima winjiza hejuru cyangwa muri selire ubwayo, zizasobanura intangiriro ya formula.



3. Noneho shiraho imikorere ubwayo ukoresheje izina ryayo. Koresha inama zo gutanga ibisobanuro byanditse, kandi nazo menyereye ibisobanuro bigaragara kugirango umenye intego yimikorere.



4. Shira impinga yo gufungura no gufunga aho izandikwa.



5. Shyira ahagaragara indangagaciro cyangwa wandike selile zikubiye mu mpaka wenyine. Nibiba ngombwa, shyira ibimenyetso byuburinganire cyangwa ubusumbane hamwe na dogere.



6. Igisubizo cya formula kizerekanwa nyuma yo gukanda urufunguzo rwa Enter.



7. Niba imirongo myinshi cyangwa impaka zikoreshwa, shyira ikimenyetso ";", hanyuma wandike indangagaciro zikurikira nkuko byasobanuwe mubisabwe byerekanwe kuri ecran.

Iyo inzira eshatu zirangiye, tubona ko hari ingingo itandukanye kurubuga rwacu, aho umwanditsi asenya imishinga myinshi yingirakamaro iboneka muri Excel. Niba utangiye gusa kumenyana niyi gahunda, reba amategeko yo gukoresha ayo mahitamo.

Soma birambuye: Imikorere yingirakamaro muri Microsoft Excel

Uburyo 4: Shyiramo imiterere yimibare

Ihitamo ryanyuma ni ugushyiramo imibare cyangwa ikigereranyo, bishobora kugirira akamaro abo bakoresha bose bakeneye gukora imvugo nkiyi mumeza. Kugirango ukore ibi, inzira yoroshye yo gukoresha igikoresho kidasanzwe.

1. Fungura tab "shyiramo" no kwagura igice "Ibimenyetso".



2. Tangira gukora formula ukanze buto "ikigereranyo".



3. Koresha umwanya wo kugereranya uhita uhindura ingano yoroshye, hanyuma ukoreshe inyuguti cyangwa imiterere yiteguye kugirango yoroshye kurema formula.



4. Iyo urangije, urashobora kwimura formula ahantu hose hanyuma uhindure ibipimo byayo byo hanze.

Niba kubwimpamvu zimwe na zimwe zavutse hamwe no kubara formulaire, birashoboka cyane ko byakozwe mumakosa hamwe nibitekerezo byabo cyangwa indi mikorere. Kwiyambikaho amabwiriza akurikira.

Soma birambuye: ibibazo hamwe no kubara formulaire muri Microsoft Excel