Ntabwo ijambo ryabo ryose rya Microsoft ryabakoresha bazi ko muriyi gahunda ushobora kubara ukurikije formulate yemewe. Birumvikana, mbere yubushobozi bwibiro byibiro, gutunganya Excel Excel Excel, umwanditsi wanditse ntabwo agera, ariko, kubara byoroshye, nkinama yamakuru, irashobora kubikorwa muri yo. Uyu munsi tuzavuga uko bikorwa.
Kubara amafaranga mu Ijambo
Nubwo Ijambo rya Microsoft ryerekezaga cyane cyane kukazi hamwe ninyandiko, hiyongereyeho, irashobora gukoreshwa hamwe nibishushanyo, imibare yose nibintu, imbonerahamwe n'imiterere. Aba nyuma "bombi" bakunze kwerekana ko bakeneye kubara amafaranga, ni ukuvuga, birashobora kuba ngombwa gusabwa haba mumeza no murugero, formula cyangwa ikigereranyo. Muri buri kibazo, ni ngombwa gukora ukundi. Nigute uzigira nyuma.Uburyo 1: formula ningingo
Niba mu Ijambo ukeneye kubara igiteranyo cyimibare cyangwa impinduka zitazwi zanditswe mumibare, ikigereranyo cyangwa formula, uzakenera kwerekeza kubikoresho byanditse. Ihagarariwe mugushiramo, kurema no guhindura ibingana, bijyanye no gukorana nibyo twanditse muburyo burambuye kurubuga rwacu - yerekanwe kuriyo.
Soma birambuye: Gukorana na formula ninganiza ijambo rya Microsoft
Uburyo 2: amafaranga mumeza
Kenshi na kenshi mbere yuko abakoresha ijambo rya Microsoft bavuga neza umurimo woroshye kuruta kurema imvugo nuburinganire. Gukenera kubara amafaranga agaragara mugihe ukorera hamwe nimbonerahamwe mugihe isabwa kugirango ubone agaciro k'umubare wanditse mu nkingi zayo cyangwa umurongo utandukanye. Ibi kandi bikozwe hamwe nubufasha bwa formula, ariko bitandukanye rwose nigisobanuro cya algorithm cyaganiriweho hejuru.
Ibiranga gahunda y'akazi
Gukora kubara mumeza byakozwe mumagambo, ugomba kumenya ibintu byinshi byingenzi.
- Niba uhinduye ibikubiye mu tugari bikubiye muri formula, umubare w'imibare ntuzavugururwa mu buryo bwikora. Kugirango ubone ibisubizo nyabyo, ugomba gukanda kuri buto yimbeba iburyo muri selire hamwe na formula hanyuma uhitemo ikintu "kuvugurura umurima".
- Kubara ukurikije formula ikorwa gusa kubijyanye na selile irimo amakuru gusa. Niba mu nkingi cyangwa umurongo ushaka kuvuga selile zubusa, porogaramu izasohoka gusa kubwibyo kugabanuka (intera), iri hafi kuri formulaire, yirengagije ingirabuzimafatizo, ziherereye hejuru yubusa. Ibisa nkibizaba hamwe namakuru hamwe numurongo.
Umwanzuro
Nkuko mubibona, suzuma igiteranyo cyimibare iri muri Microsoft Ijambo birashobora kuba uburyo bubiri butandukanye. Iya mbere isobanura gukorana nimibare, na kabiri - hamwe nimbonerahamwe namakuru akubiye muri selile zabo.