Nigute ushobora kubara umubare windangagaciro mu nkingi ya Excel

Rimwe na rimwe, umukoresha yashyizwe mubikorwa byo kutabara ingano yindangagaciro mu nkingi, ariko kubara ubwinshi. Ni ukuvuga, kuvuga gusa, ugomba kubara selile zingahe muriyi nkingi zuzuyemo amakuru runaka cyangwa inyandiko. Muri Excel, hari ibikoresho byinshi bishoboke gukemura ikibazo cyagenwe. Suzuma buri wese muri bo ku giti cyabo.

Nkuko tubibona, bitandukanye nuburyo bwambere, ubu buryo burasaba gusohoka mubisubizo byihariye byurupapuro hamwe nacyo bugumana aho. Ariko, ikibabaje, imikorere ya konti iracyafite uburenganzira bwo gushiraho ibisabwa kugirango uhitemo indangagaciro.

Isomo: Imikorere ya Wizard muri Excel

Uburyo bwa 3: Konti ya Operator

Gukoresha umukoresha, konti irashobora kubarwa gusa nindangagaciro zumubare mu nkingi yatoranijwe. Irengagije indangagaciro kandi ntabwo ikubiyemo ibisubizo rusange. Iyi miterere nayo yerekeza ku cyiciro cyabakora rirubamari, kimwe n'ibanze. Inshingano zayo ni ukubara selile murwego rwabigenewe, kandi murubanza rwacu mu nkingi, irimo indangagaciro. Syntax yiyi mikorere irasa nuwahoze ari umukoresha wabanjirije:

= Konte (agaciro1; agaciro2; ...)

Nkuko mubibona, ingingo z'umushinga w'itegeko na konti ni zimwe kandi uhagararire hamwe na selile cyangwa iringaniye. Itandukaniro muri syntax riri mwizina ryumukoresha ubwaryo.

1. Turagaragaza ikintu kurupapuro aho ibisubizo bizerekanwa. Kanda umaze kumenyera 1 "Shyiramo imikorere".



2. Nyuma yo gutangira umupfumu wibikorwa, ongera wimuke mucyiciro "ibarurishamibare". Noneho tugaragaza izina "konti" hanyuma tukande buto ya "Ok".



3. Nyuma yimpaka zifata idirishya rikora, konti igomba kwandikwa mumwanya wacyo. Muri iri dirishya, nko mu idirishya ryabanjirije iyi, irashobora guhagararirwa imirima 255, ariko, nkuko ihita, tuzakenera kimwe muri byo cyiswe "Agaciro1". Twinjiye mu nkingi duhuza muri uyu murima, dukeneye gukora igikorwa. Turabikora nkuko ubu buryo bwakorewe imikorere ya konti: Shyira indanga mumurima hanyuma uhitemo inkingi yimeza. Nyuma ya aderesi yinkingi yashyizwe kumurongo, kanda kuri buto ya "OK".



4. Ibisubizo bizahita bikurwa mu Kagari, ibyo twasobanuye ibikubiye mubikorwa. Nkuko mubibona, porogaramu ibarwa gusa selile zirimo indangagaciro. Ingirabuzimafatizo zambaye ubusa nibintu birimo amakuru yinyandiko ntabwo yitabiriye kubara.

Isomo: Konti yimikorere muri Excel

Uburyo 4: Inama ya OCRARAT

Bitandukanye nuburyo bwabanjirije, gukoresha umukoresha wa serivisi bigufasha kwerekana imiterere yujuje indangagaciro zizitabira kubara. Izindi selile zose zizirengagizwa.

Umukoresha wumunyamuryango nawe arutondewe nkitsinda ryibarurishamibare. Igikorwa cyacyo cyonyine nukubara ibintu bitarimo ubusa murwego, kandi murubanza rwacu mumikino yujuje imiterere yagenwe. Syntax yuyu mukoresha iratandukanye cyane nimirimo ibiri yabanjirije:

= Gahunda (intera; ibipimo)

Impaka "Urutonde" rutangwa muburyo bwo kwerekana umurongo wingingo runaka, kandi kuri iki kibazo ku nkingi.

Impaka "Ibipimo" birimo ibintu runaka. Ibi birashobora kuba umubare nyawo cyangwa agaciro keza hamwe nibimenyetso byerekanwe n "ibimenyetso byinshi" (>), "bike" (

Turabara se selile zingahe hamwe nizina "inyama" ziherereye mu nkingi yambere y ameza.

1. Turagaragaza ikintu kurupapuro aho kwerekana amakuru yakozwe biteguye. Kanda kuri "Shyiramo imikorere".



2. Mubikorwa Wizard, dukora inzibacyuho "imibare", tugenera izina ryibipimo hanyuma ukande kuri buto ya "OK".



3. Gukora ingingo zimpaka zimikorere ya metero. Nkuko mubibona, idirishya rifite imirima ibiri ihuye nibikorwa.

   Mu murima "intera" muri ubwo buryo, ibyo tumaze gusobanura inshuro zirenze imwe, tumenyekanisha ihuriro ryinkingi ya mbere yimeza.

   Mu murima "CRETER", dukeneye kwerekana imiterere yo kubara. Injira ijambo "inyama" ngaho.

   Nyuma yimiterere yavuzwe haruguru ikorwa, kanda kuri buto "OK".



4. Umukoresha akora kubara kandi atanga ibisubizo kuri ecran. Nkuko mubibona, mu nkingi yatoranijwe muri selile 63, ijambo "inyama" ririmo.

Reka duhindure umurimo gato. Noneho turasuzuma umubare wingirabuzimafatizo mu nkingi imwe itarimo ijambo "inyama".

1. Duhitamo selile aho tuzasohoka ibisubizo, nuburyo bwasobanuwe bwasobanuwe twita impaka zimpaka zifata.

   Mu murima "intera", tumenyekanisha imirongo imwe ya mbere yimeza, yatunganijwe mbere.

   Mu rwego rwa "CETRITION", tumenyekanisha imvugo ikurikira:

   Inyama

   Ni ukuvuga, iki gipimo cyerekana imiterere tubara ibintu byose byuzuyemo amakuru adakubiyemo ijambo "inyama". Ikimenyetso "" bisobanura muri Excele "ntabwo bingana."

   Nyuma yo kwinjira muri igenamiterere mumadirishya yo gutongana, kanda buto "OK".



2. Mu kagari ka Preset uhita ugaragaza ibisubizo. Avuga ko mu nkingi yagaragaje haribintu 190 ifite amakuru atarimo ijambo "inyama".

Noneho reka dukore mu nkingi ya gatatu yiyi mbonerahamwe ibarwa indangagaciro zose zirenze umubare wa 150.

1. Turagaragaza selire kugirango tugaragaze ibisubizo kandi dukore inzibacyuho kubintu byimikorere yimikorere.

   Mu murima "intera", tumenyekanisha imirongo yinkingi ya gatatu yimeza yacu.

   Mu murima "CRETER", andika imiterere ikurikira:

   > 150.

   Ibi bivuze ko gahunda izabara gusa ibintu birimo imibare birenze 150.

   Byongeye, nkuko bisanzwe, kanda buto "OK".



2. Nyuma yo kubara Excel yerekana ibisubizo muri selire yagenwe. Nkuko tubibona, inkingi yatoranijwe irimo indangagaciro 82 zirenga umubare wa 150.

Rero, tubona ko muri Excel hari uburyo butari buke bwo kubara umubare windangagaciro mu nkingi. Guhitamo amahitamo yihariye biterwa nintego zihariye zumukoresha. Rero, icyerekezo kumurongo wumurongo wemerera gusa kubona umubare windangagaciro zose mu nkingi zidakosoye ibisubizo; Igikorwa cya konti gitanga ubushobozi bwo kubikosora mu kagari gatandukanye; Umukoresha wa konti ibara gusa ibintu birimo amakuru yumubare; Kandi hamwe nibikorwa byubufasha, urashobora gushiraho ibintu byinshi byo kubara kubintu.