Iyo TRUNC basa ndeimwe yeboka raExcel rokutenderera kunyange zvazvo richigona kana risingave rakapoteredza nhamba yakatarwa.
Sezvo zita rayo rinoratidzira, rinogona kushandiswa kutora kana kupfupisa nhamba yekutsvaga kune imwe nhamba yezvimbo dzepamusoro kunze kwekukomberedza nhamba dzinosara kana nhamba yose.
Zvinyorwa zveTuncate kuti Zvigadzike Nhamba yeZakanaka Zvzvimbo
Basa rinongodzokorora nhamba apo Num_digits nharo inokosha kukosha - mitsara manomwe kusvika kune yakapfumbamwe pamusoro.
Mune zviitiko izvi, basa racho rinobvisa zvose zvinodiwa uye, zvichienderana nehuwandu hweM Num_digits , inotenderera nhamba kusvika kune iyo mawanda akawanda.
Semuenzaniso, kana Num_digits iri:
- Kuenzana kusvika ku1, nhamba yacho yakakomberedzwa kusvika kudivi rinoswedera pedyo 10-mutsara wechinomwe;
- Kuenzana ne -10, nhamba yacho yakapoteredzwa kusvika kunotarisirwa yakaderera ye100-mutsara masere;
- Kuenzana ne100, nhamba yacho yakapoteredzwa kusvika pfupi inosvika ye1000 - mutsara mapfumbamwe.
Iko Syntax yeMagetsi uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo.
Mutsara we TRUNC basa ndewokuti:
= TRUNC (Nhamba, Num_digits)
Nhamba - kukosha kunotorwa. Iyi nharo inogona kuva:
- Iyo chaiyo data inotarirwa - inosvika mbiri nehatu pamusoro;
- Migumisiro yechirongwa -mutsara mitatu pamusoro apa apo TRUNC inoshandiswa kupfupisa kukosha kunodzorerwa nePI basa.
- Sero rinotarisa kune nzvimbo yedhesi iri mubhuku rekushanda - mitsetse yechina kusvika kune yepfumbamwe pamusoro.
- Nhoroondo inogonawo kureva chekeri ine uwandu hunodzorerwa nesarudzo-kukosha muchitokisi A4 inogadzirwa nePI.
Num_digits (Zvichida): Nhamba yezvimbo dzepamusoro dzinofanira kusiyiwa nebasa racho.
- kana Num_digits yakasiya kusakosha kwenharo ye zero inoshandiswa pamusangano uyu uye nzvimbo dzose dzekupedzisira dzinodzingwa uye nhamba isina kukwana yenhare inodzoserwa nebasa - rutsara mashanu pamusoro apa.
TRUNC Kushanda Muenzaniso: Takatarisa Kuisa Nhamba Yezvimbo Dzakanaka
Muenzaniso uyu unoshandisa matanho anoshandiswa kupinda muTRUNC basa muchitokisi B4 mumufananidzo uri pamusoro apa kutarisa mathematical value Pi muchitokisi A4 kusvika mbiri nzvimbo dzepamusoro.
Sarudzo dzekupinda mubasa dzinosanganisira kunyora manyore mubasa rose = TRUNC (A4,2) , kana kushandisa sarudzo yebhokisi rebasa - sezvinotsanangurwa pasi apa.
Kupinda Basa re TRUNC
- Dzvanya pane sero B4 kuti riite sero rinoshanda .
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Math & Trig kubva kubhoni kuti uzarure basa rakaderera pasi.
- Dzvanya ku TRUNC mune urongwa kuti uunze bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, tora paNhamba yemurongo.
- Dzvanya pane sero A4 mune pepa rekushanda kuti uise iyo seferensi iri mubhokisi rebhokisi.
- Mubhokisi rebhokisi, tora pane Num_digit line.
- Tora " 2 " (hapana nhaurwa) pane iyi mutsara kuitira kuti uderedze kukosha kwePi kusvika kune dzimwe nzvimbo mbiri.
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi.
- Mhinduro 3.14 inofanira kuva iri muchitokisi B4.
- Paunenge uchinge uri pafoni B4 yakakwana basa = TRUNC (A4,2) inowanikwa mubhairi yepamusoro pane pepa pepaji.
Kushandisa Nhamba Yakagadzirirwa Mukuverenga
Kufanana nemamwe mabasa ekukomberedza, TRUNC basa chaiyo inoshandura dheta mubasa rako rekushanda uye kuda, saka inopikisa migumisiro yemhando ipi zvayo inoshandiswa inoshandisa mitemo yakatukwa.
Pane, kune rumwe rutivi, kuisa maitiro muExcel iyo inokubvumira kuti uchinje nhamba yedzimba dzepamusoro dzakaratidzwa nedheta rako usingashanduki nhamba pachavo pachavo.
Kuita maitiro ekugadzirisa kune deta hakusi kuitika pane kuverenga.