Izinombolo ezijikelezayo kuya kwinombolo ecacisiwe yamadijithi
Ku-Excel, umsebenzi we-ROUND usetshenziselwa ukuzungeza izinombolo kudijithi ecacisiwe yamadijithi. Ingazungeza nganoma iyiphi ingxenye yephuzu lesimanje. Uma lenza lokhu, lishintsha ukubaluleka kwedatha ekukhetheni kokufometha okungafani namaseli okuvumela ukuthi ushintshe inombolo yezindawo zamadesimali ezikhonjiswa ngaphandle kokushintsha ngempela inani esitokisini. Ngenxa yalolu shintsho yedatha, umsebenzi we-ROUND uthinta imiphumela yokubala kuspredishithi.
01 ngo-02
I-syntax ye-ROUND kanye nama-Arguments
I-syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-ROUND ngu:
= I-ROUND (Inombolo, Ama-Num_digits)Imibono yalolu msebenzi yiNombolo nama-Num_digits:
Inombolo ukubaluleka okubanjelwe. Le mpikiswano ingaqukatha idatha yangempela yokuqoqa, noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela. Kuyinto edingekayo.
Ama -_digits yinombolo yamadijithi ukuthi ukuphikisana kweNombolo kuzothengiswa . Kudingeka futhi.
- Uma ukuxabana kwe- Num_digits kusethelwe ku-zero, umsebenzi ujikeleza inani noma phezulu ukuya kwenani eliseduze.
- Uma ukuxabana kwe- Num_digits kunkulu kune-zero, inani lihlelwe kwinombolo ecacisiwe yezindawo zedesimali.
- Uma inani lempikiswano ye- Num_digits isethelwe ku- 2 , lo msebenzi ushiya amadijithi amabili kuya kwesokudla sephoyinti lesimanje futhi ujikeleza idijithi yokugcina phezulu noma phansi ngenombolo elandelayo.
- Uma ukuxabana kwe- Num_digits kungalungile, zonke izindawo zedesimali zisusiwe futhi umsebenzi uhambela noma wehla leyo nombolo yamadijithi ngakwesobunxele kwephoyinti lemasimali.
- Uma inani lempikiswano ye- Num_digits isethelwe ku- -2 , umsebenzi ususe wonke amadijithi ngakwesokudla kwephoyinti lesesimanje futhi ujikeleze amadijithi wokuqala nesesibili ngakwesokunxele kwephoyinti eliphakeme noma eliphansi ukuya ku-100 eliseduzane.
Qaphela: Uma njalo ufuna ukuzungeza izinombolo phezulu, sebenzisa umsebenzi we-ROUNDUP. Uma uhlale ufuna ukuzungeza izinombolo phansi, sebenzisa umsebenzi we-ROUNDDOWN.
02 ka 02
Isibonelo somsebenzi we-ROUND
Isithombe esihambisana nalesi sihloko sibonisa izibonelo zemiphumela eminingi ebuyiselwe umsebenzi we-ROUND we-Excel yedatha kukholomu A yephepha lokusebenzela.
Imiphumela, eboniswe kukholomu C, incike ekubalukeni kwempikiswano ye- Num_digits .
Izinketho zokufaka umsebenzi we-ROUND
Isibonelo, ukunciphisa inombolo 17.568 esitokisini se-A5 esithombeni kuya ezindaweni ezimbili zesimangadi usebenzisa umsebenzi weROUND, izinketho zokufaka umsebenzi kanye neziphakamiso zayo zifaka:
- Ukuthayipha umsebenzi ophelele: = ROUND (A5,2) esitokisini C5 ekhasini lokusebenzela
- Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi.
Nakuba kungenzeka ukuthayipha umsebenzi ophelele ngesandla, abantu abaningi bakuthola kulula ukusebenzisa ibhokisi lengxoxo ukuze bafake izingxabano zomsebenzi.
Indlela Yokusebenzisa Ibhokisi Lezingxoxo
Kulesi sibonelo, vula ispredishithi se-Excel bese ufaka amanani kukholomu A yesithombe ibe ikholomu ehambelana nemigqa yespredishithi.
Ukusebenzisa ibhokisi lengxoxo ukufaka umsebenzi weROUND esitokisini C5:
- Chofoza kuseli C5 ukuze wenze iseli elisebenzayo. Yilapho imiphumela yomsebenzi we-ROUND izoboniswa.
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi lomsebenzi.
- Chofoza ku- ROUND ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi.
- Ebhokisini lengxoxo, chofoza kulayini lombhalo.
- Chofoza ku-cell A5 kushidi lokufaka ukuze ufake leyo reference yocingo ebhokisini lengxoxo.
- Chofoza kumugqa we- Num_digits .
- Thayipha i- 2 ukuze unciphise inani ku-A5 kuya ezindaweni ezimbili zamadesimali.
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
Impendulo 17.57 kufanele ivele kuseli C5. Uma uchofoza ku-cell C5, umsebenzi ophelele = INHLANGANO (A5,2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Okwenza umsebenzi weROUND ubuyekezwe 17.57
Ukubeka inani lempikiswano ye- Num_digits kuya ku- 2 kunciphisa inombolo yezindawo zamadesimali empendulweni kusuka kumithathu kuya kweyodwa . Ngenxa yokuthi ama -_digits asethelwe ku-2, i- 6 enombolweni 17.568 iyinombolo yokujikeleza.
Njengoba inani eliya ngakwesokudla ledijithi yokujikeleza-inombolo ye-8-ingaphezulu kuka-4, idijithali yokujikeleza yanda ngamuntu enikeza umphumela ka-17.57.