Excel MROUND Basa

Basa reMEROUND reExcel rinoita kuti zvive nyore kutenderera nhamba zvichikwira zvichidzika zvichienda kune dzakawanda zve 5, 10, kana imwe imwe yero yakatarwa.

Somuenzaniso, basa rinogona kushandiswa kukomberedza kana kuderedza mari yezvinhu kune iri pedyo:

• masendi mashanu (0.05)
• makumi gumi (0.10)

kuti urege kubata nemapeni (0.01) sekuchinja.

Kusiyana nekugadzirisa mafungiro anokubvumira kuti uchinje nhamba yezvimbo dzepamusoro dzakaratidzwa pasina chaizvoizvo kuchinja kukosha muchitokisi, basa reMROUND, seimwe yeExcel mamwe mabasa ekukomberedza, inoshandisa kukosha kwe data.

Kushandisa basa iri kuronga deta, saka, kuchakanganisa migumisiro yekuverenga.

Sangano reMROUND's Syntax uye Arguments

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

Mutsara webasa reROUNDDOWN ndewokuti:

= MROUND (Number, Multiple)

Nharo dzebasa iri:

Nhamba - (inodikanwa) 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 .

Multiple - (inoshandiswa) basa rinotenderera nharo yeNhamba kumusoro kana pasi kune vazhinji vari pedyo yeiyi kukosha.

Pfungwa dzekucherechedza pamusoro pemashoko ekushanda ndezvekuti:

• Nhamba uye nharo dzakawanda dzinofanirwa kuva nechiratidzo chimwechete - chine chakanaka kana chakaipa. Kana zvisina kudaro, basa rinodzorera #NUM! kukanganisa muchitokisi.
• kana Nhamba uye nharo dzakawandisa zvose zvisina kunaka, basa rinodzoka nhamba isina kunaka muchitokisi sezvinoratidzwa mumutsara wechina mumufananidzo uri pamusoro.
• kana iyo Multiple argument yakagadzirirwa ku zero (0), basa rinodzorera kukosha kwe zero muchitokisi sezvaratidzwa mumutsara wechinomwe mumufananidzo uri pamusoro.

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

Maererano neExcel faira refaira, kuti basa racho rinosarudza sei kuti rive rakapoteredza nhamba yakasara yakasara (iyo inotenderera) kumusoro kana pasi inobva pane zvakasara zvinobva pakuparadzanisa Nhamba yeNhamba neMashoko akawanda.

• Kana ichi chigumisiro chikuru kupfuura kana chakaenzana nehafu yehuwandu hweMibvunzo yakawanda, basa rinotenderera yekupedzisira digit up (kure ne zero).
• Kana izvi zvichiguma zvisingasviki hafu yehutano hwe Multiple argument, basa rinotenderera nhamba yekupedzisira pasi (kuenda kune zero).

Mienzaniso miviri yekupedzisira - mumutsara we8 ne9 wechifananidzo - inoshandiswa kuratidza kuti basa racho rinotenderera sei kana kuti pasi.

• Mumutsara we8, sezvo Multiple argument iri nhamba imwe chete, integer 2 inova inowedzeredzwa nhamba 12.50 inokosha muchitokisi A8. Kubvira pa2,5 yakaenzana nehafu yehuwandu hweMashoko akawanda (5.00), basa rinotenderera chigumisiro kusvika kusvika 15.00, iyo inowanikwa yakawanda ye500 uye yakakura kupfuura 12.50.
• Mutsara 9, kubvira 2.49 isingapfuuri hafu yehuwandu hweMa Multiple argument (5.00), basa rinotenderera chigumisiro kusvika kusvika 10.00, iyo inowanikwa yakawanda ye 5.00 pasi pe12,49.

Muenzaniso Uchishandisa Basa reMEROUND MROUND

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana: rakadai = MROUND (A2,0.05) muchengeti remashandi.
2. Kusarudza basa uye nharo dzaro kushandisa basa reMROUND dialog box .

Vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi kuti vapinde nharo dzebasa sezvo inotarisira kushandiswa kwemashoko - zvakadai semakasita anoita sevanoparadzanisa pakati penharo.

Matanho ari pasi apa anoshandisa bhokisi rebhokisi kuti uite basa rakapoteredza mumusero C2 wemuenzaniso uri pamusoro.

1. Dzvanya pachitokisi B2 kuti uite sero rinoshanda .
2. Dzvanya paMafomu tab yebhoni .
3. Dzvanya paMat & Trig icon kuti uzarure basa redu rezasi.
4. Dzvanya paMONOUND murugwaro kuti uzarure bhokisi rebasa rebasa.
5. Mubhokisi rebhokisi, tora paNhamba yemurongo.
6. Dzvanya pachitokisi A2 mune pepa rekushanda kuti uise iyi seferensi seChirungu cheNhamba .
7. Mubhokisi rebhokisi, tora paMatafura mazhinji .
8. Tora mu 0.05 - nhamba muA2 ichakomberedzwa kana pasi kune yakawanda yakawanda ye 5 cents.
9. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.
10. Kukosha 4.55 kunofanira kuonekwa muchitokisi B2, iyo inowanikwa yakawanda ye 0.05 yakakura kupfuura 4.54.
11. Paunenge uchinyora pane seki C2 yakakwana basa = MROUND (A2, 0.05) inowanikwa mubhairi yepamusoro pane pepa pepaji.