Divorce Formulas, # DIV / O! Formula Error, uye Kuverenga Percents
Kuparadzanisa nhamba mbiri iwe unoda kugadzira fomu sezvo pasina DIVIDE basa mu Excel.
Pfungwa dzinokosha kuti uyeuke nezveExcel formula:
- Mifananidzo iri muExcel inotanga nguva dzose nechiratidzo chakaenzana ( = );
- Chiratidzo chakaenzana nguva dzose chinopinda musero iyo iwe unoda kuti mhinduro ipinde;
- Chiratidzo chinopatsanangurira isimboti forward slash ( / );
- Icho chinyorwa chinopedzerwa nekudhinda Enter key pane keyboard.
Achishandisa Cell References muFormulas
Kunyange zvazvo zvichikwanisika kuisa nhamba zvakananga mumushonga, zviri nani kupinda mu data mumashandisi ekushanda uye usingashandisi kero kana kuti zvinyorwa zvemasero aya mumutsetse sezvinoratidzwa mumufananidzo uri pamusoro.
Nokushandisa masero ezvinyorwa - zvakadai seA1 kana C5 - panzvimbo yezviripo data mumutambo, gare gare, kana zvichizodikanwa kuchinja data , iyo nyaya inongova yekutsvaga deta mumasero panzvimbo yekunyorazve maitiro.
Kazhinji, migumisiro yechipfuva ichadzoka pakarepo kana data ichichinja.
Dharura Formula Example
Sezvakaratidzwa mumutsara wechipiri mumufananidzo uri pamusoro, muenzaniso uyu unoumba fomu muchitokisi B2 iyo inoparadzanisa data muchitsetse A2 ne data muA3.
Iyo yakagadzirwa mazai muchitokisi B2 ichave:
= A2 / A3
Kupinda Data
- Tora iyo nhamba 20 muchikamu cheA2 uye tapinda muIndiniti pa keyboard;
- Tora iyo nhamba 10 muchitsetse A3 uye tapinda muIno .
Kupinda Mufomu Pakushandisa
Kunyange zvazvo zvichibvira kungonyora fomu
= A2 / A3
muchitokisi B2 uye vane mhinduro yakarurama ye2 inoratidzirwa mune iyo cell, zviri nani kushandisa inongedzera kuwedzera sero zvinyorwa zvemafomu kuitira kuti kuderedza kuvepo kwekanganiso yakagadzirwa nekunyora mune zvisina kururama sechitsetse.
Kutaura kunosanganisira kuvhara kero iri rine deta pamwe nemushonga we mouse kuti uwedzere kutarisa kwemaferensi kune fomu.
Kuisa mazano:
- Tora chikamu chakaenzana muchitima B2 kuti utange fomu.
- Dzvanya pachitokisi A2 neine mouse pointer kuti uwedzere kuti sero rinotarisa kumushure mushure mekuona kwechiratidzo.
- Tora chikamu chekuparadzanisa - the forward slash - ( / ) muchikamu cheD1 mushure memusero wechenyu.
- Dzvanya pane sero A3 ine mouse pointer kuti uwedzere kuti sero rinotarisa mushure mushure mekuparadzanisa kwechikamu;
- Dhinda pikicha inopinda mubhokisi kuti upedze fomu;
- Mhinduro 2 inofanira kuva iri muchitokisi D1 kubvira 20 inoparadzaniswa ne10 inokwana 2;
- Kunyange zvazvo mhinduro yacho ichionekwa muchitokisi D1, kuvhara pachitoro ichocho kucharatidza chimiro = A2 / A3 mubhadha yepamusoro pane pepa pepaji.
Kuchinja Data Formula
Kuti uedze kukosha kwekushandisa masero zvinyorwa mumutambo, shandura nhamba iri muchitsetse A3 kubva pa10 kusvika ku 5 uye diya kuIta yekiyi pane keyboard.
Mhinduro yacho muchitokisi B2 inofanira kuenderera mberi kusvika ku 4 kuratidza kuchinja kwe data muchitokisi A3.
# DIV / O! Formula Errors
Chikanganiso chinowanzobatanidzwa nekupatsanurwa kwemabasa muExcel ndiro # DIV / O! kukanganisa kukosha .
Iko kukanganisa kunoratidzwa apo dhinator iri mumagetsi ekuparadzanisa akaenzana ne zero - iyo isingabvumirwi mune arithmetic yakawanda.
Chikonzero chikuru chekuitika kwezvizvi ndechekuti kusakanganiswa kwema cell kunopinda mufomu kana, sezvinoratidzwa mumutsara wechitatu mumufananidzo uri pamusoro, chirevo chacho chakanyoreswa pane imwe nzvimbo uchishandisa chizadziro chekuzadza uye kuchinja kushandiswa kwemasero ekutsvaga mukanganiso .
Verengai Mazamu neChikamu Formulas
Chikamu chekuenzanisa kwakarurama pakati pemhando mbiri dzinoshandisa basa rekuparadzanisa.
Kunyanya kunyanya, chikamu chiduku kana chidimbu chinotarirwa nokuparadzanisa nhambadzi nei denominator uye kuwedzera chigumisiro ne 100.
Iko maitiro akafanana equation ingadai ichiti:
= (numerator / denominator) * 100
Kana migumisiro yebasa rekuparadzanisa - kana quotient - iri shoma rimwe, Excel inomiririra iyo, nekusara, sekuwedzerwa, sezvinoratidzwa mumutsara wechina, apo nhamba yacho inotarirwa kune 10, denominator kusvika 20, uye quotient yakaenzana kusvika ku 0.5.
Chigumisiro ichocho chinogona kushandurwa kusvika pazana kuburikidza nekushandura kuumbwa mumusero kusvika kuzana kuumbwa kubva pane zvisingagadziriswa Gadziriro yakasiyana-siyana - sezvinoratidzwa nechikamu che50% chinoratidzwa muchitokisi B5 mumufananidzo uri pamusoro.
Sero iroro rine maitiro akafanana seyero B4. Kusiyana chete ndiko kuumbwa pane sero.
Zvechokwadi, apo mapurogiramu ekugadzirisa anoshandiswa muExcel, purogiramu inowedzera kuwedzerwa kwemazana nezana uye inowedzera chikamu chechiratidzo.
Kuumba Zvimwe Zvinyorwa Zvakawanda
Kuwedzera mafomu mumufananidzo kuisa mamwe mabasa - akadai kuwedzera kana kuwedzera - kungoramba uchinge wanyatsotsvaga mashematical operator akatevera sero rinenge rine data itsva.
Pamberi kusanganisa mahedheni akasiyana-siyana kushanda pamwe chete mumurairo, zvakadaro, zvakakosha kunzwisisa mutemo wekushanda iyo Excel inotevera kana uchitarisa fomu.
Kuti uite tsika, edza muenzaniso uyu wedanho nechikamu chekunyanya kwakaoma .