Dala ifomula engu-ALLIDE ukuhlukanisa izinombolo kuma-Google Spreadsheets
Njengo-Excel, i-Google Spreadsheets ayikho umsebenzi we-DIVIDE. Kunalokho, udinga ukwakha ifomu kuma-Google Spreadsheets ukwenza imisebenzi yokuhlukanisa. Lezi ziqondiso zikuhamba ngokudala ifomula yokuhlukanisa, kufaka phakathi izindlela ezehlukene zokudala ifomula, amaphutha ongase uwabone, nokuthi ungasebenzisa kanjani indlela YONKE yemiphumela yephesenti.
Hlukanisa kuma-Google Spreadsheets usebenzisa i-Formula
Ukuhlukanisa izinombolo ezimbili oyidingayo ukwakha ifomula , ngoba akukho msebenzi we-DIVIDE kuma-Google Spreadsheets.
Amaphuzu abalulekile okumele akhumbule mayelana namafomula we-Google Spreadsheet:
- Amafomu aqala ngaso sonke isibonakaliso esilinganayo ( = ).
- Uphawu olulinganayo luya njalo esitokisini lapho ufuna khona impendulo.
- Umqhubi wezokuhlukanisa yi-slash phambili ( / ).
- Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi.
Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula
Kungenzeka ukungena izinombolo ngqo kwifomula - njengoba kuboniswe emigqeni emibili nantathu kusibonelo esingenhla.
Nokho, kungcono ukufaka idatha kumaseli okusebenza bese usebenzisa amakheli noma izinkomba zalawo maseli kufomula njengoba kuboniswe emigqeni ezine kuya kwesithupha kusibonelo.
Ngokusebenzisa izingqikithi zeseli - njenge-A2 noma i-A5 - kunokuba idatha yangempela kwifomula - kamuva, uma kudingekile ukushintsha idatha , kuyindaba elula yokufaka idatha kumaseli esikhundleni sokuphinda ubhale kabusha ifomula.
Ngokujwayelekile, imiphumela yefomula izobuyekeza ngokuzenzekelayo uma idatha ishintsha.
Isibonelo se-Formula
Ifomula ku-cell B4 yesibonelo:
= A2 / A3
Imane ihlukanisa idatha kuseli A2 ngedatha ku-A3 ukubuyisela impendulo yezimbili.
Ukufaka i-Formula Nge Point bese Chofoza
Yize kungenzeka ukuba uthayiphe ifomula kuphela
= A2 / A3
Ngena esitokisini B4 futhi unempendulo efanele ye-2 ukuboniswa kuleyo cell, kungcono ukusebenzisa iphuzu-nokuchofoza noma ukhomba ukwengeza izingcingo zesitokisi kumafomula - ikakhulukazi ngamafomula amade.
Ukwenza kanjalo kunciphisa amathuba okuba amaphutha adalwe ngokuthayipha kusithenjwa esingalungile samaseli.
Iphoyinti nokuchofoza kuhilela ukuchofoza esitokisini equkethe idatha nge-pointer yegundane ukufaka ireferensi yeseli kwifomula.
Ukufaka ifomula
- Thayipha = (uphawu olulinganayo) kuseli B4 ukuqala ifomula.
- Chofoza kuseli ye- A2 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomu ngemuva kwesibonakaliso esifanayo.
- Thayipha / (uphawu lwesigaba noma ukukhishwa phambili) esitokisini B4 ngemva kokubhekisela kweseli.
- Chofoza kuseli le-A nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomula ngemuva kokusayina kwesigaba.
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula.
- Impendulo 2 kufanele ibe khona esitokisini B4 kusukela 20 ihlukaniswe ngu-10 ilingana no-2.
- Ngisho noma impendulo ibonakala esitokisini B4, ukuchofoza kuleso seli kuzobonisa ifomula = A2 / A3 kubha yefomula ngaphezulu kwephepha lokusebenzela.
Ukushintsha idatha yefomula
Ukuze uhlole ukubaluleka kokusebenzisa izingqikithi zamangqamuzana kwifomula, shintsha inombolo ku-cell A3 kusuka ku-10 ukuya ku-5 bese ucindezela ukhiye we- Enter kwikhibhodi.
Impendulo ku-cell B2 kufanele ibuyekeze ngokuzenzakalelayo kuya kwezine ukuze ibonise ushintsho kwedatha kuseli A3.
# DIV / O! Iziphambeko ze-Formula
Iphutha elivame kakhulu elihlobene nemisebenzi yokuhlukanisa yi- # DIV / O! inani lephutha.
Lephutha iboniswa uma i-denominator kwifomula yokuhlukanisa ilingana ne-zero-engavunyelwe ku-arithmetic evamile.
Isizathu esikhulu salokhu okwenzekayo ukuthi isithenjwa seseli engalungile singene kwifomula noma, njengoba kuboniswe kumugqa wesi-3 esithombeni esingenhla, ifomula likopishwe kwenye indawo usebenzisa isibambo sokugcwalisa kanye nemiphumela yokuguqulwa kwamaseli ekuguquleni kwiphutha .
Bala Amaphesenti nge-Division Formulas
Iphesenti liwukuqhathanisa nje phakathi kwezinombolo ezimbili ezisebenzisa ukusetshenziswa kwe-division.
Ngokuqondile, kuyincinjana noma isimiso esinqunyiwe esibalwa ngokuhlukanisa inani lezinombolo nge-denominator futhi liphindiselela umphumela nge-100.
Ifomu elijwayelekile le-equation kungaba:
= (inomboro / i-denominator) * 100
Uma imiphumela yokusebenza kwesigaba - noma i- quotient - ingaphansi kweyodwa, i-Google Spreadsheets imelela, ngokuzenzakalelayo, njenge-decimal, njengoba kuboniswe emgqeni wesihlanu, lapho:
- I-numerator isethwe ku-10.
- I-denominator ibe ngu-20.
- I-quotient ilingana no-0.5.
Leyo miphumela ingashintshwa ibe ngamaphesenti ngokushintsha ukufometha esiteleni kuya kufomethini yephesenti kusukela ekuzenzakaleleni Ifomethi ezenzakalelayo - njengoba kuboniswe umphumela we-50% oboniswe kuseli B6 yesibonelo.
Leli cell liqukethe ifomula efanayo njengeseli B4. Umehluko kuphela ukufometha esitokisini.
Empeleni, lapho kufakwa ukufometha kwephesenti, uhlelo luphindaphinda inani le-decimal nge-100 futhi lengeza uphawu lwephesenti.