01 of 03
Google Spreadsheets 'ROUND Basa
Basa ROUND rinogona kushandiswa kuderedza kukosha nenhamba chaiyo yepamusoro nzvimbo.
Muchiitiko chacho, chidimbu chekupedzisira, chidimbu chekukomberedza, chakakoshwa kana pasi.
Mitemo yepamusoro yenhamba iyo Google Spreadsheets inotevera, inotsanangurira;
- Kana kukosha kwenhamba kuchikwangwani chekukomberedza kune chikamu chiduku kupfuura zvishanu, nhamba yekukomberedza yakasara isina kuchinjwa;
- Kana kukosha kwenhamba kuchikwangwani chekukomberedza kune zvishanu kana kupfuura, nhamba yekukomberedza inokurudzirwa nemumwe.
Uyewo, kusiyana nemafuta ekugadzirisa zvinokubvumira kuti uchinje nhamba yedzimba dzepamusoro dzakaratidzwa kunze kwekushandura kukosha muchitokisi, basa reROUND, seGoogle Spreadsheets 'mamwe mabasa okukomberedza, rinoshandisa kukosha kwe data.
Kushandisa basa iri kuronga deta, saka, kuchakanganisa migumisiro yekuverenga.
Mufananidzo uri pamusoro apa unoratidza mienzaniso uye inopa tsanangudzo yemitengo yakawanda yakadzorerwa neGoogle Spreadsheets 'ROUNDDOWN basa ye data iri muvharamu A yemushandi webasa.
Zvigumisiro, zvinoratidzwa muchitsauko C, zvinotarisa pamusoro pehutano hwekuverenga nharo - ona mashoko pasi apa.
02 of 03
Izwi reROUNDDOWN Function's Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.
Mutsara webasa reROUNDDOWN ndewokuti:
= ROUNDDOWN (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 nhauriro yekuverengeka isiripo, basa racho rinotenderera huwandu kusvika kune imwe nzvimbo iri pedyo
- Kana nharo yekuverengeka yakagadzirirwa ku 1, somuenzaniso, basa racho rinongoita chidimbu chimwechete kune kodzero yepamusoro yepamusoro uye ichikomberedza kusvika kunhamba inotevera
- Kana nharo yekuverenga isisina kunaka, nzvimbo dzose dzekupedzisira dzinobviswa uye basa rinotenderera iyo nhamba yezvijerengero kusvika kuruboshwe rwechirevo chepamusoro zvichidzika
- Somuenzaniso, kana kukosha kwenyaya yekuverenga kuiswa ku -1 , basa racho rinobvisa nhamba dzose kusvika kurudyi rwekodhi yepamusoro uye dzakakomberedza chidimbu chekutanga kuruboshwe rwechimakumi zvinosvika kusvika 10 - muenzaniso 2 mufananidzo pamusoro
- Kana kukosha kwechikonzero chekuverenga kuchiiswa ku -2 , basa racho rinobvisa nhamba dzose kusvika kune kodzero yepamusoro yepamusoro uye kumativi ekutanga uye wechipiri nhamba kusvika kuruboshwe rwechimumiro kusvika kune zana - muenzaniso 4 mumufananidzo uri pamusoro
03 of 03
ROUNDDOWN Function Summary
Basa ROUNDDOWN:
- Inoshandiswa kuderedza huwandu nehuwandu humwe hwemashure ekudarika kana nhamba;
- Nguva dzose usiye iyo inotenderera chidimbu isingashandurwi - haisati yakurongedza;
- Inoshandisa kukosha kwe data iri muchitokisi - kusiyana nemafuta ekufambisa ayo anokubvumira kuti uchinje nhamba yenzvimbo dzepamusoro dzakaratidzwa kunze kwekushandura kukosha muchitokisi;
- Inoguma migumisiro yezviverengero nekuda kwekushanduka uku munharaunda.
- Nguva dzose inotenderera kune zero. Nhamba dzisina kunaka, kunyange zvazvo dzichiwedzera mukukosha kuburikidza nebasa racho, dzinonzi dzakapoteredzwa (mienzaniso 4 ne5 mumufananidzo uri pamusoro).