I-Division Formulas, # DIV / O! Iziphambeko ze-Formula, nokubala amaphesenti
Ukuhlukanisa izinombolo ezimbili oyidingayo ukwakha ifomula ngoba akukho msebenzi we-DIVIDE ku-Excel.
Amaphoyinti abalulekile okufanele akhumbule ngamafomula e-Excel:
- Amafomula e-Excel aqala ngaso sonke isibonakaliso esilinganayo ( = );
- Uphawu olulinganayo luya njalo esitokisini lapho ufuna khona impendulo;
- Uphawu lokuhlukanisa yi-slash phambili ( / );
- Ifomula igcwaliswe ngokucindezela ukhiye wokungena kwikhibhodi.
Ukusebenzisa Ukubhekisela Kwezingqimba Ngamafomula
Nakuba kungenzeka ukufaka izinombolo ngqo kwifomula, kungcono kakhulu ukufaka idatha kumaseli okusebenza bese usebenzisa amakheli noma izinkomba zalawo maseli kufomula njengoba kuboniswe esithombeni ngenhla.
Ngokusebenzisa izinkomba zocingo - ezifana ne-A1 noma i-C5 - kunokuba idatha yangempela kwifomula, kamuva, uma kudingekile ukushintsha idatha , kuyindaba elula yokufaka idatha kumaseli esikhundleni sokubhala kabusha ifomula.
Ngokujwayelekile, imiphumela yefomula izobuyekeza ngokuzenzekelayo uma idatha ishintsha.
Isigaba se-Formula Isibonelo
Njengoba kuboniswe emgqeni wesi-2 esithombeni ngenhla, lesi sibonelo sidala ifomula kwiseli B2 ehlukanisa idatha kuseli A2 ngedatha ku-A3.
Ifomula eliqediwe esitokisini B2 kuyoba:
= A2 / A3
Ukufaka idatha
- Thayipha inombolo engu- 20 esitokisini se-A2 bese ucindezela ukhiye wokungena kwikhibhodi;
- Thayipha inombolo engu- 10 esitokisini se-A3 bese ucindezela ukhiye wokungena.
Ukufaka Umshini Wokusebenzisa Ukufometha
Yize kungenzeka ukuba uthayiphe ifomula kuphela
= A2 / A3
singene esitokisini B2 futhi sinempendulo efanele ye-2 ukuboniswa kuleso seli, kungcono ukusebenzisa ukukhomba ukufaka izingcingo zeseli kumafomula ukuze unciphise amathuba amaphutha adalwe ngokuthayipha kusithenjwa esingalungile samaseli.
Ukukhomba kuhilela ukuchofoza esitokisini equkethe idatha nge-pointer yegundane ukufaka ireferensi yeseli kwifomula.
Ukufaka ifomula:
- Thayipha uphawu olulinganayo esitokisini B2 ukuze uqale ifomula.
- Chofoza kuseli ye-A2 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomu ngemuva kwesibonakaliso esifanayo.
- Thayipha uphawu lokuhlukanisa - ukukhishwa phambili - ( / ) kufakwe esitokisini D1 ngemva kokubhekisela kweseli.
- Chofoza kuseli ye-A3 nge-pointer yegundane ukwengeza ukuthi ireferensi yeseli kwifomula ngemuva kwesignali sokuhlukanisa;
- Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula;
- Impendulo 2 kufanele ibe khona esitokisini D1 kusukela 20 ihlukaniswe ngu-10 ilingana no-2;
- Ngisho noma impendulo ibonakala esitokisini D1, ukuchofoza kulelo seli kuzobonisa ifomula = A2 / A3 ebhafini 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 kwiseli B2 kufanele ibuyekeze ngokuzenzakalelayo ku-4 ukukhombisa ushintsho kwedatha kuseli A3.
# DIV / O! Iziphambeko ze-Formula
Iphutha elivame kakhulu elihlobene nemisebenzi yokuhlukanisa ku-Excel 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 Anezigaba Zezigaba
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 yomsebenzi wokuhlukanisa - noma i-quotient - ingaphansi kweyodwa, i-Excel imelela, ngokuzenzakalelayo, njengedayimali, njengoba kuboniswe kulayini 4, lapho isibalo sibhekiswe ku-10, i-denominator ibe ngu-20, kanti i-quotient ilingana kuya ku-0.5.
Leyo miphumela ingashintshwa ibe ngamaphesenti ngokushintsha ukufometha esitokisini kuya kufomethini yefomathi kusuka kwimodi evamile Okujwayelekile - njengoba kuboniswe umphumela we-50% oboniswa esitokisini B5 esithombeni ngenhla.
Leli cell liqukethe ifomula efanayo njengeseli B4. Umehluko kuphela ukufometha esitokisini.
Eqinisweni, uma ukufometha kwamaphesenti kusetshenziswe ku-Excel, uhlelo luphindaphinda inani lemadayimenti ngo-100 futhi lengeza uphawu lwephesenti.
Ukwakha amafomula amaningi anzima
Ukwandisa amafomula esithombeni ukufaka imisebenzi eyengeziwe - njengokuphindaphindiwe noma ukuhlanganisa - qhubeka nje ukufaka umsebenzisi ohambelana nezibalo olandelwa yereferensi yeseli equkethe idatha entsha.
Ngaphambi kokuxuba imisebenzi ehlukene yezibalo ndawonye kwifomula, noma kunjalo, kubalulekile ukuqonda ukulandelana kwemisebenzi eyenziwa yi-Excel uma kuhlolwa ifomula.
Ukuze wenze umkhuba, zama lesi sinyathelo nesinyathelo sesiteleka sefomula eyinkimbinkimbi .