Shandisa Basa ROUNDUP muExcel kusvika kuNumber Numbers Up
Basa ROUNDUP muExcel rinoshandiswa kuderedza huwandu nehuwandu hwemadunhu ekupedzisira kana nhamba. Iri basa richagara rakapoteredza chidimbu zvichikwira, se 4.649 kusvika 4.65.
Iyi kukwanisa kukwikwidzana muExcel inodha kukosha kwe data iri muchitokisi, kusiyana nekusarudza maitiro ekukubvumira kuti uchinje nhamba yezvikwata zvepamusoro zvinoratidzirwa kunze kwekushandura kukosha muchitokisi. Nemhaka yeizvi, migumisiro yekuverenga inobata.
Nhamba dzisina kunaka, kunyange zvazvo dzakaderera mukukosha nebasa reROUNDUP, dzinonzi dzakapoteredzwa. Iwe unogona kuona mimwe mienzaniso iri pasi apa.
Excel ROUNDUP Basa
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.
Ichi ndicho chirevo chebasa reROUNDUP:
= ROUNDUP ( Number , Num_digits )Nhamba - (inoda) kukosha kwekukomberedza
Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza kana inogona kuva sero rinotarisa kune nzvimbo yedhesi iri mubhuku remabasa.
Num_digits - (inotarisirwa) nhamba yezviverengero izvo nhamba yeNhamba ichakomberedza.
- Kana Nhamba_digits kukakavara yakagadzirirwa ku 0, basa rinotenderera huwandu kusvika kune inowanikwa yakakwana;
- Kana Num_digits nharo yakagadzirirwa ku 1, basa rinosara chidimbu chimwechete kune kodzero yepamusoro yepamusoro uye ichikomberedza kusvika kunhamba inotevera;
- Kana iyo_iyo inopikisana nharo isina kunaka, nzvimbo dzose dzekusimudza dzinodzingwa uye basa rinopoteredza nhamba yezviverengero kusvika kuruboshwe rwechirevo chepamusoro kusvika kumusoro.
Cherechedza: Kuti uve muenzaniso wekupikisa kwekupedzisira, kana kukosha kweNgu_digits kukaka kuiswa ku -2 , basa racho rinobvisa nhamba dzose kusvika kurudyi rwepamusoro yepamusoro uye kumativi ekutanga uye wechipiri madivi kusvika kuruboshwe rwema decimal kusvika kune zana iri pedyo (sezvinoratidzwa mumutsara wekutanga mumuenzaniso uri pamusoro).
ROUNDUP Function Examples
Mufananidzo uyu uri pamusoro apa unoratidza mienzaniso uye inopa tsanangudzo yemigumisiro yakawanda yakadzorerwa neExpcel ROUNDUP basa ye data mu column A yemushandi.
Migumisiro, inoratidzwa muchitsauko B , inotarisa pamusoro pekukosha kweNgu_digits nharo.
Iyo mirayiridzo iri pasi apa tsanangudzo matanho akatorwa kuti kuderedze nhamba iri muchitokisi A2 mumufananidzo uri pamusoro apa kune nzvimbo mbiri dzinoshandiswa uchishandisa basa ROUNDUP. Pakugadzirisa, basa racho richawedzera kukosha kwekombodhi imwe neimwe.
Kupinda Basa ROUNDUP
Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana: = ROUNDUP (A2,2) muchikamu cheC3 mune pepa rekushanda;
- Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa.
Kushandisa bhokisi rebhokisi kunobatanidza kupinda mumagariro ebasa. Nenzira iyi, hazvidi kuisa mavhamusi pakati pezvimwe zvemashoko ekushanda sezvinofanira kuitwa kana basa racho richiiswa muchitokisi - munyaya iyi pakati peA2 ne2 .
- Dzvanya pachitokisi C3 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yebasa ROUNDUP icharatidzwa.
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure urongwa hwekuderera pasi.
- Sarudza ROUNDUP kubva pakurongwa kuti uzarure bhokisi rebasa rebasa.
- Sarudza bhokisi bhokisi riri pedyo ne "Number."
- Dzvanya pane sero A2 mune pepa rekushandisa kuti uise iyo seferensi yebhokisi mukati mebhokisi rebhokisi sekuti nzvimbo yenhamba inopoteredzwa.
- Sarudza bhokisi bhokisi riri pedyo ne "Num_digits."
- Tora 2 kuti uderedze nhamba muA2 kubva pa5 kusvika kune maviri decimal nzvimbo.
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
- Mhinduro 242.25 inofanira kuonekwa muchitokisi C3 .
- Paunenge uchinyora pachitsime C2, basa rakakwana = ROUNDUP (A2, 2) rinowanikwa mubhairi yepamusoro pane pepa pepaji .