01 ka-03
Umsebenzi we-ROUND we-Google Spreadsheets
Umsebenzi we-ROUND ungasetshenziselwa ukunciphisa inani ngenani elithile lezindawo zedesimali.
Kule nqubo, idijithi yokugcina, idijithali yokujikeleza, ihlanganiswe noma iphansi.
Imithetho yokuqoqa izinombolo ukuthi i-Google Spreadsheets ilandela, ichaza;
- Uma inani lenombolo ngakwesokunene sedijithi yokujikeleza lingaphansi kwamahlanu, idijithi yokujikeleza ishiywe ingashintshi;
- Uma inani lenombolo ngakwesokunene sedijithi yokujikeleza liyisihlanu noma ngaphezulu, idijithi yokujikeleza iphakanyiswa yinye.
Futhi, ngokungafani nezinketho zokufometha ezivumela ukuthi ushintshe inombolo yezindawo zedesimali eziboniswa ngaphandle kokushintsha ngempela inani esitokisini, umsebenzi we-ROUND, njengeminye imisebenzi ye- Google Spreadsheets, iyashintsha ukubaluleka kwedatha.
Ukusebenzisa lo msebenzi ukuzungeza idatha kuyobe kuthinta imiphumela yezibalo.
Isithombe esingenhla sibonisa izibonelo futhi sinikeza izincazelo zemiphumela eminingi ebuyiswe umsebenzi we-Google Spreadsheets 'ROUNDDOWN umsebenzi wedatha kukholomu A yephepha lokusebenzela.
Imiphumela, eboniswe kukholomu C, incike ekubalukeni kokuxabana kokubala - bona imininingwane ngezansi.
02 ka-03
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:
= ROUNDDOWN (inombolo, isibalo)
Amaphuzu alo msebenzi yilezi:
inombolo - (edingekayo) inani elizofakwa
- Le mpikiswano ingaqukatha idatha yangempela yokuqoqa noma ingaba ireferensi yeseli endaweni yedatha ekhasini lokusebenzela .
count - (ngokuzikhethela) inombolo yezindawo zamadesimali ukuhamba
- Uma ukuphikisana kokubala kushiywe, umsebenzi ujikeleza inani kuze kube kunani elikude
- Uma ukuphikisana kokubala kusethelwe ku-1, isibonelo, umsebenzi ushiya idijithi eyodwa kuphela ngakwesokudla kwephoyinti elidumile futhi ulijikeleze kwinombolo elandelayo
- Uma ukuphikisana kokubala kungalungile, zonke izindawo zedesimali zisusiwe futhi umsebenzi ujikeleza leyo nombolo yamadijithi kuya kwesobunxele bephoyinti eliphansi ukuya phansi
- Isibonelo, uma inani lempikiswano yokubala lihlelwe ku- -1 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti elidumile futhi ujikeleze idijithali yokuqala ngakwesobunxele se-decimal decimal kuya ku-10 - isibonelo sesi-2 esithombeni ngenhla
- Uma inani lempikiswano yokubala selihlelwe ku- -2 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti lesesimanje futhi ujikeleze amadijithi wokuqala nowesibili ngakwesobunxele we-decimal decimal kuze kube ngu-100 - isibonelo 4 esithombeni esingenhla
03 ka 03
Isifinyezo somsebenzi we-ROUNDDOWN
Umsebenzi we-ROUNDDOWN:
- Isetshenziselwa ukunciphisa inani ngenani elithile lezindawo zedesimali noma amadijithali;
- Njalo shiya idijithi yokujikeleza ingaguquki - ungalokothi uyijikeleze;
- Iguqula inani lemininingwane esitokisini - ngokungafani nezinketho zokufometha ezikuvumela ukuba ushintshe inombolo yezindawo zamadesimali ezikhonjiswa ngaphandle kokushintsha ngempela inani esitokisini;
- Ithinta imiphumela yezibalo ngenxa yalolu shintsho kudatha.
- Ijikeleza njalo ku-zero. Izinombolo ezimbi, nakuba zanda ngenani lomsebenzi, kuthiwa zenziwe phansi (izibonelo 4 no-5 esithombeni ngenhla).