Nenzira yakawanda, kuti truncate zvinoreva kupfupisa chinhu kuburikidza nekuchibvisa pakarepo - zvakadai sematavi matatu akatarisana pamuti. Mipurogiramu yepadheseti yakadai seExcel neGoogle Spreadsheets, zvose nhamba uye nedhidhiyo deta zvakatorwa. Zvikonzero zvekuita izvi zvinosanganisira:
- zvichiita kuti zvive nyore kunzwisisa deta - zvakadai sokuderedza nhamba yedzimba dzepamusoro dziripo munguva yakareba;
- kuita zvinhu zvakaenzana - zvakadai sekudzivirira urefu hwemashoko dhesi iyo inogona kupinda mundima yedata.
Rounding vs. Truncation
Kunyange zvazvo maitiro ose ekubatanidza kuvharidza urefu hwemajeri, izvo zviviri zvakasiyana mumakwikwi aya zvinogona kuchinja kukosha kwemajita ekupedzisira zvichienderana nemitemo yepamusoro yekukomberedza nhamba, nepo truncation isingatauri kupoteredza pasinei nokuti iyo inopedzisira yani.
Pi
Muenzaniso wakajairika wehuwandu hunotenderedzwa uye / kana hutatu huri chiitiko chemasvomhu Pi. Sezvo Pi iri nhamba isinganzwisisiki (haina kugumisa kana kudzokorora), kana yakanyorwa mumutambo wedzinza, inoenderera mberi nokusingaperi. Zvisinei, kunyora nhamba isingagumi haisi yakakosha saka kukosha kwePi kunogona kutorwa kana kupoteredzwa sezvinodiwa.
Vanhu vazhinji, kana vakabvunzwa kukosha kwePi, zvakadaro, kupa mhinduro ye 3.14 - iyo yakadzidza mumatunhu echikoro. MuExcel kana Google Spreadsheets, kukosha uku kunogona kubudiswa uchishandisa basa re TRUNC - sezvinoratidzwa mumutsara wechipiri wemuenzaniso mumufananidzo wepamusoro.
Kuchengetedza Numerical Data mu Excel neGoogle Spreadsheets
Sezvambotaurwa, imwe nzira yokutora data mu Excel uye Google Spreadsheets iri kushandisa TRUNC basa. Pano nhamba iyo inotora zvigadziriswa nehuwandu hweNig_digits argument (shoma kuwanda kwenhamba). Semuenzaniso, muchitokisi B2 kukosha kwePi kwakatorwa kune iyo inowanikwa kukosha kwe 3.14 nekuisa kukosha kweMami_digits kusvika ku3
Imwe nzira yekutora nhamba yakanaka kune dzose ndeye INT function INT nguva dzose inotenderera nhamba kusvika pasi, iyo yakafanana nhamba dzekutora kusvika kune dzose - sezvinoratidzwa mumitsara mitatu nemana yemuenzaniso.
Kubudirira kwekushandisa INT inoshanda ndeyekuti hapana chikonzero chekutsanangura nhamba yemajita sezvo basa racho rinobvisa zvose zvinotarisirwa.
Kutora Zvinyorwa Zvinyorwa Data mu Excel neGoogle Spreadsheets
Mukuwedzera kune nhamba dzomunharaunda, zvinogonawo kutora manyorerwe emashoko. Chisarudzo chekuti kunyoresa zvinyorwa zvinyorwa kunoenderana nemamiriro ezvinhu.
Munyaya yekutengeswa kwemashoko, chikamu bedzi che data chingave chakakosha kana, sezvataurwa pamusoro apa, panogona kuva nemuganhu pane nhamba yevanhu vanogona kupinda mumunda.
Sezvinoratidzwa mumitsara mitanhatu nematanhatu yemufananidzo uri pamusoro, kunyora deta iyo inosanganisira zvisingadadi kana kuti zvimedu zvakagadziridzwa uchishandisa basa re LEFT uye RIGHT .
Truncation Error
Chikanganiso cheruncation iko kukanganisa kunokonzerwa nekushandisa nhamba yakatorwa mukuverenga. Zvichienderana nehuwandu hwemajairo akabatanidzwa, kuti zviverengero zvinyorwa zvinosanganisira zvingave zvisingakoshi.
Munyaya yekombiyuta kuongororwa inosanganisira data nenhamba yakawanda yenzvimbo dzepamusoro kukanganisa kunogona kunge kwakakosha.
Mireza manomwe nemasere emuenzaniso anoratidza misiyano yakasiyana kana ichiwedzera nhamba isina kutorwa ne100.