Idatha ye-Truncate ku-Excel nama-Google Spreadsheets

Ngokuvamile, ukuthatha i-truncate kusho ukusinciphisa into ngokuyinqamula ngokushesha - njengamagatsha aqoqwe emthini.Kuzinhlelo zespredishithi ezifana ne-Excel ne-Google Spreadsheets, kokubili inombolo kanye nedatha yombhalo inqunywe. Izizathu zokwenza kanjalo zihlanganisa:

Ukuqhaqhazela ngokumelene ne-Truncation

Ngenkathi kokubili ukusebenza kuhilela ukunciphisa ubude bezinombolo, lezi zimbalwa ezihlukile kulolo daba zingashintsha ukubaluleka kwedijithali yokugcina ngokulandela imithetho evamile yezinombolo zokuqoqa, ngenkathi i-truncation ingabikho ukuzungeza kungakhathaliseki ukuthi idijithali yokugcina iyini.

I-Pi

Isibonelo esivamile kakhulu senombolo egoqa futhi / noma esinqunyiwe yisikhathi esiphezulu seMbalo. Njengoba i-Pi iyinombolo engacabangi (ayiqedi noma iphinda), uma ibhalwe phansi ifomu lesimingcele, iyaqhubeka kuze kube phakade. Noma kunjalo, ukubhala inombolo engapheliyo akuyona into esebenzayo ngakho-ke inani lePi linganqunywa noma linqunywe njengoba kudingeka.

Abantu abaningi, uma bebuzwa inani lePi, nokho, banikeza impendulo ka-3.14 - lowo owaziwa emklasini wezibalo. Ku-Excel noma ku-Google Spreadsheets, leli xabiso lingakhiqizwa ngokusebenzisa umsebenzi we-TRUNC - njengoba kuboniswe emgqeni wesibili kwesibonelo esithombeni esingenhla.

Iqoqa imininingwane yedatha ku-Excel nama-Google Spreadsheets

Njengoba kukhonjisiwe, enye indlela yokudonsa idatha ku-Excel ne-Google Spreadsheets isebenzisa umsebenzi we- TRUNC . Lapho inombolo ithola khona inqunywa inani le- Num_digits ingxabano (ifushane ngenani lamadijithi). Isibonelo, esitokisini B2 inani le-Pi liye lahliswa inani layo elijwayelekile lika-3.14 ngokubeka inani lama- Num_digits kuya ku-3

Enye indlela yokwenza izinombolo eziqondile zibe yizinombolo yi- INT umsebenzi u-INT uhlale ujikeleza izinombolo kuze kube yizinombolo, okufana nezinombolo zokuqoqa izinombolo - njengoba kuboniswe emigqeni yesithathu nesine sibonelo.

Inzuzo yokusebenzisa umsebenzi we-INT wukuthi asikho isidingo sokucacisa inani lamadijithi njengoba umsebenzi njalo ususa wonke amanani we-decimal.

Ukunquma idatha yombhalo ku-Excel ne-Google Spreadsheets

Ngaphandle kwezinombolo ezihamba phambili, kungenzeka futhi ukuba nedatha yombhalo wedatha. Isiqunto lapho ukuqoqa idatha yombhalo kuncike esimweni.

Endabeni yokungenisa idatha, ingxenye kuphela yedatha ingase ihambisane noma, njengoba kukhulunywe ngenhla, kungase kube nomkhawulo kunani lezinhlamvu ezingangena ensimini.

Njengoba kuboniswe emigqeni emihlanu nesithupha yesithombe ngenhla, idatha yombhalo efaka izinhlamvu ezingadingeki noma zokulahla isetshenziswe ngokusebenzisa imisebenzi ye- LEFT ne- RIGHT .

Iphutha lezintambo

Iphutha le-truncation liphutha elibangelwa ukusebenzisa inombolo encane ekubalwa. Kuye ngenani lamadijithi abathintekayo, ukuze kubalwa izibalo ezibandakanya okungenzeka ukuthi akubalulekile.

Endabeni yokwenza ucwaningo lwekhompuyutha olubandakanya idatha nenani elikhulu lezindawo zedesimali iphutha lingabonakala libalulekile.

Ubeka isibonelo sabayisikhombisa nesishiyagalombili ukukhombisa umehluko wemiphumela uma ukwandisa inombolo enesiqu esinqunyiwe futhi engekho emithathu.