Kuki Excel idasuzuma formula: ibisubizo 5 byikibazo

Kimwe mu bintu bizwi cyane cyane bikora hamwe na formulaire. Urakoze kuri iki gikorwa, gahunda yigenga itanga inzara zitandukanye mumeza. Ariko rimwe na rimwe bibaho ko umukoresha yinjira kuri formula mu Kagari, ariko ntabwo asohoza aho yerekeza - kubara ibisubizo. Reka duhangane nibyo bifitanye isano nuburyo bwo gukemura iki kibazo.

Kurandura ibibazo byo kubara

Impamvu zitera ibibazo hamwe no kubara formulaire muri excel zirashobora gutandukana rwose. Birashobora guterwa nigitabo cyihariye cyangwa hamwe nurwego rwihariye rwa selile namakosa atandukanye muri syntax.

Uburyo 1: Guhindura muburyo bwa selire

Imwe mumpamvu zikunze gutuma Abanyabwenge badasuzuma cyangwa badasuzuma neza formula, nuburyo busobanutse bwa selile. Niba intera ifite imiterere yinyandiko, kubara imvugo muribi ntabwo bikorwa na gato, nibyo, byerekanwe nkinyandiko isanzwe. Mu bindi bihe, niba imiterere idahuye ningaruka zamakuru yabazwe, ibisubizo byimuwe mu Kagari ntibishobora kwerekanwa neza. Reka tumenye uburyo bwo gukemura iki kibazo.

1. Kugirango tubone imiterere ni selile yihariye cyangwa intera, jya kuri tab "urugo". Kuri kaseti muri "Umubare" wibikoresho Hariho umurima wo kwerekana imiterere iriho. Niba hari ibisobanuro bya "inyandiko", noneho formula ntabwo izabarwa neza.



2. Kugirango uhindure imiterere kugirango ukande kuri uyu murima. Urutonde rwo guhitamo ruzakinguye, aho ushobora guhitamo agaciro kajyanye na formulaire.



3. Ariko guhitamo ubwoko bwimiterere binyuze kuri kaseti ntabwo nini cyane nkuko binyuze mumadirishya yihariye. Kubwibyo, nibyiza gukoresha uburyo bwa kabiri bwo guhitamo. Hitamo intego. Kanda kuri Iburyo bwimbeba. Mubice bikubiyemo, hitamo "imiterere ya" selile ". Urashobora kandi nyuma yo kwigunga, kanda Ctrl + 1 urufunguzo.



4. Idirishya rifungura. Jya kuri tab "umubare". Muri "imiterere yumubare", hitamo imiterere dukeneye. Byongeye kandi, kuruhande rwiburyo bwidirishya, birashoboka guhitamo ubwoko bwo kwerekana imiterere yihariye. Nyuma yo guhitamo, kanda kuri buto ya "OK", yashyizwe hepfo.



5. Hitamo selile Ubundi Imirimo itasuzumwe, kandi yo kwisubiraho, kanda urufunguzo rwa F2.

Noneho formula izabarwa muburyo busanzwe hamwe nibisubizo byavuye mu kagari kagenwe.

Uburyo 2: Guhagarika uburyo "bwo kwerekana"

Ariko birashoboka ko aho kubara, urerekanwa imvugo, ni uko gahunda "yerekana formulaire" irimo muri gahunda.

1. Gushoboza kwerekana ibisubizo, jya kuri tab "formula". Kuri kaseti mu "kwishingikiriza" gutunganya ", niba" kwerekana formula "bikora, hanyuma ukande kuri yo.



2. Nyuma yibi bikorwa byongeye mu tugari, ibisubizo bizerekanwa aho kuba syntax yimikorere.

Uburyo 3: Gukosora ikosa muri syntax

Fortabu irashobora kandi kugaragara nkinyandiko niba amakosa yakozwe muri syntax yayo, kurugero, ibaruwa yanyuze cyangwa yahinduwe. Niba winjiye mu ntoki, kandi ntabwo binyuze mu mikorere shobuja, ibyo bishoboka rwose. Ikosa risanzwe cyane rijyanye no kwerekana imvugo, nkinyandiko, ni ukubaho umwanya mbere yikimenyetso "=".

Mu bihe nk'ibi, birakenewe gusuzuma neza syntax yibyo formulate itagaragara kandi igahindura bikwiye.

Uburyo 4: Kwinjiza kwisubiraho formula

Hariho ibintu nkibi formulate isa kandi igaragaza agaciro, ariko mugihe ihindura selile zijyanye nayo ntabwo ihinduka, ni ukuvuga, ibisubizo ntabwo bivazwa. Ibi bivuze ko washyizeho ibipimo byo kubara muri iki gitabo.

1. Jya kuri tab "dosiye". Kuba muri yo, ugomba gukanda kuri "ibipimo".



2. Idirishya rya Parameter rifungura. Ugomba kujya mu gice cya "formulas". Muri "Igenamiterere ryabashinzwe", riherereye hejuru yidirishya, niba muri "kubara mu gitabo" Ibipimo, byihutirwa ", noneho iyi niyo mpamvu zituma ibisubizo bya kubara ntaho bihuriye. Ongera utegure uhinduka kumwanya wifuza. Nyuma yo gukora igenamiterere ryavuzwe haruguru kugirango ubakize munsi yidirishya, kanda buto "OK".

Noneho imvugo zose muri iki gitabo izahita ibazwa mugihe impinduka zose zijyanye.

Uburyo 5: Ikosa muri formula

Niba gahunda ikomeje kubara, ariko kubwibyo byerekana ikosa, noneho ibintu birashoboka ko uyikoresha aribeshya gusa mugihe winjiye. ITANGAZO RIDASANZWE NIBA Iyo IRABARA IZINA RIKURIKIRA ZIKURIKIRA MU NOKA:

• #Number !;
• # Bivuze !;
• # Ubusa !;
• # Del / 0 !;
• # N / d.

Muri iki kibazo, ugomba kugenzura niba amakuru yatowe neza mu kagari bivugwa nimvugo, yaba amakosa muri syntax cyangwa ntabwo ashyizwe muri formature igikorwa icyo aricyo cyose (urugero, amacakubiri ya 0).

Niba imikorere igoye, ifite umubare munini wibiceri bifitanye isano, biroroshye gutondekanya kubara ukoresheje igikoresho kidasanzwe.

1. Hitamo Akagari ufite ikosa. Jya kuri tab "formulaire". Kuri kaseti mu "kwishingikiriza" ibikoresho byo kwishingikiriza ukanze kuri buto ya "Kubara Fortulate".



2. Idirishya rifungura, risa naho kubara byuzuye. Kanda kuri buto ya "Kubara" hanyuma urebe kubara intambwe ku yindi. Turimo gushaka amakosa tukabikuraho.

Nkuko tubibona, impamvu zituma Excel idasuzuma cyangwa idasuzuma neza formula, irashobora gutandukana rwose. Niba umukoresha yerekanwe aho kubara umukoresha, imikorere ubwayo irerekanwa, muriki gihe, birashoboka cyane, cyangwa selile itondekanya inyandiko, cyangwa selile ibona uburyo bwo gufungura. Kandi, birashoboka kwibeshya muri syntax (kurugero, kuboneka umwanya mbere ya "=" ikimenyetso). Niba nyuma yo guhindura amakuru mubisubizo bifitanye isano, ibisubizo ntabwo bivugururwa, ugomba rero kubona uburyo auto-ivugurura ryashyizweho mugitabo. Kandi, akenshi aho kuba ibisubizo byukuri mu Kagari Ikosa ryerekanwa. Hano ukeneye kureba indangagaciro zose zerekejwe kumikorere. Mugihe habaye ikosa kumenya, bigomba kuvaho.