Umumaro guhitamo mu Excel

Iyo ukora mu Excel, Abakoresha rimwe guhura umurimo guhitamo kuri lisiti ya Ikigize yihariye na bishingiye ku Umubarendanga yayo Kugenera ku bivugwa agaciro ko. Na gikorwa, Umumaro bitunganye guhangana na "guhitamo". Reka kwigira mu buryo burambuye uko gukorana umugurisha ibi, kandi ibibazo bishobora kwihanganira.

Gukoresha Ihitamo umugurisha

Umumaro guhitamo ryerekeza ku cyiciro cya operators "Links na tutabonwa". umugambi wayo ni kuvanaho agaciro runaka ku kagari runaka, uhuza umubare Umubarendanga in ikindi uwandika. Mu Igaragaza rya umugurisha ibi ni izi zikurikira:

= Guhitamo (number_intex; value1; value2; ...)

Ingingo ya Umubarendanga umubare irimo A Ihuza Kuri A Akazu aho uruhererekane umubare Ikigize ku, iryo tsinda utaha z'ubuhamya ahawe agaciro runaka. Umubare uruhererekane yoshobora gutandukana bivanye 1 to 254. Niba Kugaragaza i Umubarendanga uruta umubare uyu, umuhinzi Kugaragaza Ikosa mu kagari. Niba kwinjira agaciro fractional nk'uko ngingo, Umumaro bazaba nkimenya ko, nk'uko hafi agaciro wuzuye umubare uyu. Niba Gushyiraho "index umubare" bikaba nta ikwiranye "agaciro" impaka, umuhinzi bazagaruka Ikosa mu kagari.

Itsinda itaha "agaciro" impaka. Bishobora kugera umubare Ibigize 254. Muri urwo rubanza, uwo impaka "Meaning1" ni itegeko. Iri tsinda rya impaka igaragaza indangagaciro ko Ibanjirije impaka Umubarendanga izaba yemeje. Ni, niba umubare "3" ni "3" nk'uko impaka ku, bizaba buhuye agaciro ko igizwe nk'uko "value3" impaka.

A bitandukanye Ibyatanzwe bishobora gukoreshwa indangagaciro:

• INGINGO;
• Kubara;
• Inyandiko;
• RY;
• Imirimo, n'ibindi

Noneho reka turebe ingero zifatika mu bikorwa umugurisha ibi.

Urugero 1: rutonde Ikigize Imigaragarire kugira

Reka turabe ingene iyi Ikiranga ni Byemewe ku Urugero zisanzwe. Dufite meza na bava 1 to 12. Ni ngombwa bigakorwa ku mibare uruhererekane gukoresha Select Umumaro Kuri Kugaragaza i Izina w'ukwezi kwandikirana mu ISEGONDA ​​Inkingi ya meza.

1. Turi ahabona mbere kagari ubusa Inkingi "Izina rya Ukwezi". Kanda ku "Ongera Umumaro" icon hafi Ikurikiranyanyuguti Inzira.



2. Yiruka mu wizard mirimo. Genda cyiciro "Links na tutabonwa". Hitamo Kuva: i Urutonde ku Izina "Hitamo" na Kanda ku "OK" Akabuto.



3. Idirishya ryabakozi ririmo gukora. Mumwanya wa Nemeron umurima, ugomba kwerekana aderesi ya selile yambere yumubare wimibare. Ubu buryo burashobora gukorwa no gutwarwa nintoki na coortinate. Ariko tuzakora byinshi byoroshye. Shyira indanga mumurima hanyuma ukande buto yimbeba yibumoso kuri selile ihuye kurupapuro. Nkuko mubibona, guhuza bahita bigaragara mubyiciro byamadirishya.

   Nyuma yibyo, tugomba gutwara intoki izina ryamezi mumatsinda yimirima. Byongeye kandi, buri murima ugomba guhura n'ukwezi gutandukanye, ni ukuvuga muri "Agaciro", "Mutarama" byanditswe mu murima "D." - "Gashyantare", nibindi

   Nyuma yo gukora imirimo yagenwe, kanda kuri buto "OK" hepfo yidirishya.



4. Nkuko mubibona, ako kanya mu kagari twabonye mugikorwa cya mbere, ibisubizo byagaragaye, aribyo izina "Mutarama", bihuye numubare wambere wukwezi mumwaka.



5. Noneho, kugirango tutinjira muri formula ku zindi selile zose z '"izina ry'ukwezi", tugomba kuyigana. Kugirango dukore ibi, dushyiraho indanga kumutwe wo hepfo ya selire irimo formula. Ikimenyetso cyuzuye kiragaragara. Kanda buto yimbeba hanyuma hanyuma ukure ikimenyetso cyuzuza kugeza kumpera yinkingi.



6. Nkuko mubibona, formula yandukuwe kugeza kurwego dukeneye. Muri iki gihe, amazina yose yabamezi yose yerekanwe mu tugari duhuye numubare wabo ukurikirana kuva nkinkingi ibumoso.

Isomo: Master of Imikorere muri Excele

Urugero 2: Ibintu bishakiye

Mu rubanza rwabanje, twakoresheje formula yo guhitamo mugihe indangagaciro zose zimibare yagaciro yateguwe murutonde. Ariko ni gute uyu mukoresha ukora mubyukuri niba indangagaciro zagaragaye zivanze kandi zisubirwamo? Reka turebe kururugero rwameza hamwe nibikorwa byabanyeshuri. Mu nkingi ya mbere yameza, izina ryumunyeshuri ryerekanwe, mu kigereranyo cya kabiri (kuva ku manota 1 kugeza kuri 5), no mu cya gatatu tuzahitamo guhitamo gutanga ikigereranyo ("bibi cyane", "Babi", "nziza", "nziza", "nziza").

1. Tugenera akagari ka mbere muri "ibisobanuro" no kwimuka tubifashijwemo nuburyo ikiganiro kimaze gukemurwa kiri hejuru, guhitamo idirishya ryatoranijwe ryimpaka.

   Muri "Umubare wa Nerox Umubare", vuga umurongo kuri selire ya mbere ya "Isuzuma", ririmo amanota.

   Itsinda ryimirima "Ibisobanuro" Uzuza ibi bikurikira:

   • "Agaciro1" - "bibi cyane";
   • "Ibisobanuro2" - "bibi";
   • "Ibisobanuro3" - "Birashimishije";
   • "Agaciro4" - "Nibyiza";
   • "Agaciro5" - "byiza."

   Nyuma yo gutangiza amakuru yavuzwe haruguru arakorwa, kanda kuri buto "OK".



2. Agaciro kagaciro k'ikintu cya mbere cyerekanwe muri selire.



3. Kugirango utange uburyo busa bwibintu bisigaye, Gukoporora amakuru mu kasho kayo ukoresheje ikimenyetso cyuzuye, nkuko byakorewe muburyo 1. Nkuko tubibona, kandi iki gihe imikorere yakoze neza kandi isohotse ibisubizo byose ukurikije hamwe na algorithm yagenwe.

Urugero rwa 3: Koresha hamwe nabandi bakoresha

Ariko birenze urugero utanga umusaruro ushinzwe guhitamo birashobora gukoreshwa hamwe nibindi bikorwa. Reka turebe uko ibi bikorwa kurugero rwo gushyira mubikorwa abakora n'amafaranga.

Hano hari ameza yo kugurisha ibicuruzwa. Igabanyijemo inkingi enye, buri kimwe kijyanye nubucuruzi bwihariye. Amafaranga yinjira agaragazwa ukwe kumurongo wihariye. Inshingano zacu nugukora kugirango nyuma yo kwinjira mumwanya wo hanze mu kagari runaka k'urupapuro, umubare w'amafaranga y'iminsi yose y'ububiko bwagenwe bwerekanwe. Kubwibyo tuzakoresha guhuza abakora ba leta no guhitamo.

1. Hitamo akagari ibisubizo bizasohora. Nyuma yibyo, kanda kuri bimaze kumenyera igishushanyo "Shyiramo imikorere".



2. Imikorere yinzird idirishya rirakorwa. Iki gihe twimukiye mucyiciro "imibare". Turabona kandi tugenera izina "amafaranga". Nyuma yibyo, kanda kuri buto "OK".



3. Idirishya ryibiganiro byimikorere iratangizwa. Uyu mukoresha akoreshwa kugirango abare umubare wimibare murwego rwa selile. Syntax yayo iroroshye kandi yumvikana:

   = Amafaranga (umubare1; Umubare2; ...)

   Ni ukuvuga, ingingo zuyu mukoresha mubisanzwe ni imibare cyangwa, ndetse kenshi, zerekana selile zirimo imibare igomba kuvugwa. Ariko muritwe, muburyo bumwe bwo gutongana, ntabwo ari umubare kandi ntabwo ari isano, ariko ibikubiye mubikorwa.

   Shyira indanga muri "Umubare1". Noneho kanda ku gishushanyo, cyerekanwe muburyo bwa mpandeshatu zihindagurika. Iki gishushanyo kiri mumurongo umwe utambitse aho "shyiramo imikorere" hamwe nimikorere ya formula iri, ariko ibumoso. Urutonde rwibintu bishya byakoreshejwe birahari. Kubera ko guhitamo kwa formula biherutse gukoreshwa natwe muburyo bwambere, burahari kururu rutonde. Kubwibyo, birahagije gukanda kuri iki kintu kugirango ujye mu idirishya ryimpaka. Ariko birashoboka cyane ko utazaba kurutonde rwiri zina. Muri iki gihe, ugomba gukanda kuri "indi mirimo ..." umwanya.



4. Umupfumu w'imikorere watangijwe, aho mu "mahuza ndetse n gice" tugomba kubona izina "guhitamo" no kugenera. Kanda kuri buto ya "OK".



5. Idirishya rya Operator Guhitamo Idirishya rirakorwa. Muri "Inomero Umubare", sobanura umurongo uhuza selile yurupapuro, aho twinjije umubare wubucuruzi kugirango ugaragaze amaso yakurikiyeho.

   Muri "Agaciro1", ugomba kwinjiza imirongo ya "1 guhaha". Kora byoroshye. Shyira indanga mumurima wagenwe. Noneho, ufashe buto yimbeba yibumoso, tugenera urwego rwose rwinkingi ya "1 guhaha". Aderesi izahita igaragara mu idirishya ryimpaka.

   Mu buryo nk'ubwo, muri "Agaciro2", ongeraho imirongo y'inkingi "2 guhaha", muri "Agaciro" - "Agaciro" - kandi mu rwego rwa "Agaciro" - "Ubucuruzi".

   Nyuma yo gukora ibi bikorwa, kanda buto "OK".



6. Ariko, nkuko tubibona, formula yerekana ibisobanuro bitari byo. Ibi biterwa nuko tutigeze twinjira mu mubare w'ubucuruzi mu kagari gakwiye.



7. Twinjiye mu mubare w'ubucuruzi mu Kagari kagenewe izo ntego. Ingano yinjiza ninkingi ikwiye ihita yerekanwa ku rupapuro aho formula yashizwemo.

Ni ngombwa gusuzuma ko ushobora kwinjiza imibare gusa kuva 1 kugeza 4, zizahuza numubare witoto. Niba winjiye indi mibare, noneho formula izongera gusubiza ikosa.

Isomo: Nigute ushobora kubara amafaranga muri Excel

Nkuko mubibona, imikorere yahisemo ifite porogaramu yaryo irashobora kuba umufasha mwiza cyane kugirango ukore imirimo. Mugihe uyikoresha uhuza nabandi bakora, ubushobozi bwo kwiyongera.