Ngokuqhelekileyo, ukuya kwi-truncate kuthetha ukunciphisa into ngokuyinqumla ngokukhawuleza - njengamasebe athathwe emthini. Kwiinkqubo zespredishithi ezifana ne-Excel kunye ne-Google Spreadsheets, zombini inombolo kunye nedatha yombhalo inqunyiwe. Izizathu zokwenza njalo ziquka:
- ukwenza kube lula ukuqonda idatha - njengokunciphisa inani leendawo zokugqibela ezikhoyo kwinani elide;
- ukwenza izinto zilungele - njengokunciphisa ubude beenkcukacha zetekethi ezingangeniswa kwintsimi yedatha.
Ukuqhawula ngokumalunga neTruncation
Nangona iimeko zombini zibandakanya ukunciphisa ubude beenombolo, ezi zimbini ezahlukeneyo kulolu hlobo luyakwazi ukutshintsha ixabiso ledijithi yokugqibela ngokusekelwe kwimigaqo eqhelekileyo yamanani okujikeleza, ngelixa i-truncation ibandakanya akukho ukujikeleza kungakhathaliseki ukuba idijithi yokugqibela yintoni.
Pi
Umzekelo oqhelekileyo wenani elijikelezayo kunye / okanye i-truncated yi-P yeemathematika rhoqo. Ekubeni uPi inombolo engalinganiyo (ayipheli okanye iphinda), xa ibhaliwe kwifom ye-decimal, iyaqhubeka ngonaphakade. Nangona kunjalo, ukubhala inombolo engapheliyo akusebenziyo ngoko ixabiso lePi lithengiswe okanye lijikelezwe njengoko lifunekayo.
Abantu abaninzi, xa bebuzwa ixabiso lePi, ke ke, banike impendulo ye-3.14-leyo efundwa kwizifundo zamatriki. Kwi-Excel okanye kwi-Google Spreadsheets, eli xabiso lingaveliswa ngokusebenzisa umsebenzi we-TRUNC - njengoko kuboniswe kumqolo omibini womzekelo kumfanekiso ongentla.
Ukugqithisa Iinkcukacha zeNombolo kwi-Excel kunye ne-Google Spreadsheets
Njengoko kubonisiwe, enye indlela yokutshintsha idatha kwi-Excel kunye ne-Google Spreadsheets isebenzisa umsebenzi we- TRUNC . Apho inani elithatha i-truncated linqunywe lixabiso le- Num_digits ingxabano (mfutshane kwinani lamadijithi). Ngokomzekelo, kwiseli yeB2 ixabiso lePi liye lahlulwa kwixabiso layo eliqhelekileyo lika-3.14 ngokubeka ixabiso le- Num_digits ukuya kwi-3
Enye inketho yokutsalwa kwamanani afanelekileyo kwii-integers ngumsebenzi we- int INT uhlala ujikeleza amanani ukuya kwii-integers, ezifana neenamba zokuhamba kunye neenombolo-njengoko kuboniswe kwimigangatho emithathu kunye nomine womzekelo.
Inzuzo yokusebenzisa umsebenzi we-INT kukuba akukho mfuneko yokucacisa inani leenombolo njengoko umsebenzi uhlala ususa zonke ixabiso lokugqibela.
Ukuqhawula idatha yeTekisi kwi-Excel ne-Google Spreadsheets
Ukongeza kwimiba yokuhamba, kunokwenzeka kwakhona ukuba idatha yombhalo. Isigqibo apho ukuqokelela idatha yombhalo kuxhomekeke kwimeko.
Kwimeko yokungenisa idatha, kuphela inxalenye yedata ingaba ifanelekileyo okanye, njengoko kuchazwe ngasentla, kunokuba nomda kwinani labalinganiswa abangenayo kwintsimi.
Njengoko kuboniswe kwimigangatho emihlanu neyesithandathu yomfanekiso ongentla, idatha yedatha equka abalinganiswa abangafunekiyo okanye udoti uye wathathwa ngokusetyenziswa kwemisebenzi ye- LEFT neYENKE .
Iphutha loTyuncation
Iphutha le-truncation liphutha elibangelwa ukusebenzisa inombolo elandelwayo ekubaleni. Ngokuxhomekeke kwinani lamadijithi abandakanyekayo, ukubala okubhaliweyo okubandakanya kungabalulekanga.
Kwimeko yeenkomfa zekhomputha ezibandakanya idatha kunye nenani elikhulu leendawo zokugqibela iphutha linokubaluleka kakhulu.
Imizekelo yesibhozo kunye nesibhozo mzekelo ibonisa iziphumo ezingafaniyo xa kuthengisa inani elincinciweyo nelingenakuthathwe ngamanani angama-100.