Nhamba dzakapoteredza kune imwe nhamba yakatarwa yenhamba
MuExcel, basa reROUND rinoshandiswa kumativi ose kune nhamba yakatarwa yenhamba. Inogona kutenderera kune rumwe rutivi rwepasimusi. Kana ichiita izvi, inoshandisa kukosha kwedhesi iri mumasero-asina kufanana maitiro ekufambisa anokubvumira kuti uchinje nhamba yenzvimbo dzepamusoro dzinoratidzirwa kunze kwekushandura kukosha kwemukati. Somugumisiro wekushanduka uku munharaunda, basa reROUND rinosangana nemigumisiro yekuverenga mune pepanheti.
01 ye 02
Shanduro yeROUND Function yeSintax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara webasa ROUND ndeyekuti:
= ROUND (Number, Num_digits)Nharo dzebasa iri Nhamba uye Nhamba dzeMitauro:
Nhamba ndeye kukosha kwekukomberedza. Iyi nharo inogona kuva nemashoko chaiwo ekukomberedza, kana inogona kuva sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda. Icho chinhu chinodiwa.
Num_digits ndiyo nhamba yenhamba iyo Nhamba yeNhamba ichapoteredzwa. Inotarisirwawo.
- Kana iyo_iyo inogadzirisa nhaurirano ichiiswa kune zero, basa rinotenderera huwandu hwepamusoro kana pasi kune imwe nzvimbo iri pedyo.
- Kana Nhamba_kuita nharo yakakura kudarika zero, kukosha kwakapoteredzwa kune nhamba yakatarwa yezvimbo dzepamusoro.
- Kana kukosha kweNgu_digits kukwikwidzana kwakagadzirirwa ku 2 , basa rinosiya madivi maviri kusvika kune kodzero yepamusoro yepamusoro uye kumativi ose ekupedzisira digit up kana pasi kune nhamba inotevera.
- Kana iyo_iyo inopikisana nharo isina kunaka, nzvimbo dzose dzekusimudza dzinobviswa uye basa rinopoteredza kana kuti pasi pasi nhamba yezviverengero kusvika kuruboshwe rwepamusoro.
- Kana kukosha kweNgu_digits kukwikwidzana kuri ku -2 , basa rinobvisa nhamba dzose kusvika kurudyi rwepakati yepamusoro uye kumativi kwekutanga uye yechipiri madivi kusvika kuruboshwe rwechirevo chepamusoro kusvika kumusoro kusvika kune zana iri pedyo.
Cherechedza: Kana iwe nguva dzose uchida kukomberedza nhamba kumusoro, shandisa basa ROUNDUP. Kana iwe nguva dzose uchida kukomberedza nhamba pasi, shandisa basa ROUNDDOWN.
02 of 02
ROUND Basa Basa
Chifananidzo chinotevera chinyorwa ichi chinoratidza mienzaniso yezviitiko zvakawanda zvakadzorerwa neExcel ROUND basa kune data iri muvharamu A ye pepa rekushanda.
Migumisiro, inoratidzwa muchitsauko C, inotarisa pamusoro pehuwandu hweMag_digits mhirizhonga.
Sarudzo dzekupinda Basa ROUND
Somuenzaniso, kuderedza nhamba 17.568 muchikamu cheA5 mumufananidzo kune mbiri nzvimbo dzinoshandisa shanduro yeROUND, zvigaro zvekupinda mubasa uye nharo dzayo dzinosanganisira:
- Kunyora basa rakakwana: = ROUND (A5.2) muchikamu cheC5 mune pepa rekushanda
- Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa.
Kunyange zvazvo zvichikwanisika kunyora basa rakakwana nemaoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa.
Mashandisiro Aungaita Bhokisi reDhialog
Nokuda kwemuenzaniso uyu, shandisai Excel spreadsheet uye shandisa mazano mumutsetse A wemufananidzo muchikamu chakakodzana nemitsetse yespredishiti.
Kuti ushandise bhokisi rebhokisi kuti uite basa reROUND muchikamu C5:
- Dzvanya pachitokisi C5 kuti uite sero rinoshanda. Iyi ndiyo iyo migumisiro yebasa reROUND icharatidzwa.
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure urongwa hwekuderera pasi.
- Dzvanya paROUND mumutsetse kuti ubudise bhokisi rebasa rebasa racho.
- Mubhokisi rebhokisi, tora paNhamba yemurongo.
- Dzvanya pane sero A5 mune pepa rekushanda kuti uise iyo seferensi iri mubhokisi rebhokisi.
- Dzvanya pane Num_digits line.
- Tora a 2 kuti kuderedze kukosha muA5 kusvika kumadhora maviri.
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
Mhinduro 17.57 inofanira kuonekwa muchitokisi C5. Paunenge uchinyora pachitanhatu C5, basa rakakwana = ROUND (A5,2) rinowanikwa mubhairi yepamusoro pane pepaji.
Chikonzero nei Basa reROUND Radzokera 17.57
Kuisa kukosha kweNgu_digits nharo kusvika kuna 2 kunoderedza nhamba yezvimbo dzepamusoro mune mhinduro kubva pa3 kusvika kune maviri. Nemhaka yokuti Num_digits yakagadzirirwa ku 2, iyo 6 mu nhamba 17.568 ndiyo inotenderera.
Sezvo kukosha kune kodzero yekukomberedza-nhamba ye8-yakakura kudarika 4, nhamba yekutenderera yakawedzerwa neyo ichipa mhinduro ye17.57.