Google Spreadsheets 'Basa reMROUND rinoita kuti zvive nyore kukomberedza nhamba zvichikwira kana kuti zvichidzika kusvika kune 5, 10, kana imwe yakawanda yakatsanangurwa.
Semuenzaniso, basa rinogona kushandiswa kukomberedza kana kuderedza mari yezvinhu kune imwe yepakati masendimashanu (0.05) kana masendi gumi (0.10) kuti arege kutarisana nemapeni (0.01) sekuchinja.
Kusiyana nekugadzirisa mafungiro anokubvumira kuti uchinje nhamba yezvikwata zvepamusoro zvinoratidzirwa kunze kwekushandura kukosha mukati memutanda, basa reMROUND, sekufanana neGoogle Spreadsheets 'mamwe mabasa okukomberedza, inoshandisa kukosha kwe data.
Kushandisa basa iri kuronga deta, saka, kuchakanganisa migumisiro yekuverenga.
Cherechedza: Kuita nhamba dzese kumusoro kana pasi kunze kwekufungidzira kuwanda kwekukomberedza, shandisa mabasa eROUNDUP kana ROUNDDOWN pane.
01 ye 04
Sangano reMROUND's Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara webasa reMROUND ndewokuti:
= MROUND (kukosha, chikonzero)
Nharo dzebasa iri:
kukosha - (inoda) nhamba inopoteredzwa kana pasi kune imwe nzvimbo iri pedyo
- Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza kana inogona kuva sero rinotarisa kune nzvimbo yedhesi iri mubhuku remabasa .
chikonzero - (chinodiwa) basa rinopoteredza kukosha kwekukwirira kumusoro kana pasi kune vazhinji vari pedyo yeiyi kukosha.
Pfungwa dzekucherechedza pamusoro pemashoko ekushanda ndezvekuti:
- kana iyo factor argument isingabvumirwi, # N / A kukanganisa mune sero rine basa.
- chinhu ichocho uye kukoshesa nharo dzinofanirwa kuva nechiratidzo chimwechete - chingava chakanaka kana chakaipa. Kana zvisina kudaro, basa rinodzorera #NUM! kukanganisa muchitokisi.
- kana icho icho uye ichikoshesa nharo dzose dzisina kunaka, basa rinodzoka nhamba isina kunaka muchitokisi sezvinoratidzwa mumutsara wechina mumufananidzo uri pamusoro.
- kana iyo factor argument yakagadzirirwa ku zero (0), basa rinodzorera kukosha kwe zero muchitokisi sezvinoratidzwa mumutsara wechinomwe mumufananidzo uri pamusoro.
02 of 04
MROUND Function Mienzaniso
Mumufananidzo wepamusoro, pamitambo mitanhatu yekutanga, nhamba ye4,54 yakakoromorwa kana yakaderedzwa nebasa reMROUND vachishandisa maitiro akasiyana-siyana echinhu chinokonzera sa 0.05, 0.10, 5.0, 0, uye 10.0.
Zvigumisiro zvinoratidzwa muchitsauko C uye chirevo chinogadzira mhinduro muhomwe D.
Kupoteredza kana Kuderera
Pasinei nokuti yakasara nhamba kana integer (iyo nhamba yakakomberedza) yakapoteredzwa kana pasi inobva pane zvakakosha kugadzirisa.
- Kana iyo nhamba yekukomberedza uye nhamba dzose kusvika kurudyi rwayo muhutano hunokosha zvisingasviki hafu yehutano hwe factor argument, basa rinotenderera nhamba yekupedzisira pasi.
- Kana iyo nhamba yekukomberedza uye nhamba dzose kusvika kurudyi kwayo muhutano hwekukosha hukuru pane kana kuti yakaenzana nehafu yekubatsira kwechikonzero argument, chidimbu chekukomberedza chakakonzerwa.
Mienzaniso miviri yekupedzisira - mumutsara we8 ne9 wechifananidzo - inoshandiswa kuratidza kuti basa racho rinotenderera sei kana kuti pasi.
- Mutsara we8, sezvo chikonzero argument isiri imwe nhamba yakasimba, ye2 inova nhamba yekukomberedza nhamba ye 12.50 inokosha muchitokisi A8. Kubvira pa2,5 yakaenzana nehafu yekubatsira kwe factor argument (5.00), basa rinotenderera chigumisiro kusvika kusvika 15.00, iyo inowanikwa yakawanda ye 5.00 inopfuura 12,50.
- Mutsara 9, kubvira 2.49 iri pasi pehafu yekubatsira kwe factor argument (5.00), basa rinotenderera chigumisiro kusvika kusvika 10.00, iyo inowanikwa yakawanda ye 5.00 pasi pe12,49.
03 of 04
Kupinda Basa reMROUND
Google Spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.
- Isa data inotevera inesei A1: 4.54
- Dzvanyira pane cell C2 mune pepa rekuita kuti iite sero rinoshandiswa - iyi ndiyo iyo migumisiro yebasa reMROUND icharatidzwa
- Tora chiyero chinokwana (=) chinotevera zita rebasa rakasungwa
- Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita emabasa anotanga netsamba M
- Apo zita rokuti MROUND rinowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rakapinda muchitokisi C2
04 we 04
Kupinda Basa reMabasa
Nharo dzebasa reMROUND dzinopinda mushure mekuzaruka kwebhuka rakapoteredza muchitokisi C2.
- Dzvanya pachitokisi A2 mune pepa rekushandisa kuti uise iyi seferensi sechirongwa chekukosha
- Pinda nhaurirano kuti uite separadzanisi pakati pemashoko ekushanda
- Tora 0.05 kuti uite iyi nhamba sechinhu argument
- Dhinda pikicha inopinda mubhobhoyo kuti uise bhokisi rakapoteredza " ) " mushure mekushanda kwebasa uye kupedza basa
- Kukosha 4.55 kunofanira kuonekwa muchitokisi B2, iyo inowanikwa yakawanda ye 0.05 yakakura kupfuura 4.54
- Paunenge uchinge uri pachitsime C2 yakakwana basa = MROUND (A2, 0.05) inowanikwa mubhairi yepamusoro pane pepa rekushanda