Igabana rya formula muri Excele: Amahitamo 6 yoroshye

Muri Microsoft Excel, kugabana birashobora gukorwa haba mubufasha bwa formulaire no gukoresha imirimo. Kwiyemeza no gutandukana bikora imibare na aderesi za selile.

Uburyo 1: nimero yo kugabana kumubare

Urupapuro rwitwa Excel rushobora gukoreshwa nkubwoko bwa calculatrice, gusangira gusa numero imwe. Ikimenyetso cy'igice kibuza gukubita (umurongo usubiremo) - "/".

1. Duhinduka muri selile iyo ari yo yose y'urupapuro cyangwa mu murongo wa formula. Dushyize ikimenyetso "bingana" (=). Twinjije numero igabanya ubukwe. Shira ikimenyetso cyo kugabana (/). Twinjije agamije kuva clavier. Rimwe na rimwe, abatandukanya barenze umwe. Hanyuma, mbere ya buri muco, dushyiramo ibice (/).



2. Kugirango tubare kandi bisohoke ibisubizo byayo kuri monitor, dukora gukanda kuri buto yintonde.

Nyuma yibyo, Excel izabaza formula hamwe na selile yagenwe izasohoka ibisubizo byibarura.

Niba kubara bikozwe hamwe ninyuguti nyinshi, hanyuma gahunda yo kwicwa ryabo ikorwa na gahunda ukurikije amategeko yimibare. Ni ukuvuga, mbere ya byose, amacakubiri no kugwiza, hanyuma wongere kandi ukureho.

Nkuko bizwi, kugabana kuri 0 nigikorwa kitari cyo. Kubwibyo, hamwe no kugerageza kubara muri kallle muri selire, ibisubizo "# Del / 0!" Bizagaragara.

Isomo: Kora hamwe na formulaire muri excel

Uburyo 2: Kugabanya ibiri muri selile

Muri Excel, urashobora kugabanya amakuru muri selile.

1. Dutanga mu Kagari aho ibisubizo byo kubara bizerekanwa. Twabishyize ikimenyetso "=". Byongeye, kanda aha hantu delimi iherereye. Iyi aderesi igaragara muri formula kumurongo nyuma yikimenyetso "kingana." Ibikurikira, washyizeho ikimenyetso "/" kuri clavier. Kanda ku kagari aho utandukanye. Niba aba bakozi muburyo bumwe, nko muburyo bwabanje, turabigaragaza byose, kandi mbere yuko aderesi zabo zishyira ikimenyetso cyamacakubiri.



2. Kugirango ukore igikorwa (kugabana), kanda kuri buto "Enter".

Urashobora kandi guhuza, nkumugaba ugabana cyangwa utandukanye ukoresheje icyarimwe aderesi ya selile namabare.

Uburyo 3: Igice cy'inkingi ku nkingi

Kubara mumeza, indangagaciro zinkingi imwe zisabwa kugirango zigabanye amakuru ya kabiri. Birumvikana, urashobora gusangira agaciro ka buri selire muburyo bwerekanwe hejuru, ariko urashobora gukora ubu buryo byihuse.

1. Hitamo selile yambere mu nkingi aho ibisubizo bigomba kwerekanwa. Dushyira ikimenyetso "=". Kanda kuri garagaza. Twinjije ikimenyetso "/". Kanda kuri selile.



2. Kanda kuri bouton yinjira kugirango ubaze ibisubizo.



3. Rero, ibisubizo birabarwa, ariko kumurongo umwe gusa. Kugirango ubare mumirongo, ugomba gukora intambwe zavuzwe haruguru kuri buri kimwe muri byo. Ariko urashobora kuzigama cyane umwanya wawe mugukora manipulation imwe. Shira indanga kuruhande rwiburyo bwa selire hamwe na formula. Nkuko mubibona, igishushanyo kigaragara muburyo bwumusaraba. Yitwa Ikimenyetso cyuzuye. Kanda buto yimbeba hanyuma hanyuma ukure ikimenyetso cyuzuza kugeza kumpera yameza.

Nkuko dushobora kubibona, nyuma yibi bikorwa, uburyo bwo kugabanya inkingi imwe ku wa kabiri bizashyirwa mubikorwa byuzuye, kandi ibisubizo bikurwaho mu nkingi zitandukanye. Ikigaragara ni uko binyuze mu kurangara ku cyunga, formula yandukuwe kuri selile yo hasi. Ariko, bazirikana ko bitewe, ibyerekezo byose bifitanye isano, kandi ntabwo byuzuye, hanyuma muri formula, uko bimuka, aderesi ya selile byahinduwe ugereranije na bami bahuza. Aribyo, ibi birakenewe kuri twe ku rubanza runaka.

Isomo: Nigute ushobora gukora autocomplete muri excel

Uburyo 4: Inkingi yicyemezo kuri buri gihe

Hariho imanza mugihe ari ngombwa kugabana inkingi kumubare umwe uhoraho - uhoraho, kandi ukureho umubare w'amacakubiri mu nkingi zitandukanye.

1. Dushyize ikimenyetso "bingana" muri selile yambere yinkingi zose. Kanda kuri selile yamagabanyi zuyu mugozi. Shyira ikimenyetso cyamacakubiri. Noneho intoki hamwe na clavier shyiramo numero yifuzwa.



2. Kanda kuri buto ya Enter. Igisubizo cyo kubara kumurongo wambere urerekanwa kuri monitor.



3. Kugirango ubare indangagaciro zindi mirongo, nkigihe cyashize, hamagara ikimenyetso cyuzuye. Muburyo bumwe, burambuye.

Nkuko tubibona, iki gihe amacakubiri nayo arukuri. Muri uru rubanza, mugihe cyo gukoporora amakuru, ikimenyetso cyongeye gukomeza kuba umuvandimwe. Aderesi yinyungu kuri buri murongo ihita ihinduka. Ariko idini ni muriki gihe umubare uhoraho, bivuze ko umutungo ufitanye isano utabireba. Rero, twagabanyijemo ibikubiye mu kagari k'inkingi kuhoraho.

Uburyo 5: Icyemezo cy'inkingi ku Kagari

Ariko icyo gukora niba ukeneye kugabana inkingi kubiri muri selire imwe. N'ubundi kandi, ukurikije ihame ry'ubutegetsi ryerekana, imirongo yo kugabana, igabanuka izamukwa. Tugomba gukora adresse ya selile hamwe nubucamye bukosowe.

1. Shyira indanga kumuringizo wo hejuru kugirango werekane ibisubizo. Dushyira ikimenyetso "=". Kanda ahashyirwaho kugabana, aho hari agaciro gahinduka. Dushyiramo ibice (/). Kanda ku kagari aho itandukaniro rihoraho riri.



2. Kugirango ugaragaze ko utandukanye rwose, ni ukuvuga, shyira ikimenyetso cyamadorari ($) muri formula imbere yiyi sakuru yiyi selile ihagaritse kandi itambitse. Noneho iyi aderesi izaguma mugihe cyo gukoporora marike yuzuye idahindutse.



3. Twanditse kuri buto yinjira kugirango yerekane ibisubizo byo kubara kumurongo wambere kuri ecran.



4. Gukoresha ikimenyetso cyuzuye, wandukure formula mumiseli isigaye hamwe nibisubizo rusange.

Nyuma yibyo, ibisubizo byiteguye ku nkingi yose. Nkuko dushobora kubibona, muriki gihe, inkingi yagabanijwemo akagari hamwe na aderesi ihamye.

Isomo: Ihuza ryuzuye kandi ugereranije kuri Excel

Uburyo 6: Imikorere yihariye

Gutanga muri Excele birashobora kandi gukorwa hakoreshejwe imikorere idasanzwe yitwa wenyine. Kwiyongera kwibi biranga ni uko bigabanyijemo, ariko nta gisilara. Ni ukuvuga, mugihe ukoresheje ubu buryo bwo kugabana ibisubizo, hazabaho integer. Muri icyo gihe, kuzenguruka ntibikurikije amategeko yimibare muri rusange kugeza kumutekano wegereye, ariko kuri module nto. Ni ukuvuga, umubare 5.8 imikorere izenguruka kugeza kuri 6, na 5.

Reka turebe ishyirwa mubikorwa kurugero.

1. Kanda ku kagari, aho ibisubizo byo kubara bizerekanwa. Kanda kuri "Shyiramo imikorere" ibumoso bwimirongo ya formula.



2. Umupfumu arakingura. Kurutonde rwimikorere iduha, turimo gushaka ikintu "wenyine". Turabigaragaza kandi tugakanda buto "OK".



3. Gufungura idirishya ryimpaka zifunguye. Iyi mikorere ifite impaka ebyiri: kubara no mu cyubahiro. Batangijwe mumirima hamwe namazina ahuye. Mu murima "kubara" twinjira muri delimi. Muri "akaga" - Guhinduka. Urashobora kwinjiza imibare yombi hamwe na aderesi ya selile aho amakuru aherereye. Nyuma yuko indangagaciro zose zinjiye, kanda buto "OK".

Nyuma yibi bikorwa, ikintu cyigenga gituma amakuru atunganya kandi agatanga igisubizo kuri selire, cyerekanwe mu ntambwe yambere yubu buryo bwo kugabana.

Iyi mikorere irashobora kandi kwinjizwa intoki adakoresheje umupfumu. Syntax yayo isa nkiyi:

= Abikorera (umubare; icyerekezo)

Isomo: Umukozi wa Wizard muri Excel

Nkuko tubibona, inzira nyamukuru yo kugabana muri gahunda ya Microsoft ni ugukoresha formulaire. Ikimenyetso cya kabiri muri byo ni ugukubita - "/". Muri icyo gihe, kubikorwa bimwe, birashoboka gukoresha umurimo wihariye mubice. Ariko, birakenewe kuzirikana ko mugihe cyo kubara muri ubu buryo, itandukaniro riboneka ridafite ibisigisigi, integer. Muri icyo gihe, kuzenguruka ntabwo byemewe muri rusange, ahubwo ni module ntoya munkunga.