01 ka 01
Umsebenzi we-ROUNDDOWN we-Excel
Umsebenzi we-ROUNDDOWN:
- lisetshenziselwa ukunciphisa inani ngenani elithile lezindawo zamadesimali noma amadijithali;
- uyohlale egcina idijithali yokujikeleza efanayo;
- iguqula ukubaluleka kwedatha esitokisini - ngokungafani nezinketho zokufometha ezikuvumela ukuba ushintshe inombolo yezindawo zedesimali ezikhonjiswa ngaphandle kokushintsha ngempela inani esitokisini;
- kuthinta imiphumela yezibalo ngenxa yalolu shintsho kwedatha.
- njalo ujikeleza u-zero. Izinombolo ezimbi, nakuba zanda ngenani lomsebenzi, kuthiwa zenziwe phansi - njengoba kuboniswe kwizibonelo ezinemiqolo emihlanu nesithupha emfanekisweni ngenhla).
I-syntax yomsebenzi ka-ROUNDDOWN nama-Arguments
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.
I-syntax yomsebenzi we-ROUNDDOWN yile:
= I-ROUNDDOWN (Inombolo, Amanani_Ama-Numeri)
Amaphuzu alo msebenzi yilezi:
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 ngabe i- Num_digits ingxabano isethwe ku-0, umsebenzi ujikeleza inani kuze kube yi-integer eseduzane
- uma ukuxabana kwe- Num_digits kusethwe ku-1, lo msebenzi ushiya idijithi eyodwa kuphela ngakwesokudla sephoyinti lesimademeshini bese ulijikeleza kwinombolo elandelayo
- uma ukuxabana kwe- Num_digits kungalungile, zonke izindawo zedesimali zisusiwe futhi umsebenzi ojikelezayo ukuthi inani lamadijithi kuya kwesobunxele kwephoyinti lemasimali kuya ku-zero
- isibonelo, uma inani lempikiswano ye- Num_digits isethelwe ku- -2 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti lesimanje futhi ujikeleze amadijithi wokuqala nesesibili ngakwesobunxele we-decimal decimal kuya ku-100 eliseduzane njengoba kubonisiwe kusibonelo emgqeni wesi-6 esithombeni ngenhla
Izibonelo Zezinhlelo ZaseROUNDDOWN
Isithombe esingenhla sibonisa izibonelo futhi sinikeza izincazelo zemiphumela eminingi ebuyiswe umsebenzi we-ROUNDDOWN we-Excel yedatha kukholomu A yephepha lokusebenzela.
Imiphumela, ekhonjisiwe kukholomu B, incike ekubalukeni kwempikiswano ye- Num_digits .
Imiyalo engezansi ichaze izinyathelo ezithathwe ukunciphisa inombolo eselifini A2 esithombeni ngenhla kuya ezindaweni ezimbili zamadayimenti usebenzisa umsebenzi we-ROUNDDOWN. Ngenxa yokuthi umsebenzi njalo ujikeleza, idijithi yokujikeleza ngeke ishintshe.
Ukufaka umsebenzi we-ROUNDDOWN
Izinketho zokufaka umsebenzi kanye neziphakamiso zalo zifaka:
- Ukuthayipha umsebenzi ophelele: = ROUNDDOWN (A2,2) ibe esitokisini C3 kushidi lokusebenzela;
- Ukukhetha umsebenzi nokuphikisana usebenzisa ibhokisi lengxoxo lomsebenzi.
Ukusebenzisa ibhokisi lengxoxo kucacisa ukufaka izingxabano zomsebenzi. Ngalendlela, akudingekile ukuthi ufake ama-commas phakathi kwezingxoxo zomsebenzi ngamunye njengoba kufanele kwenziwe uma umsebenzi ufakwa esitokisini - kulesi simo phakathi kuka- A2 no- 2.
Izinyathelo ezingezansi zokufaka umsebenzi we-ROUNDDOWN usebenzisa ibhokisi lengxoxo.
- Chofoza kumakhalekhukhwini C3 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-ROUNDDOWN izoboniswa;
- Chofoza kuthebhu yefomula yemenyu ye- Ribbon ;
- Khetha i- Math & Trig kusuka ku-riboni ukuvula uhlu lokudonsa phansi;
- Chofoza ku- ROUNDDOWN ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi;
- Ebhokisini lebhokisi qhafaza kulayini lombhalo;
- Chofoza ku-cell A2 ekhasini lokusebenzela ukuze ufake leyo reference reference ebhokisini lebhokisi njengoba indawo yenombolo ezobanjwa;
- Chofoza kumugqa we- Num_digits ;
- Thayipha ezimbili "2" ukuze unciphise inombolo ku-A2 kusuka ezindaweni ezinhlanu ukuya kumadayimenti amabili;
- Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela;
- Impendulo 567.96 kufanele ivele esitokisini C3;
- Uma uchofoza ku-cell C2 umsebenzi ophelele = ROUNDDOWN (A2, 2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela .