Shandisa INT Function kuNyorera pasi kune Nearest Integer mu Excel

01 ye 01

Excel's INT Function

Kana zvasvika pakukomberedza nhamba, Excel ine mabasa akawanda ekukomberedza kuti uwane kubva uye basa raunosarudza rinoenderana nemigumisiro yaunoda.

Muchiitiko cheIn INT function, inogara ichitenderera nhamba pasi kusvika kune inotevera yakaderera pasi apo ichibvisa chikamu chechi decimal chechiverengero.

Kusiyana nekugadzirisa mafungiro ayo anokubvumira kuti uchinje nhamba yezvimbo dzepamusoro dzinoratidzirwa pasina hukanganisa dhesi yepasi, iyo INT function inoshandura dheta iri mune pepa rako rekushanda . Kushandisa basa iri kunogona, zvino, kunopisa mhinduro dzekuverenga.

Nhengo yeSt Function yeSintax uye Arguments

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

Mutsara weInt function ndiwo:

= IN (Nhamba)

Nhamba - (inodikanwa) kukosha kwekukomberedza. Iyi nharo inogona kuva:

• iyo chaiyo data yekutenderera-mutsara 2 mumufananidzo uri pamusoro;
• sero rinotarisa kune nzvimbo yedhesi mubasa rekushanda - rutsara 3 pamusoro apa.

INT Basa Rinoshandiswa Muenzaniso: Dzorera Pasi kune Nearest Integer

Uyu muenzaniso unotsanangura matanho anoshandiswa kupinda muIn INT basa muchikamu B3 mumufananidzo uri pamusoro.

Kupinda IN Function

Zvisarudzo zvekupinda mubasa uye nharo dzayo dzinosanganisira:

1. Kunyora basa rakakwana: = INT (A3) muchikamu B3;
2. Kusarudza basa uye mazano ayo achishandisa INT function dialog box .

Kunyange zvazvo zvichibvira kungopinda basa rakakwana nemaoko, vanhu vazhinji vanozviona zviri nyore kushandisa bhokisi rebhokisi sezvo rinotarisira kupinda mumashandisirwo emabasa - zvakadai seakakani uye separma vatengesi pakati pemakakatanwa.

Matanho ari pasi apa anopinda muIt function achishandisa bhokisi rebasa rebasa.

Kuzarura Bhokisi reDhiyabhorosi Dialog

1. Dzvanyira pane sero B3 kuti riite sero rinoshandiswa - iyi ndiyo iyo migumisiro yeUCH function icharatidzwa;
2. Dzvanya paMafomu tab yebhoni yebhoni ;
3. Sarudza Math & Trig kubva kubhoni kuti uzarure basa rinoderedza pasi;
4. Dzvanya pa INT mumutauro kuti uunze bhokisi rebasa rebasa;
5. Mubhokisi rebhokisi, tora paNhamba yemurongo;
6. Dzvanya pane sero A3 mune pepa rekushanda kuti uise iyo seferensi iri mubhokisi rebhokisi;
7. Dzvanya OK kuti upedze basa uye dzokera kubheji rekushanda;
8. Mhinduro 567 inofanira kuonekwa muchitokisi B3;
9. Paunenge uchinyora pa cell B3 basa rakakwana = INT (B3) inowanikwa mubhairi yepamusoro pane pepa pepaji.

INT vs. TRUNC

Basa reIn INT rakafanana zvikuru nedzimwe basa reExcel rinopoteredza - iyo TRUNC basa .

Zvose zvinodzoka zvakakwana sechigumisiro, asi dzinopedza mugumisiro zvakasiyana:

• INT nhepfenyuro nhamba pasi kusvika kune imwe yenhamba iri pedyo;
• TRUNC inogadzirisa (inogumbura) chikamu chechidimbu che data pasina kukomberedza.

Kusiyana pakati pemabasa maviri kunoonekwa nehuwandu hwenhamba. Nokuda kwehutano hwakanaka, sezvinoratidzwa mumitsara 3 ne4 kumusoro, zvose INT uye TRUNC zvinodzorera kukosha kwa 567 pakubvisa chikamu chechi decimal che nhamba 567.96 muchikamu cheA3,

Mumitsara ye5 ne6, zvisinei, tsika dzakadzoka nemabasa maviri dzakasiyana: -568 vs. -567 nokuti kuvhara pasi maitiro asinganzwisisi ne INT zvinoreva kukomberedza kubva kune zero, nepo TRUNC basa inoita kuti integer iite zvakafanana apo ichibvisa chikamu chikamu yenhamba yacho.

Kudzokorora Maitiro Akanaka

Kuti udzorere chikamu kana chikamu chiduku chechiverengero, panzvimbo pechinzvimbo chakakwana, ita chirevo chekushandisa INT sezvinoratidzwa muchitokisi B7. Nokubvisa chikamu chikoro chenhamba kubva pane nhamba yose muchitokisi A7, chete chirevo chekupedzisira 0.96 chiripo.

Imwe nzira inogona kushandiswa inogona kushandiswa uchishandisa basa reMOD sezvinoratidzwa mumutsara 8. Basa reMOD - rakapfupika pamagetsi - zvinowanzodzoka pane zvakasara zvekuparadzanisa kushanda.

Kugadzirisa dudziro kune mumwe - mutungamiri ndechimwe chinhu chechipiri chebasa - rinobudirira rinobvisa chikamu chikamu chenhamba chero ipi zvayo, zvichisiya chete chikamu chechidimbu sechisara.