Uhlu lweeNgcaciso kwiGoogle Spreadsheets

Umfanekiso kwimiboniso yokusekhohlo kwaye unikeza inkcazo yeenombolo zeziphumo ezibuyiselwe ngumsebenzi we-Google Spreadsheets 'ROUNDUP yedatha kwikholam A yephepha lokusebenzela. Iziphumo, eziboniswe kwikholam C, zixhomekeke kwixabiso lempikiswano yokubala - ulwazi olungaphezulu ngezantsi.

01 ka 02

Umsebenzi weROUNDUP weGoogle Spreadsheets

I-Numeri ejikelezayo kwiGoogle Spreadsheets

Umfanekiso ongasentla ubonisa imizekelo kwaye unikeza inkcazo yeenombolo zeziphumo ezibuyiselwe ngumsebenzi we-Google Spreadsheets 'ROUNDUP yedatha kwikholam A yephepha lokusebenzela.

Iziphumo, eziboniswe kwikholam C, zixhomekeke kwixabiso lempikiswano yokubala - ulwazi olungaphezulu ngezantsi.

I-Syntax yeMisebenzi ye-ROUNDUP kunye neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano.

I-syntax yomsebenzi weROUNDUP yile:

= ROUNDUP (inani, 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 kwinani elilandelayo
• ukuba ingxabano yokubala ayiyiyo, zonke izithuba ezisemgangathweni zisuswe kwaye umsebenzi ujikeleza loo nombolo yamanani ukuya kwesobunxele kwinqanaba lokugqibela ukuya phezulu
  • umzekelo, ukuba ixabiso lempikiswano yokubala lisetyenziswe ku- -1 , umsebenzi uya kususa amadijithi onke ukuya ngasekunene kwinqanaba lokugqibela kwaye ujikeleze idijithi yokuqala ukuya kwesobunxele kwi-decimal ukuya kwi-10 - umzekelo wesi-3 kumfanekiso ngasentla
  • ukuba inani lempikiswano yokubala libekwe ku-- 2 , umsebenzi uya kususa onke amadijithi ukuya ngasekunene kwinqanaba lokugqibela kwaye ujikeleze idijithi zokuqala neyesibini ukuya kwesobunxele be-decimal ukuya kwi-100 - umzekelo wesi-5 kumfanekiso ongentla

ROUNDUP Isishwankathelo somsebenzi

Umsebenzi weROUNDUP:

• isetyenziswe ukunciphisa ixabiso ngenani elithile leendawo zokugqibela okanye idijithi;
• ziya kuhlala zijikeleza umgca wokujikeleza phezulu;
• iguqula ixabiso leedatha kwindlela yokwenza iifom yeefom yeefayile ezingafaniyo ezikuvumela ukuba utshintshe inani leendawo zokugqibela ezingabonakaliyo ngaphandle kokutshintsha ixabiso kwiseli;
• ichaphazela iziphumo zokubala ngenxa yolu tshintsho kwidatha.
• soloko ejikeleza kude ne-zero. Amanqaku angalunganga, nangona ayancipha kwintengo ngomsebenzi, kuthiwa idibene (imizekelo 4 kunye no-5 kumfanekiso ongentla).

02 we 02

I-Google Spreadsheets 'I-ROUNDUP Umsebenzi Umsebenzi wesinyathelo ngesinyathelo

Umzekelo: Ukusebenzisa umsebenzi weROUNDUP kwi-Google Spreadsheets

Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo uya kusebenzisa umsebenzi weROUNDUP ukunciphisa inani kwiseli ye-A1 ukuya kwiindawo ezimbini zokugqibela. Ukongezelela, iya kwandisa inani ledidi yokujikeleza enye.

Ukubonisa umphumo weenombolo ezijikelezayo kubalo, kubini inamba yokuqala kunye nomjikelo uya kwandiswa ngo-10 kwaye iziphumo zifaniswe.

Ukungena kwiDatha

Faka idatha elandelayo kwiiseli ezikhethiweyo.

Idatha yedatha A1 - 242.24134 B1 - 10

Ukufaka umsebenzi weROUNDUP

I-Google Spreadsheets ayisebenzisi ibhokisi yencoko yababini yokufaka iingxoxo zomsebenzi njengoko zifumaneka kwi-Excel. Endaweni yoko, inebhokisi ephakanyiswa yi- auto ephakamisa njengoko igama lomsebenzi lifakwe kwiseli.

1. Cofa kwifowuni A2 ukwenza i- cell esebenzayo- yilapho iziphumo zomsebenzi weROUNDUP ziza kuboniswa
2. Thayipha uphawu olulinganayo (=) olulandelwe igama lomsebenzi ojikelezayo
3. Njengoko uthayipha, ibhokisi ephakamisa ngokuzenzekelayo ibonakala ngamagama emisebenzi eqala ngeleta R
4. Xa igama ROUNDUP livela kwibhokisi, nqakraza kwigama kunye ne-pointer ye mouse ukuze ufake igama lomsebenzi kwaye uvule ibakaki elijikelezayo kwi-cell A2

Ukungena kwiMigqaliselo yeMisebenzi

1. Ngesikhombisi esilandelwe emva kwesibini evulekileyo, cofa kwi-cell A1 kwiphepha lokusebenzela ukuze ufake eso saziso senkonzo kwindawo njengeNombolo yezizathu
2. Ukulandela iselferensi yeseli, thayipha i-comma ( , ) ukuze wenze njengomhluli phakathi kweengxoxo
3. Emva kohlobo lwe-comma enye "2" njengengxabano yokubala ukunciphisa inani leendawo zokugqibela zexabiso kwi-A1 ukususela ezintlanu ukuya kwiintathu
4. Thayipha ibhondi yokuvala ejikelezayo " ) " ukugqiba iingxoxo zomsebenzi
5. Cinezela ukhiye wokungena kwikhibhodi ukugqiba umsebenzi
6. Impendulo ye-242.25 ifanele ivele kwiseli ye-A2
7. Xa ucofa kwiseli A2 umsebenzi opheleleyo = ROUNDUP (A1, 2) ibonakala kwifom yefomula ngaphezu kwiphepha lokusebenzela

Ukusebenzisa iNani eliBhaliweyo kuBalo

Kulo mfanekiso ungentla, ixabiso kwi-cell C1 lifomathiweyo ukubonisa idijithi ezintathu kuphela ukwenzela ukuba inombolo ilula ukufunda.

1. Cofa kwifowuni C1 ukwenzela ukuba yenze iseli esebenzayo - yiyo apho ifomula yokuphindaphinda iya kufakwa
2. Thayipha uphawu olulinganayo ukuqala ifom
3. Cofa kwiseli A1 ukungena kuloo fom yesalathiso kwifom
4. Thayipha i-asterisk (*) - isimboli sokuphindaphinda kwi-Google Spreadsheets
5. Cofa kwifowuni B1 ukungena kuloo fom yeseli kwifom
6. Cinezela ukungena kwikhibhodi ukugqiba ifom
7. Impendulo ye- 2,422,413 ifanele ivele kwiseli C1
8. Thayipha inombolo 10 kwi-cell B2
9. Cofa kwiseli C1 ukwenzela ukuba yenze iseli esebenzayo.
10. Kopisha ifom e C1 kwiseli C2 usebenzisa i- Fill Handle okanye Kopisha kunye Namathisela
11. Impendulo ye- 2,422.50 ifanele ivele kwiseli C2.

Iifom ezahlukeneyo ziphumo kwiiseli C1 no-C2 - 2,422.413 nxamnye ne- 2,422.50 ibonisa ukuba iinombalo ezijikelezayo zingabakho kubalo, okungaba ngumlinganiselo obalulekileyo kwiimeko ezithile.