Nzira Yokukwikwidza Nhamba Kubva muEexcel Nebasa ROUNDDOWN

01 ye 01

Excel ROUNDDOWN Basa

Basa ROUNDDOWN:

• inoshandiswa kuderedza kukosha nenhamba chaiyo yepamusoro nzvimbo kana nhamba;
• nguva dzose dzicharamba dzichikomberedza yakafanana;
• 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 kune zero. Nhamba dzisina kunaka, kunyange zvazvo dzichiwedzera mukukosha kuburikidza nebasa racho, dzinonzi dzakapoteredzwa - sezvinoratidzwa mumienzaniso mumitsara mashanu nematanhatu mumufananidzo uri pamusoro).

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, Num_digits)

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.

Num_digits - (inotarisirwa) nhamba yezviverengero izvo nhamba yeNhamba ichakomberedza.

• kana iyo Num_digits kukakavara yakagadzirirwa ku 0, basa racho rinotenderera huwandu kusvika kune imwe nzvimbo iri pedyo
• kana Num_digits nharo yakagadzirirwa ku 1, basa rinosara chidimbu chimwechete kune kodzero yepamusoro yepamusoro uye ichikomberedza kusvika kunhamba inotevera
• kana Num_digits kukakavara isingaiti, nzvimbo dzose dzekusimudza dzinobviswa uye basa rinotenderera iyo nhamba yezvidimbu kusvika kuruboshwe rwechirevo chepamusoro kusvika kune zero
  • somuenzaniso, kana kukosha kweNgu_digits kukaka kuiswa ku -2 , basa racho richabvisa nhamba dzose kusvika kurudyi rwepasimari yepamusoro uye zvakapoteredza chikamu chekutanga uye chechipiri kune kuruboshwe rwemasimendi kusvika kune zana iri pedo sezvinoratidzwa mune muenzaniso mumutsara we 6 mumufananidzo uri pamusoro

ROUNDDOWN Function Examples

Mufananidzo uyu pamusoro apa unoratidza mienzaniso uye inopa tsanangudzo yemitemo yakawanda yakadzorerwa neExcel ROUNDDOWN basa ye data iri mumutsara A webasa.

Migumisiro, inoratidzwa muchitsauko B, inotarisa pamusoro pekukosha kweNgu_digits nharo .

Iro mirairo iri pasi apa tsanangudzo matanho akatorwa kuderedza nhamba muchitokisi A2 mumufananidzo uri pamusoro apa kune nzvimbo mbiri dzinoshandiswa uchishandisa basa ROUNDDOWN. Nokuti basa racho rinogara rakapoteredza pasi, nhamba yokukomberedza haizoshanduki.

Kupinda Basa ROUNDDOWN

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

• Kunyora basa rakakwana: = ROUNDDOWN (A2.2) muchikamu cheC3 mune pepa rekushanda;
• Kusarudza basa uye nharo kushandisa sarudzo yebhokisi rebasa.

Kushandisa bhokisi rebhokisi kunobatanidza kupinda mumagariro ebasa. Nenzira iyi, hazvidiwi kupinda mavhamusi pakati pemashoko ose ehupenyu sezvaanofanira kuitwa kana basa racho richiiswa muchitokisi - munyaya iyi pakati peA2 ne2.

Nhanho dziri pasi apa dzinopinda kupinda muROUNDDOWN basa uchishandisa bhokisi rebhokisi.

1. Dzvanya pachitokisi C3 kuti uite sero rinoshandiswa - iyi ndiyo iyo migumisiro yeROUNDDOWN basa icharatidzwa;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rinoyerera pasi;
4. Dzvanya kuROUNDDOWN mune urongwa kuti ubudise bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi kani paNhamba yemurongo;
6. Dzvanya pachitokisi A2 mune pepa rekushandisa kuti uise iyo seferensi yebhokisi mubhokisi rebhokisi senzvimbo yechirangaridzo;
7. Dzvanya pane Num_digits line;
8. Tora aviri "2" kuderedza nhamba muA2 kubva pa5 kusvika kune maviri decimal nzvimbo;
9. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubasa rekushanda;
10. Mhinduro 567.96 inofanira kuonekwa muchitokisi C3;
11. Paunenge uchinyora pachitsime C2 yakakwana basa = ROUNDDOWN (A2, 2) inowanikwa mubhairi yepamusoro pane pepa rekushanda .