Nei Excel isingarangarire iyo formula: 5 mhinduro kune dambudziko

Imwe yeiyo yakakurumbira Excel maficha ari kushanda neFormas. Kutenda kune iri basa, chirongwa chakazvimirira chinoburitsa kuverenga kwakasiyana siyana mumatafura. Asi dzimwe nguva zvinoitika kuti mushandisi anopinda muchitokisi muchitokisi, asi haazadzikise nzvimbo yayo yakananga - kuverenga mhedzisiro yacho. Ngatishandei nezvazvinogona kubatana ne uye maitiro ekugadzirisa dambudziko iri.

Kubviswa kwemakomputa matambudziko

Zvinokonzera matambudziko nekuverenga maFomulas muExcel inogona kuve yakasiyana zvachose. Ivo vanogona kuve nekuda kweiyo chaiyo bhuku marongero kana kunyange zvikamu zvakasiyana zvemasero uye zvikanganiso zvakasiyana mu syntax.

Nzira 1: Shanduko Muchero Fomu

Chimwe chezvikonzero zvakajairika kuti nei Excel asingafunge kana kuti kwete kunyatsofunga formula, ndiyo mhando isiriyo yemasero. Kana huwandu hwacho huchiita rugwaro, kuverenga kwemashoko mariri hakuitwe zvachose, ndiko kuti, zvinoratidzwa seyakajairika rugwaro. Mune zvimwe zviitiko, kana chimiro chacho chisingaenderane nemhedzisiro yeiyo data yakaverengerwa, mhedzisiro yakadzingwa muchitokisi inogona kunge isingaratidzirwe nemazvo. Ngatitsvagei kugadzirisa dambudziko iri.

1. Kuti uone kuti ndechipi chimiro chiteshi kana huwandu, enda ku "imba" tab. Pamutepi mu "Nhamba" Chishandiso Block kune munda wekuratidzira iyo yazvino fomati. Kana paine zvinorehwa ne "zvinyorwa", ipapo iyo formula haizoverengerwa chaizvo.



2. Kuti uchinje chimiro kuti ubate pane ino ndima. Rondedzero yekusarudza kurongedza ichavhurika, kwaunogona kusarudza kukosha kunoenderana neicho chirevo chefomati.



3. Asi kusarudzwa kwemhando dzemhando kuburikidza ne tepi haina kukura zvakanyanya sepabhuku newindo rakakosha. Naizvozvo, zviri nani kushandisa yechipiri fomati sarudzo. Sarudza iyo tarisiro renji. Dzvanya pairi kurudyi mbeva bhatani. Mune zvirevo zvemenyu, sarudza iyo "cell form fomati" chinhu. Iwe unogona zvakare mushure mekunge chikamu chakatsaurwa, tinya iyo CTRL + 1 Kiyi musanganiswa.



4. Iyo windo rinoratidzira rinovhura. Enda ku "nhamba" tab. Mu "nhamba yemafungiro" block, sarudza chimiro chatinoda. Pamusoro pezvo, kurudyi kwewindow, zvinokwanisika kusarudza mhando yekuratidzira yeiyo chaiyo fomati. Mushure mekusarudza kuitwa, tinya pane "ok" bhatani, yakaiswa pazasi.



5. Sarudza masero pamwe neiyo basa racho harina kutariswa, uye nekudzokorora, kudzvanya kiyi yeF2 yeF2.

Iye zvino fomula ichaverengerwa mune yakajairwa kurongeka pamwe nekubuda kwemhedzisiro muchitokisi chakataurwa.

Nzira 2: Kubvisa iyo "Ratidza Formulas" mode

Asi zvinokwanisika kuti panzvimbo pemhedzisiro yekuverenga, iwe unoratidzwa zvirevo, ndezvekuti chirongwa "chinoratidza mafomula" chinosanganisirwa muchirongwa.

1. Kugonesa kuratidzwa kwemigumisiro, enda ku "formula" tab. Pamutepi mu "Frenchency kutsveneswa" chishandiso block, kana iyo "Ratidza formula" bhatani rinoshanda, wobva wadzvanya pachiri.



2. Mushure mekuita uku mumasero zvakare, mhedzisiro yacho icharatidzwa panzvimbo yeiyo syntax yemabasa.

Nzira 3: kururamisa kwekukanganisa mu syntax

Iyo formula inogona zvakare kuratidzwa semavara kana zvikanganiso zvakagadzirwa mu syntax yayo, semuenzaniso, tsamba yapfuura kana kuchinjwa. Kana iwe ukaita iwe pachako, uye kwete kuburikidza nemabasa ehunyanzvi, saka zvakadaro zvinogona kuitika. Iko kukanganisa kwakajairika kwakabatana nekuratidzwa kwechirevo, kunge rugwaro, ndiko kuvapo kwenzvimbo pamberi pechiratidzo "=".

Muzviitiko zvakadaro, zvinodikanwa kunyatsoongorora iyo syntax yeaya mafomu ayo anoratidzwa zvisiri izvo uye gadzirisa zvakakodzera.

Nzira yechina: kusanganisa kwekudzokorora kwefomula

Pane mamiriro ezvinhu akadaro kuti formula inoratidzika senge uye inoratidza kukosha, asi kana ichichinja masero anoenderana nazvo pachayo haachinji, kureva kuti, mhedzisiro yacho haina kudzikiswa. Izvi zvinoreva kuti iwe wakasarudzika zvisina kufanira ma paramita mubhuku iri.

1. Enda kune "faira" tab. Kuve mairi, iwe unofanirwa kudzvanya pane "parameter" chinhu.



2. Iyo paramende hwindo rinovhura. Iwe unofanirwa kuenda ku "mafomu" chikamu. Mu "computing marongero" anovhara, ayo ari kumusoro kwehwindo, kana mu "kuverenga mubhuku" paramende, iyo otomatiki "chinzvimbo, saka ichi ndicho chikonzero nei mhedzisiro ye kuverenga hakuna basa. Ronga switch kune chinzvimbo chaunoda. Mushure mekuita zvimiro zviri pamusoro apa kuti uvanunei pazasi pewindo, tinya bhatani re "OK".

Iye zvino zvese zviratidzo mubhuku iri zvichange zvozvakadzokororwa kana paine chero kukosha kwakabatana kuchinja.

Nzira 5: Kukanganisa mune formula

Kana chirongwa ichi chichiri kuita kuverenga, asi semhedzisiro yacho inoratidza chikanganiso, saka mamiriro acho anogona kuti mushandisi anongogona kukanganisa kana achipinda chirevo. Iwo maForneous mafomula ndeaya evaya kana achiverengera kuti zvinotevera zvinotevera zvinoonekwa muchitokisi:

• #Number!;
• # Zvinoreva!;
• # Isina!;
• # Del / 0!;
• # N / d.

Mune ino kesi, iwe unofanirwa kutarisa kana iyo data yacho yakanyorwa nemazvo mumasero yakaratidzirwa neshoko, kunyangwe pasina zvikanganiso mune iyo syntax kana haina kuiswa mufomu

Kana basa racho rakaoma, rine nhamba huru yemasero ane hukama, zviri nyore kuteedzera kuverenga uchishandisa chishandiso chakakosha.

1. Sarudza chitokisi nechikanganiso. Enda kune "mafomu" tab. Pamutepi mu "departency kutsveneswa" chishandiso block nekudzvanya pane "Concalate formula" bhatani.



2. Hwindo rinovhura, rinoratidzika kunge rakazara kuverenga. Dzvanya pane "Converlate" bhatani uye tarisa kuverenga kwedanho nhanho. Tiri kutsvaga kukanganisa uye kubvisa.

Sezvatinoona, zvikonzero zvekuti kukurira hakufungisiti kana kusarangarira nenzira kwayo iyo formula, inogona kuve yakasiyana zvachose. Kana mushandisi akaratidzwa pachinzvimbo chekuverenga mushandisi, basa iro pacharo rinoratidzwa, mune ino kesi, kazhinji, kana sero racho rakaumbwa, kana chirevo chekutarisa mamiriro akavhurwa. Zvakare, zvinokwanisika kukanganisa mu syntax (semuenzaniso, kuvapo kwenzvimbo pamberi pe "=" chiratidzo). Kana mushure mekushandura iyo data iri mumasero ane hukama, mhedzisiro yacho haina kuvandudzwa, ipapo iwe unofanirwa kuona kuti iyo auto-update yakagadzirirwa mubhuku rebhuku. Zvakare, kazhinji panzvimbo yemhedzisiro chaiyo muchitokisi chikanganiso chinoratidzwa. Pano iwe unofanirwa kuona zvese kukosha kwakaratidzwa nebasa racho. Kana iri yekukanganisa kuwanikwa, inofanira kubviswa.