Sebenzisa umsebenzi we-ROUNDUP ku-Excel kuya kuNombolo Yonke
Umsebenzi we-ROUNDUP ku-Excel usetshenziselwa ukunciphisa inani ngenani elithile lezindawo zedesimali noma amadijithi. Lo msebenzi uzohlale ujikeleza idijithali phezulu, njenge-4.649 kuya ku-4.65.
Lekhono lokuqoqa ku-Excel lishintsha ukubaluleka kwedatha esitokisini, ngokungafani nezinketho zokufometha ezikuvumela ukuba ushintshe inombolo yezindawo zedesimali eziboniswa ngaphandle kokushintsha inani eliseli cell. Ngenxa yalokhu, imiphumela yokubala iyathinteka.
Izinombolo ezimbi, nakuba ziyancipha ngokubaluleka umsebenzi we-ROUNDUP, kuthiwa zihlanganiswe. Ungabona ezinye izibonelo ngezansi.
Umsebenzi we-ROUNDUP we-Excel
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.
Lena yi-syntax yomsebenzi we-ROUNDUP:
= ROUNDUP ( Inombolo , Num_digits )Inombolo - (edingekayo) inani elizobanjelwa
Le mpikiswano ingaqukatha idatha yangempela yokuqoqa noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela.
Ama -_digits - (adingekayo) inani lamadijithi ukuthi ukuphikisana kweNombolo kuzothengiswa .
- Uma ukuxabana kwe- Num_digits kusethwe ku-0, lo msebenzi ujikeleza inani kuze kufike ku-integer eseduzane;
- Uma ukuxabana kwe- Num_digits kusethelwe ku-1, umsebenzi ushiya idijithi eyodwa kuphela ngakwesokudla sephoyinti lesimangadi bese ulizungeza kwinombolo elandelayo;
- Uma ukuxabana kwe- Num_digits kungalungile, zonke izindawo zedesimali zisusiwe futhi umsebenzi ujikeleza leyo nombolo yamadijithi ngakwesobunxele wephoyinti eliphezulu ukuya phezulu.
Qaphela: Ukuze uthole isibonelo se-argument yokugcina, uma inani le- arg_digits ingqubuzana ku- -2 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti lesimanje futhi ujikeleze amadijithi wokuqala nesesibili ngakwesokunxele kwephoyinti lesedimali kuze kube ngu-100 eseduzane (njengoba kuboniswe emgqeni wesithupha kusibonelo ngenhla).
Izibonelo zezinhlelo zokusebenza ze-ROUNDUP
Isithombe esingenhla sibonisa izibonelo futhi sinikeza izincazelo zemiphumela eminingi ebuyiswe umsebenzi we-ROUNDUP we-Excel yedatha kukholomu A yephepha lokusebenzela.
Imiphumela, ekhonjisiwe kukholomu B , incike ekubalukeni kwempikiswano ye- Num_digits .
Imiyalo engezansi ichaze izinyathelo ezithathwe ukunciphisa inamba e-cell A2 esithombeni ngenhla kuya ezindaweni ezimbili zamadayimenti usebenzisa umsebenzi we-ROUNDUP. Kule nqubo, umsebenzi uzokwandisa inani ledijithi yokujikeleza eyodwa.
Ukufaka umsebenzi we-ROUNDUP
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele: = ROUNDUP (A2,2) ibe yiseli C3 kushidi lokusebenzela;
- Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi.
Ukusebenzisa ibhokisi lengxoxo kucacisa ukufaka izingxabano zomsebenzi. Ngalendlela, akudingekile ukuthi ufake amakhompi phakathi kwezingxabano zomsebenzi ngamunye njengalokho okumele kwenziwe uma umsebenzi ufakwa esitokisini - kulesi simo phakathi kuka- A2 no- 2 .
- Chofoza kuseli C3 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-ROUNDUP izoboniswa khona.
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi lomsebenzi.
- Khetha i- ROUNDUP ohlwini ukuze uvule ibhokisi lengxoxo lomsebenzi.
- Khetha ibhokisi lombhalo eduze "Nombolo."
- Chofoza ku-cell A2 ekhasini lokusebenzela ukuze ufake leyo reference reference ebhokisini lebhokisi njengoba indawo yenombolo ezobanjelwa.
- Khetha ibhokisi lombhalo eduze "nama-num_digits".
- Thayipha u- 2 ukuze unciphise inombolo ku-A2 kusuka ezindaweni ezinhlanu eziya kumadayimenti.
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.
- Impendulo 242.25 kufanele ivele esitokisini C3 .
- Uma uchofoza ku-cell C2, umsebenzi ophelele = ROUNDUP (A2, 2) uvela kubha yefomula ngaphezulu kwephepha lokusebenzela .