Fomula Division muExpital muExcel: 6 Sarudzo dzakareruka

MuMicrosoft Excel, chikamu chinogona kuitwa zvese nerubatsiro rweFormas uye kushandisa mabasa. Kunyengedza uye kurambana kunoita huwandu uye kero dzemasero.

Nzira 1: Nhamba dzekuparadzanisa nhamba

Bepa reBexcel rinogona kushandiswa serudzi rweCalculator, kungogovana nhamba imwe kune imwe. Chikwangwani cheChikamu chinodurura chinjana (reverse mutsara) - "/".

1. Isu tinova mune chero sero remahara repepa kana mufomula tambo. Isu tinoisa chiratidzo "chakaenzana" (=). Isu tinogamuchira nhamba yakamutsa kubva kukhibhodi. Isa chiratidzo chejira (/). Isu tinogamuchira chikamu kubva mukhibhodi. Mune zvimwe zviitiko, vamiririri vanopfuura mumwe. Zvadaro, pamberi pegivi yega yega, tinoisa iyo slash (/).



2. Kuti uite kuverenga uye kubudiswa kwayo mhedzisiro pane iyo yekutarisa, isu tinoita iyo tinya pane bhatani rePeturu.

Mushure meizvozvo, Excel ichaverengera fomula uye kuchekwa yakataurwa ichaburitsa mhedzisiro yekuverenga.

Kana kuverenga kwacho kuchinge kwakaitwa nevatambi vakati wandei, saka kurongeka kwekuti kuurayiwa kwavo kunoitwa nechirongwa zvinoenderana nemitemo yemasvomhu. Ndokutanga, kutanga pane zvese, kupatsanurana uye kuwanda kunoitwa, uye zvakare zvakare uye kubvisa.

Sezvazvinozivikanwa, kupatsanura pane 0 chisiriro chisina kunaka. Naizvozvo, nekuedza kwakadaro kuita kuti kuverenga kwakadaro mukubatana muchitokisi, mhedzisiro "# del / 0!" Ichaonekwa.

Chidzidzo: Shanda neFordelas muExcel

Nzira 2: Kukamura zviri mukati memasero

Zvakare muExcel, iwe unogona kupatsanura iyo data mumasero.

1. Isu tinogovera muchitokisi mukati mayo mhedzisiro yekuverenga icharatidzwa. Isu tinoisa mariri chiratidzo "=". Kupfuurirazve, tinya panzvimbo iyo Delimi iri kuwanikwa. Kero iyi inoonekwa mune formula mutsara mushure mekunge chiratidzo "chakaenzana." Tevere, iwe unoisa iyo "/" chiratidzo kubva kukhibhodi. Dzvanya pane iyo cell umo mutengi aripo. Kana mapoka mazhinji akatiza, sezvazviri munzira yapfuura, tinovadzidzisa vese, uye kero yavo isati yaisa chiratidzo cheboka.



2. Kuti uite chiito (chikamu), tinya pane "Pinda" bhatani.

Iwe unogona zvakare kusanganisa, sekukatsana kana kugovera uchishandisa panguva imwe chete cell kero uye nhamba dzegumi.

Nzira 3: Column Division paColumn

Kuti uverenge mumatafura, iwo manyoro eimwe ikoramu anowanzo kudiwa kupatsanura data rechipiri. Ehezve, iwe unogona kugovera kukosha kwesero rega rega munzira inoratidzwa pamusoro, asi iwe unogona kuita izvi nekukurumidza.

1. Sarudza iyo yekutanga sero mukoramu uko mhedzisiro inofanira kuratidzwa. Isu tinoisa chiratidzo "=". Tinya pane sero rekugovera. Isu tinogamuchira chiratidzo "/". Dzvanya pane contider cell.



2. Dzvanya pane iyo Enter bhatani kuti uverenge mhedzisiro.



3. Saka, mhedzisiro yacho yakaverengerwa, asi chete yemutsara mumwe. Kuti uverenge mune mamwe mitsara, iwe unofanirwa kuita matanho ari pamusoro apa kune mumwe nemumwe wavo. Asi iwe unogona kuchengetedza zvakanyanya nguva yako nekuita nekuita kwekunyengera kweumwe. Gadza iyo yekukona kukona yekurudyi yekona yechitokisi ine formula. Sezvauri kuona, chiratidzo chinoonekwa muchimiro chemuchinjikwa. Inonzi iyo yekuzadza mucherechedzo. Dzvanya bhatani rekuruboshwe mbeva uye dhonza iyo inozadza mucherechedzo pasi kusvika kumagumo etafura.

Sezvatinogona kuona, mushure mekuita uku, maitiro ekugovera imwe ikholamu pane yechipiri achanyatsoitwa, uye mhedzisiro yacho inobviswa mune imwe ikhoramu. Icho chokwadi ndechekuti kuburikidza nekuzadza mucherechedzo, iyo formula inoteedzerwa kumasero epazasi. Asi, kufunga nezve chokwadi chekuti nekukanganisa, zvese zvinongedzo, uye kwete mhedziso, ipapo muchimiro, sezvazvinofamba pasi, kero dzemasero inoshandurwa pamwe neanotanga kuronga. Nenzira, izvi zvinodikanwa kwatiri kune imwe nyaya.

Chidzidzo: Maitiro ekuita autocomplete muExcel

Nzira 4: Chisarudzo Chisarudzo pane kugara

Pane zviitiko pazvinenge zvichidikanwa kupatsanura chikamu pane imwe nguva dzose nguva dzose nhamba - nguva dzose, uye ubvise huwandu hweboka rakaparadzana.

1. Isu tinoisa chiratidzo "chakaenzana" muchitokisi chekutanga chekamuri yakazara. Dzvanya pane imwe cell cell yetambo iyi. Isa chiratidzo chekuparadzanisa. Wobva waita kunge nekhibhodi yakaisa nhamba yaunoda.



2. Dzvanya pane iyo Enter bhatani. Mhedzisiro yekuverenga kwetambo yekutanga inoratidzwa pane iyo yekutarisa.



3. Kuti uverenge zvimamwe tsika kune mamwe mitsara, sezviri munguva yapfuura, daidzira iyo inozadza mucherechedzo. Nenzira imwecheteyo, tidzorere pasi.

Sezvatinoona, panguva ino chikamu chakakamurwa zvakare. Mune ino kesi, kana kutevedzera data, chirevo chinorwadza zvakare hama. Iyo Diviidend kero yemutsara wega wega yakachinja. Asi chikamu chevatengi chiri mune ino nyaya inogara ichiverengero, zvinoreva kuti nzvimbo yehurumende haina kushanda pazviri. Nekudaro, isu takakamura zvirimo zve column masero kune anogara achienderera.

Nzira 5: Chisarudzo chetsiva pachiteshi

Asi zvekuita kana iwe uchifanira kupatsanura chikamu pane zviri mukati mechitokisi chimwe. Kupfuura zvese, maererano nehushe hwehurumende yezviratidzo, maironga ekugovanisa uye mutungamiri achachinjika. Isu tinofanirwa kuita kero yechitokisi nejivi yakatarwa.

1. Isa iyo isaor kune yakakwirira column cell kuratidza mhedzisiro. Isu tinoisa chiratidzo "=". Dzvanya pane kuiswa kweiyo kupatsanurana, mune iyo iripo kukosha kwakasiyana. Isu tinoisa slash (/). Dzvanya pane sero umo muiti wechigarire riripo.



2. Kuti uite chirevo chevatongi, izvo, zvinogara, isa chiratidzo chedhora ($) mune formula pamberi pemafundo yechitunha ichi chose uye yakatwasuka. Iye zvino kero iyi icharamba iri painotevedzera iyo inozadza mucherechedzo haina kuchinjika.



3. Isu tinodzvanya pane iyo Enter bhatani kuti iratidze iyo yekuverenga inoguma iri pamutsetse wekutanga pachiratidziri.



4. Uchishandisa chiratidzo chekuzadza, teedzera formula mune yakasara yemakamuri masero ane mhedzisiro.

Mushure meizvozvo, mhedzisiro yacho yakagadzirira iyo chikamu chose. Sezvatinogona kuona, mune ino kesi, iyo chikamu chakakamurwa kuita sero nekero yakatarwa.

Chidzidzo: Mhedziso uye hukama hwehukama kuti ubude

Nzira 6: Yakavanzika Basa

Dhirivhari mukubudisira inogona zvakare kuitwa uchishandisa yakakosha basa inonzi yakavanzika. Icho chidimbu chechinhu ichi ndechekuti inoparadzanisa, asi isina yakasara. Ndokunge, kana uchishandisa nzira iyi yekukamura mhedzisiro, pachagara paine nhamba. Panguva imwecheteyo, kutenderera hakuitwe maererano nemitemo yemasvomhu yakagamuchirwa kune iyo iri pedyo nenhamba iri pedyo, asi kune madiki module. Ndokunge, iyo nhamba ye5,8 inogara isingasvike kusvika ku6, uye kusvika ku5.

Ngatione kushandiswa kwechinhu ichi pane muenzaniso.

1. Dzvanya pachiteshi, uko mhedzisiro yekuverenga icharatidzwa. Dzvanya pane iyo "Insert Basa re" bhatani kuruboshwe rwetambo ye formula.



2. Wizard inovhura. Mune rondedzero yemabasa okuti inotipa, tiri kutsvaga chinhu "chakavanzika". Isu tinoratidza uye tinya "OK" bhatani.



3. Yakavhurwa hwindo rekupokana. Iyi ficha ine nharo mbiri: Numerator uye dhinari. Ivo vanoziviswa muminda nemazita anoenderana. Mu "numerator" munda watinotora delimi. Mu "njodzi" munda - mutivi. Iwe unogona kunyora zvese zvakananga nhamba uye kero dzemasero umo iyo data iri kuwanikwa. Mushure mekunge zvese kukosha kwapinda, tinya bhatani re "OK".

Mushure meizvi zviito, iyo yakavanzika inogadzira data yekugadzirisa uye inopa mhinduro kuchitokisi, iyo yakaratidzwa mudanho rekutanga reiyi nzira yekuparadzanisa.

Ichi chimiro chinogona zvakare kuiswa mumanzwiro pasina kushandisa wizard. Yayo syntax inotaridzika seiyi:

= Zvakavanzika (numerator; donominator)

Chidzidzo: Wizard mabasa muExcel

Sezvatinoona, nzira huru yekukamuranisa muMicrosoft Office Chirongwa ndechekushandisa mafomula. Chiratidzo chinoderera mavari ndiro slash - "/". Panguva imwe chete, kune zvimwe zvinangwa, zvinokwanisika kushandisa basa rakavanzika muzvikamu. Asi, zvinodikanwa kuti utarise kuti kana uchiverenga nenzira iyi, mutsauko unowanikwa pasina zvakasara, nhamba. Panguva imwecheteyo, kutenderera hakuitwe nemitemo inowanzogamuchirwa, asi kune madiki maumbu mune nhamba.