Ingero za "Smeroi" muri Excel

Syntax n'imikorere

Imikorere irakunzwe cyane, kuko hafi ya buri meza, ni ngombwa kubara igiteranyo cyimibare iri hagati yingirabuzimafatizo, yirengagije indangagaciro zidagwa munsi yimiterere nyamukuru. Urakoze kuri iyi formula, kubara ntabwo bigoye kandi birebire. Imikorere isanzwe ikurura = guceceka (intera; urwego Niba amakuru ari mu "Gukangura incamake" yabuze, selile zose zishyizwe mu "Range" zizasuzumwa.

Tuzasesengura ingingo ebyiri zisigaye - "urwego" n "" ibipimo ". Ibice byambere byingirabuzimafatizo (A1: A100) bihuye (A1: A100), bizagenzurwa kandi ugereranije nibisabwa. Mu "ngingo", umukoresha azana imiterere, mugihe ukora selile abamwe mumagambo. Ibi birashobora kuba imiterere yubusumbane bwimibare (50) cyangwa kubahiriza inyandiko yagenwe ("inyandiko"). Koroshya gusobanukirwa no kwishyiriraho impaka, fungura idirishya ribishushanyo "hanyuma ushireho ibisabwa byose.

Nta ngero nyinshi zitandukanye, ibiranga byuzuye bikwiye urebye mugihe umurimo ucecetse, hanyuma umenyane kandi uzwi cyane.

Imikorere iracecetse munsi yubusumbane

Urugero rwambere ni ugukoresha imikorere yimikorere, mugihe umubare wa hit ugomba kuba kinini, gake cyangwa udahwanye numubare wagenwe. Hamwe na syntax nkiyi, imikorere igenzura selile zose zurwego rwagenwe kandi zifata neza. Intoki zirayindika binyuze mumirima yinjiza igizwe nibice byinshi:

1. Menya urutonde rwa selile zigwa kuri formula, tuzagira inyungu ukwezi.



2. Tangira kwinjira mumabwiriza yayo mumwanya winjiza wiyandikishije ubwabo.



3. Kora uduce dufungura no gufunga aho winjije urwego rwa selile zatoranijwe, kurugero C2: C25. Nyuma yibyo, menya neza gusinya; bivuze iherezo ryimpaka.



4. Fungura amagambo hanyuma usobanure uko ibintu byacu bizaba> 300000.



5. Mugihe ukimara gukanda urufunguzo rwa Enter, imikorere irakorwa. Mu ishusho, biragaragara ko selile ebyiri gusa zihuye nibisabwa> 300000 rero, formula yakanze incamake umubare wabo kandi yerekana muburyo butandukanye.

Hejuru, imwe mu ngero zifite impanuka yafashwe ku bw'impanuka yarasenywaga. Ntakintu kizarinda ikintu cyose gusimbuza izindi ndangagaciro, kwagura cyangwa kugabanya intera - formula izakomeza gusuzuma agaciro niba amategeko ya Syntax yubatswe.

Imikorere iracecetse, hashingiwe kumyandikire

Fata urugero rwa kabiri iyo bacecetse bakundaga kubara amafaranga mu tugari bihubahirizwa hamwe ninyandiko mubindi byose. Ibi bizaba ingirakamaro, kurugero, mugihe igiciro cyose cyibicuruzwa mubi cyiciro kimwe kibarwa, cyangwa amafaranga yikigo kumushahara kubakozi babarwa kumyanya yihariye. Urugero rwo kwiyandikisha muriki gihe kiracyashimishije kumenya ko syntax ihinduka gato, kubera ko imiterere igwa selile ya kabiri.

1. Iki gihe, hiyongereyeho intera ya selile zinyuranye, menya aho habaye inyandiko mubihe.



2. Tangira gufata imikorere uhereye kumazina muburyo bumwe nkuko bimaze kugaragara hejuru.



3. Ubwa mbere, andika gusohora inyandiko, shyira; Hanyuma ushireho imiterere. Noneho iyi mvugo muburyo bwa syntactique izinguka hafi yubu bwoko: A2: A25; "Nzeri";



4. Nk'impaka za nyuma, hasigaye kwerekana urwego rwa selile, umubare wacyo uzaciriritse muburyo bukwiye. Usanzwe umenyereye amategeko yo kwandika impaka nkiyi.



5. Reba imikorere y'ibikorwa. Turagaragaza ukwezi kwa Nzeri nkibisabwa turebe kumeza, bivuga muri make indangagaciro ebyiri za selile zihuye nayo. Amakuru asigaye mugihe kugenzura birirengagijwe gusa.

Simbuza ijambo cyangwa wandike interuro yose, ukurikije ikimenyetso cyo kwerekana iyo ubara indangagaciro zisabwa.

Imikorere miremire ifite ibintu byinshi

Twarangije gusesengura ingero muburyo bwa gatatu, mugihe ibintu byo kongeramo icyarimwe. Hamwe no kubara, imikorere isuzumwa nisi yahinduwe svmemalimn yahinduwe, igufasha gushiraho impaka zirenze imwe, zidashobora gushyirwa mubikorwa muri verisiyo yambere. Imwe mu ngero zoroshye hamwe ninzandiko zuzuye za Syntactic zakozwe nkibi bikurikira:

1. Fata ameza aho hari indangagaciro eshatu zitandukanye haba kumakuru ahari kandi ukurikije ubwoko bwabo. Nukwezi, inyungu rusange hamwe numubare wibicuruzwa byagurishijwe. Muri formulaire hamwe nibintu byinshi, birakenewe gusa ibyo ibisubizo byinyungu gusa, byabonetse muri Nzeri hamwe nagurishijwe hejuru yimirimo 29.



2. Tangira kwinjira muri AD isanzwe = Imivurure, fungura imitwe hanyuma wandike selile zinyuranye. Ntiwibagirwe gufunga itangazo ry'ikimenyetso cy'impaka;



3. Gukurikira ingingo ya kabiri - guhura nizina muri kasho. Kwandika iyi parameter byari bimaze gufatwa hejuru kandi birashobora kuboneka na none mumashusho.



4. Imiterere ya gatatu nicyo cyandikirana ubusumbane bwateganijwe, twamenyereye mu ntangiriro yingingo. Na none muburyo bumwe, vuga indangagaciro hamwe nubusumbane ubwabwo muri cote. Ntiwibagirwe gushyira musoza ufunga, bityo urangije umurimo wo kwandika.



5. Byuzuye, umurongo wiki gikorwa ufite urupapuro = svumprempdomplime (c2: c25; A2: A2: A2; B2: 29 "), ariko urashobora kuyihindura wenyine kandi ukabona ingaruka nziza gusa. Birashobora gusa nkaho bigoye gutangaza buri mpaka kandi ntitukitiranya inyuguti, ariko hamwe nuburyo butandukanye ntihagomba kubaho.

Barashonga kandi barwaye imibare yimibare bafite ihagarariye syntactique, ariko bakoreshwa mubihe bitandukanye. Gusoma amakuru kuri formulaire zose zizwi muri excel, reba ibikoresho byerekana hepfo.

Soma Ibikurikira: Imibare 10 yimibare yamamare Microsoft Excel