Izinombolo ezijikelezayo Ku-Google Spreadsheets

Isithombe sisebukhosini sibonisa izibonelo futhi sinikeza izincazelo zemiphumela eminingi ebuyiswe umsebenzi we-Google Spreadsheets 'ROUNDUP yedatha kukholomu A yephepha lokusebenzela. Imiphumela, eboniswe kukholomu C, incike ekubalukeni kokuxabana kokubala - ulwazi olungaphezulu ngezansi.

01 ngo-02

Umsebenzi we-ROUNDUP we-Google Spreadsheets

Izinombolo ezungeze phezulu kuma-Google Spreadsheets

Isithombe esingenhla sibonisa izibonelo futhi sinikeza izincazelo zemiphumela eminingi ebuyiswe umsebenzi we-Google Spreadsheets 'ROUNDUP yedatha kukholomu A yephepha lokusebenzela.

Imiphumela, eboniswe kukholomu C, incike ekubalukeni kokuxabana kokubala - ulwazi olungaphezulu ngezansi.

I-syntax ye-ROUNDUP ne-Arguments ye-ROUNDUP

I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.

I-syntax yomsebenzi we-ROUNDUP yilezi:

= ROUNDUP (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 kufike ku-integer eseduzane
• uma ukuphikisana kokubala kusethelwe ku-1, isibonelo, umsebenzi ushiya idijithi eyodwa kuphela ngakwesokudla kwephoyinti ledidimali futhi ujikeleze kwinombolo elandelayo
• uma ukuphikisana kokubala kungalungile, zonke izindawo zedesimali zisusiwe futhi umsebenzi ujikeleza leyo nombolo yamadijithi ngakwesokunxele kwezinga elide elidumile
  • isibonelo, uma inani lempikiswano yokubala lisethelwe ku- -1 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti elidumile futhi ujikeleze idijithi yokuqala ngakwesobunxele wephoyintimenti kuze kufike ku-10 - isibonelo sesi-3 esithombeni ngenhla
  • uma inani lempikiswano yokubala selihlelwe ku- -2 , umsebenzi uzosusa wonke amadijithi ngakwesokudla kwephoyinti lesesimanje futhi ujikeleze amadijithi wokuqala nowesibili ngakwesokunxele kwephoyintimenti kuze kufike ku-100 - isibonelo sesi-5 esithombeni ngenhla

ROUNDUP Isifinyezo somsebenzi

Umsebenzi we-ROUNDUP:

• lisetshenziselwa ukunciphisa inani ngenani elithile lezindawo zamadesimali noma amadijithali;
• izohlale ijikeleza idijithi yokujikeleza phezulu;
• 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 kude ne-zero. Izinombolo ezimbi, nakuba ziyancipha ngenani lomsebenzi, zithi zihlanganiswe (izibonelo 4 no-5 esithombeni ngenhla).

02 ka 02

Umsebenzi we-ROUNDUP we-Google Spreadsheets Isinyathelo ngesinyathelo Isibonelo

Isibonelo: Ukusebenzisa umsebenzi we-ROUNDUP kuma-Google Spreadsheets

Njengoba kuboniswe esithombeni ngenhla, lesi sibonelo sizosebenzisa umsebenzi we-ROUNDUP ukunciphisa inombolo kuseli A1 kuya ezindaweni ezimbili zedesimali. Ngaphezu kwalokho, kuzokwandisa inani ledijithi yokujikeleza eyodwa.

Ukuze ubonise umphumela wokubamba izinombolo kunamanani, kokubili inombolo yokuqala kanye ne-ohlangene izobe yanda ngo-10 futhi imiphumela iqhathaniswa.

Ukufaka idatha

Faka imininingwane elandelayo kumaseli akhethiwe.

Idatha yedatha A1 - 242.24134 B1 - 10

Ukufaka umsebenzi we-ROUNDUP

I-Google Spreadsheets ayisebenzisi amabhokisi okuxoxa ukuze ufake izingqinamba zomsebenzi njengoba zingatholakala ku-Excel. Esikhundleni salokho, inebhokisi elikhombisa ukuzenzekelayo eliphambuka njengoba igama lomsebenzi lifakwe esitokisini.

1. Chofoza ku-cell A2 ukuze wenze iseli elisebenzayo - yilapho imiphumela yomsebenzi we-ROUNDUP izoboniswa khona
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi we- roundup
3. Njengoba uthayipha, ibhokisi lokusikisela ngokuzenzakalelayo livela ngamagama wemisebenzi eqala ngencwadi R
4. Uma igama le- ROUNDUP livela ebhokisini, chofoza igama nge-pointer yegundane ukufaka igama lomsebenzi bese uvula ibakaki nxazonke esitokisini A2

Ukufaka izimpendulo zomsebenzi

1. Ngesikhombisi esitholakale ngemuva kwesibhakela evulekile, chofoza ku-cell A1 kushidi lokusebenzela ukuze ufake leyo ngqangi yeselula emsebenzini njengombango weNombolo
2. Ukulandela ireferensi yeseli, thayipha i-comma ( , ) ukuze usebenze njengomhlukanisi phakathi kwezimpikiswano
3. Ngemuva kohlobo lwe-comma enye "2" njengengxabano yokubala ukunciphisa inani lezinombolo zamadesimali ngenani ku-A1 kusuka ku-5 kuya kweyesithathu
4. Thayipha ibhakha lokuvala " ) " ukuqedela izingqinamba zomsebenzi
5. Cindezela ukhiye wokungena kwikhibhodi ukuqedela umsebenzi
6. Impendulo 242.25 kufanele ivele esitokisini A2
7. Uma uchofoza ku-cell A2 umsebenzi ophelele = ROUNDUP (A1, 2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela

Ukusebenzisa Inombolo Eningi Ngezibalo

Esithombeni esingenhla, inani eliseli cell C1 lifomathiwe ukubonisa amadijithi amathathu kuphela ukwenza inombolo ilula ukufunda.

1. Chofoza kuseli C1 ukuze wenze iseli elisebenzayo - yilapho ifomu lokuphindaphinda lizofakwa
2. Thayipha uphawu olulinganayo ukuze uqale ifomula
3. Chofoza kuselili A1 ukungena kulolo fenethi yeseli kufomula
4. Thayipha i-asterisk (*) - uphawu lokuphindaphinda ku-Google Spreadsheets
5. Chofoza kuseli B1 ukuze ufake leyo reference yefomula kwifomula
6. Cindezela ukhiye wokungena kwikhibhodi ukuqedela ifomula
7. Impendulo engu- 2,422.413 kufanele ivele kuseli C1
8. Thayipha inombolo engu- 10 kuseli ye-B2
9. Chofoza kuseli C1 ukuze wenze iseli esebenzayo.
10. Kopisha ifomula ku-C1 kwiseli C2 usebenzisa i- Fill Handle noma Kopisha no-Namathisela
11. Impendulo engu- 2,422.50 kufanele ivele esitokisini C2.

Ifomula ehlukile ephumela kumaseli C1 no-C2 - 2,422.413 nango- 2,422.50 ibonisa ukuthi izinombolo ezizungezile zingase zibe nokubala, okungaba yizibalo ezibalulekile ezimweni ezithile.