Kudzora Nhamba Kubva kuGoogle Spreadsheets

Mufananidzo wacho kuruboshwe unoratidza mienzaniso uye inopa tsanangudzo yemigumisiro yakawanda yakadzorerwa neGoogle Spreadsheets 'ROUNDUP basa ye data mukhomu A yemushandi webasa. Zvigumisiro, zvinoratidzwa muchitsauko C, zvinotarisana nezvakakosha zvekuverengera kuverenga - mamwe mashoko ari pasi apa.

01 ye 02

Google Spreadsheets 'ROUNDUP Basa

Kuramba Nhamba Kubva kuGoogle Spreadsheets

Mufananidzo wacho pamusoro apa unoratidza mienzaniso uye inopa tsanangudzo yemitemo yakawanda yakadzorerwa neGoogle Spreadsheets 'ROUNDUP basa ye data mukhomu A yemushandi webasa.

Zvigumisiro, zvinoratidzwa muchitsauko C, zvinotarisana nezvakakosha zvekuverengera kuverenga - mamwe mashoko ari pasi apa.

Iko Syntax Function uye Arguments ROUNDUP

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.

Mutsara webasa reROUNDUP ndewokuti:

= ROUNDUP (nhamba, nhamba)

Nharo dzebasa iri:

nhamba - (inoda) kukosha kwekukomberedza

• Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza kana inogona kuva sero rinotarisa kune nzvimbo yedhesi iri mubhuku remabasa .

kuverenga - (zvichida) nhamba yematunhu ekudarika kubva

• kana nharo yekuverengeka isingabvumirwi, basa racho rinotenderera huwandu kusvika kune inowanikwa yakakwana
• kana nharo yekuverengeka yakagadzirirwa ku 1, somuenzaniso, basa rinosara chidimbu chimwe chete kune kodzero yepamusoro yepamusoro uye ichikomberedza kusvika kune nhamba inotevera
• kana nharo yekuverenga isisina kunaka, nzvimbo dzose dzekusimudza dzinobviswa uye basa rinotenderera iyo nhamba yezvijerengero kusvika kuruboshwe rwechirevo chepamusoro zvichikwira
  • somuenzaniso, kana kukosha kwechikonzero chekuverenga kuchiiswa ku -1 , basa rinobvisa nhamba dzose kusvika kurudyi rwekodhi yepamusoro uye zvakakomberedza chidimbu chekutanga kune kuruboshwe rwemasimendi kusvika kusvika 10 - muenzaniso 3 mumufananidzo pamusoro
  • kana kukosha kwechikonzero chekuverenga kuchiiswa ku -2 , basa racho rinobvisa nhamba dzose kusvika kune kodzero yepamusoro yepamusoro uye kumativi ekutanga uye wechipiri madivi kusvika kuruboshwe rwemasimende kusvika kusvika 100 - muenzaniso 5 mumufananidzo pamusoro apa

ROUNDUP Function Summary

Basa ROUNDUP:

• inoshandiswa kuderedza kukosha nenhamba chaiyo yepamusoro nzvimbo kana nhamba;
• inogara ichitenderera chidimbu ichikwira kumusoro;
• inoshandisa kukosha kwemashoko ari muchitokisi - kusiyana nemafuta ekugadzirisa ayo anokubvumira kuti uchinje nhamba yezvimbo dzepamusoro dzakaratidzwa kunze kwekugadzirisa kukosha muchitokisi;
• inokanganisa migumisiro yezviverengero nekuda kwekushanduka uku munharaunda.
• nguva dzose inotenderera kure ne zero. Nhamba dzisina kunaka, kunyange zvazvo dzakaderera mukukosha kuburikidza nebasa racho, dzinonzi dzakapoteredzwa (mienzaniso 4 ne5 mumufananidzo uri pamusoro).

02 of 02

Google Spreadsheets 'ROUNDUP Basa Nhanho Nhanho Muenzaniso

Muenzaniso: Kushandisa Basa ROUNDUP muGoogle Spreadsheets

Sezvakaratidzwa mumufananidzo uri pamusoro, muenzaniso uyu uchishandisa basa ROUNDUP kuderedza nhamba muchitokisi A1 kusvika kune dzimwe nzvimbo mbiri. Mukuwedzera, iyo ichawedzera kukosha kwekombodhi imwe neimwe.

Kuratidza mhinduro inopoteredza nhamba ine kuverenga, zvose nhamba yepakutanga uye yakarongeka ichazowedzerwa ne10 uye mhinduro dzichaenzaniswa.

Kupinda Data

Ita zvinotevera data mumasero akasarudzwa.

Cell Data Data A1 - 242.24134 B1 - 10

Kupinda Basa ROUNDUP

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.

1. Dzvanya pachitokisi A2 kuti uite sero inoshandiswa - iyi ndiyo iyo migumisiro yebasa ROUNDUP icharatidzwa
2. Torai chiratidzo chakafanana (=) chinotevera zita rebasa roundup
3. Sezvaunonyora, bha-self- bhokisi bhokisi rinowanikwa nemazita emabasa anotanga netsamba R
4. Apo zita rokuti ROUNDUP rinowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rose muchitokisi A2

Kupinda Maitiro Ebasa

1. Nebhokisi rinowanikwa mushure mekuvhara mabheji akazaruka, chengeta pane cell A1 mune pepa rekushandisa kuti uise iyo sero rekuita mubasa seNhamba yenyaya
2. Kutevera sero rinoshandiswa, tora chikamu ( , ) kuti uite separadzanisa pakati pemakakatanwa
3. Mushure mokunge mutauro wechirungu imwe "2" seyo nhamba yekuverengera kuderedza nhamba yezvimbo dzepamusoro dzekukosha muA1 kubva pa5 kusvika kune matatu
4. Tora chivharo chakavhara " ) " kupedzisa nharo dzebasa
5. Dhinda pikicha inopinda mubhokisi kuti upedze basa
6. Mhinduro 242.25 inofanira kuonekwa muchitokisi A2
7. Paunenge uchinge uri pa cell A2 yakakwana basa = ROUNDUP (A1, 2) inowanikwa mubhadha yepamusoro pane pepa rekushanda

Kushandisa Nhamba Yakakosha Mukuverenga

Mumufananidzo wepamusoro, kukosha muchitokisi C1 zvakagadzirirwa kuratidza mazita matatu chete kuitira kuti nhamba ive nyore kuverenga.

1. Dzvanya pachitokisi C1 kuti uite iyo inoshanda masero - iyi ndiyo iyo fomu yekuwedzera inopinda
2. Tora chikamu chakaenzana kuti utange fomu
3. Dzvanya pachitokisi A1 kuti uise iyo seferensi iri mumutsetse
4. Tora asterisk (*) - chiratidzo chokuwedzera muGoogle Spreadsheets
5. Dzvanya pane sero B1 kuti uise iyo sero rekuita mumutsetse
6. Dhinda pikicha inopinda mubhokisi kuti upedze fomu
7. Mhinduro 2 422.413 inofanira kuonekwa muchitokisi C1
8. Tora iyo nhamba 10 mu cell B2
9. Dzvanya pachitokisi C1 kuti uite sero rinoshanda.
10. Nyora chimiro muC1 pane imwe c C2 uchishandisa Fill Handle kana Kopi uye Nyanya
11. Mhinduro 2 422.50 inofanira kuonekwa muchitokisi C2.

Chimiro chakasiyana chinoguma mumasero C1 neC2 - 2,422.413 vs. 2 422.50 inoratidza kuitika kwehuwandu huwandu hunogona kuve nokuverenga, iyo inogona kuva yakakosha mumamwe mamiriro ezvinhu.