Gadzira NZIRA yega yega yekuparadzanisa nhamba muGoogle Spreadsheets
Kufanana neExcel, Google Spreadsheets haina DIVIDE basa. Pane kudaro, unoda kugadzira fomu muGoogle Spreadsheets kuti uite maitiro ekuparadzanisa. Mirayiridzo iyi inokufambisa kuburikidza nekugadzira maitiro ekuparadzanisa, kusanganisira nzira dzakasiyana-siyana dzokugadzira fomu, zvikanganiso zvaunogona kuwana, uye kuti ungashandisa sei mufananidzo WEMIBVIRO yemigumisiro yezvikamu.
Gura muGoogle Spreadsheets uchishandisa Fomu
Kugovana nhamba mbiri iwe unoda kuumba fomu , sezvo pasina DIVIDE basa muGoogle Spreadsheets.
Pfungwa dzinokosha dzekuyeuka pamusoro peGoogle Spreadsheet fomu:
- Mafomu anotanga nguva dzose nechiratidzo chakaenzana ( = ).
- Chiratidzo chakaenzana nguva dzose chinopinda musero iyo iwe unoda kuti mhinduro ipinde.
- Iyo inoparadzanisa inoshandiswa ndiyo forward slash ( / ).
- Icho chinyorwa chinopedzerwa nekudhinda Enter key pane keyboard.
Achishandisa Cell References muFormulas
Zvinokwanisika kupinda nhamba inopinda mumusarudzo - sezvinoratidzwa mumitsara mbiri nehatu mumuenzaniso uri pamusoro.
Zvakanaka zvikuru, zvisinei, kuisa data mumashandisi ekushanda uye usingashandisi kero kana kuti zvinyorwa zvemasero aya mumutsetse sezvinoratidzwa mumitsara mana kusvika kuchitanhatu mumuenzaniso.
Nokushandisa shanduro dzinoratidzika - dzakadai seA2 kana A5 - panzvimbo yezvakadzama mumutsetse - gare gare, kana zvichizodikanwa kuchinja data , iri nyaya yakanyanyisa yekugadzirisa demo mumasero panzvimbo yekunyorazve maitiro.
Kazhinji, migumisiro yechipfuva ichadzoka pakarepo kana data ichichinja.
Dzvitsai mienzaniso yeFormu
Nzira iri muchitokisi B4 yemuenzaniso:
= A2 / A3
Inongoparadzanisa data iri muchitokisi A2 ne data muA3 kuti idzorere mhinduro yeviri.
Kupinda Mufomu Ne Point uye Click
Kunyange zvazvo zvichibvira kungonyora fomu
= A2 / A3
Kupinda muchitokisi B4 uye kuva nemhinduro yakarurama ye2 inoratidzirwa mune iyo cell, zviri nani kushandisa nheyo-uye- kana kutanidza kuwedzera sero zvinyorwa zvemafomu - kunyanya nemafomu akawanda.
Kuita kudaro kunoderedza kukanganisa kwezvikanganiso zvakasikwa nekunyora mune zvisina kukodzera sero reference.
Point nechokubatanidza zvinosanganisa pachitokisi chine deta nemushonga we mouse kuti uwedzere kutarisa kwekero kwomufananidzo.
Kuisa maitiro
- Tanga = (akaenzana chiratidzo) muchitokisi B4 kuti utange rumbiro.
- Dzvanya pachitokisi A2 neine mouse pointer kuti uwedzere kuti sero rinotarisa kumushure mushure mekuona kwechiratidzo.
- Tanga / (chikamu chikamu kana kuti mberi slash) muchitokisi B4 mushure memasekureferensi.
- Dzvanya pachitokisi A3 ine mouse pointer kuti uwedzere kuti sero rinotarisa mushure mushure mekuparadzaniswa kwemazana.
- Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
- Mhinduro 2 inofanira kuva iri muchitokisi B4 kubva 20 inoparadzaniswa ne10 inokwana 2.
- Kunyange zvazvo mhinduro yacho ichionekwa muchitokisi B4, kuvhara pane iyo seni kucharatidza rondedzero = A2 / A3 mune bhora 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 kune ina kuti iratidze kuchinja kwe data muchitokisi A3.
# DIV / O! Formula Errors
Chikanganiso chinowanzobatanidzwa nemabasa ekuparadzanisa ndiyo # 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 Peresenti neChikamu Formulas
Chikamu chekuenzanisa kwakarurama pakati pemaviri maviri anoshandisa kushandiswa kwekuparadzanisa.
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 yebato rekuparadzanisa - kana quotient - iri pasi peyero, Google Spreadsheets inomiririra iyo, nekusingaperi, sechirevo, sezvinoratidzwa mumutsara wechishanu, uko:
- Nhamba yacho inotarirwa ku10.
- The denominator to 20.
- The quotient yakaenzana ne 0.5.
Chigumisiro ichocho chinogona kuchinjwa kusvika pazana kuburikidza nekushandura kuumbwa mune sero kusvika kuzana kuumbwa kubva kunezvisizvo Zvinogadzirisa mafaira - sezvakaratidzwa nehuwandu hwe50% hunoratidzwa muchitokisi B6 chemuenzaniso.
Sero iroro rine maitiro akafanana seyero B4. Kusiyana chete ndiko kuumbwa pane sero.
Muchidimbu, kana mapurogiramu ekugadzirisa ari kushandiswa, purogiramu inowedzera kuwedzerwa kwemazana ne100 uye inowedzera chikamu chinoshandiswa.