01 ka 03
I-Google Spreadsheets 'I-ROUND Function
Umsebenzi we-ROUND ungasetyenziselwa ukunciphisa ixabiso ngenani elithile leendawo zokugqibela.
Kwinkqubo, idijithi yokugqibela, idijithi yokujikeleza, ijikelezwe okanye iphantsi.
Imithetho yeenomboro ezijikelezayo iGoogle Spreadsheets ilandela, icacisa;
- Ukuba inani lenani ukuya ngasekunene ledijithi yokujikeleza lingaphantsi kwetlanu, idijithi yokujikeleza ishiywe ingatshintshi;
- Ukuba inani lenani ukuya ngakwesokudla ledijithi yokujikeleza lihlanu okanye ngaphezulu, inombolo yokujikeleza iphakanyiswa enye.
Kwakhona, ngokungafani neendlela zokufomathiza ezivumela ukuba utshintshe inani leendawo zokugqibela eziboniswe ngaphandle koko utshintshe ixabiso kwiseli, umsebenzi weROUND, njengeminye imisebenzi ye-Google Spreadsheets, iguqula ixabiso leedatha.
Ukusebenzisa lo msebenzi ukujikeleza idatha, ngoko ke kuya kuthintela iziphumo zokubala.
Umfanekiso ongentla ungabonisa imizekelo kwaye unikezela inkcazo yeenombolo zeziphumo ezibuyiselwe ngumsebenzi we-Google Spreadsheets 'ROUNDDOWN umsebenzi wedatha kwikholam A yephepha lokusebenzela.
Iziphumo, eziboniswe kwikholam C, zixhomekeke kwixabiso lempikiswano yokubala - bona iinkcukacha ezingezantsi.
02 ka 03
I-Syntax yeMisebenzi ye-ROUNDDOWN neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano.
I-syntax yomsebenzi we-ROUNDDOWN ngu:
= ROUNDDOWN (inombolo, inani)
Iingxoxo zomsebenzi zi:
Inombolo - (efunekayo) ixabiso eliza kubalwa
- Le ngxabano ingaba nedatha yangempela yokujikeleza okanye ingaba yereferensi yeseli kwendawo yedata kwiphepha lokusebenzela .
kubalwa - (ngokukhethwa kukho) inani leendawo zokugqibela ukuhamba
- Ukuba ngaba ingxabano yokubala ayishiywe, umsebenzi ujikeleza ixabiso ukuya kwi-integer esondeleyo
- Ukuba ingxabano yokubala isetyenziswe ku-1, umzekelo, umsebenzi ushiya idijithi enye ukuya ngasekunene kwinqanaba lokugqibela kwaye ulijikeleze kwinombolo elandelayo
- Ukuba ingxabano yokubala ayibi, zonke izithuba ezidlulileyo ziyasuswa kwaye umsebenzi ujikeleza loo nombolo yeedijithi ukuya ngasekunene kwinqanaba lokugqibela eliya phezulu
- Umzekelo, ukuba inani lempikiswano yokubala lisetyenziswe kwi-- 1 , umsebenzi uya kususa amadijithi onke ukuya ngasekunene kwinqanaba lokugqibela kunye nomjikelezo wenombolo yokuqala ukuya kwesobunxele kwi-decimal ukuya kwe-10 - umzekelo wesi-2 kumfanekiso ngasentla
- Ukuba inani lempikiswano yokubala lisetyenziswe ku- -2 , umsebenzi uya kususa onke amadijithi ukuya ngasekunene kwinqanaba lokugqibela kwaye ujikeleze idijithi zokuqala neyesibini ukuya kwesobunxele be-decimal ukuya kwi-100 - umzekelo 4 kumfanekiso ongentla
03 ka 03
ROUNDDOWN Umsebenzi weSishwankathelo
Umsebenzi weROUNDDOWN:
- Isetyenziswe ukunciphisa ixabiso ngenani elithile leendawo zokugqibela okanye idijithi;
- Njalo ushiya idijithi yokujikeleza ingatshintshi - ungalokothi uyijikeleze;
- Ivelisa ixabiso leedatha kwindlela yokwenza ifom yeefayile - ngokungafaniyo ekuvumela ukuba utshintshe inani leendawo zokugqibela ezingabonakali ngaphandle kokuguqula ixabiso kwiseli;
- Ichaphazela iziphumo zokubala ngenxa yolu tshintsho kwidatha.
- Uhlala ujikeleza ukuya kutsho. Amanqaku angalunganga, nangona ayenyuka kwindleko ngomsebenzi, zithi zidibene (imizekelo 4 kunye no-5 kumfanekiso ongentla).