Umsebenzi we-TRUNC ungenye yeqembu lika-Excel lemisebenzi yokuqoqa noma ngabe kungenzeka noma angayizungeza inombolo ekhonjiwe.
Njengoba igama layo liphakamisa, lingasetshenziswa ukwehlisa noma ukunciphisa inombolo ekhonjiwe kwinamba ehleliwe yezindawo zedesimali ngaphandle kokugoqa amadijithi asele noma inombolo yonke.
Amanani ama-Truncate wokusetha Inani lezindawo ezidumile
Umsebenzi kuphela izinombolo zomjikelezo lapho ama- Num_digits ingxabano ayinani elibi - imigqa eyisikhombisa kuya kweyisishiyagalolunye ngenhla.
Kulezi zimo, lo msebenzi ususa wonke amanani we-decimal futhi, kuye ngokuthi inani lama- Num_digits , lizungeza inombolo phansi kwalezi zinombolo eziningi.
Isibonelo, uma ama- Num_digits engama :
- Kulingana no--1, inomboro ihlelwe phansi ekuthengeni okungenani kwe-10 - irowu lesikhombisa;
- Ukulingana kuya -10, inomboro ihlelwe phansi ekuthengeni inani eliseduze le-100 - irowu eyisishiyagalombili;
- Kulingana no--100, inani lihlehliselwe inani eliseduze le-1,000 - irowu lesishiyagalolunye.
I-syntax ye-Function ne-Arguments ye-TRUNC
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana.
I-syntax yomsebenzi we-TRUNC yilezi:
= TRUNC (Inombolo, Ama-Num_digits)
Inombolo - inani okufanele lihanjiswe. Le mpikiswano ingaqukatha:
- Idatha yangempela okufanele ibekwe eceleni - imigqa emibili nantathu ngenhla;
- Imiphumela ye -formula - irowu ezintathu ngenhla lapho i-TRUNC isetshenziselwa ukunciphisa inani elibuyiselwe umsebenzi we-PI.
- Ukubhekisela kweseli endaweni yedatha kushidi lokusebenza - imigqa emine kuya kweyisishiyagalolunye ngenhla.
- Ukubhekisela kungabuye kubhekisele esitokisini esinexabiso elibuyiselwe ifomula - inani eliseli cell A4 lenziwa ngumsebenzi we-PI.
Ama -_digits (Okokuzithandela): Inani lezindawo zedesimali okufanele zishiywe ngomsebenzi.
- uma i- Num_digits ingavumelekile inani elizenzakalelayo le-zero lisetshenziselwa le mpikiswano futhi zonke izindawo ezidumile zisusiwe futhi inani elingahlanganisiwe lenani elibuyiselwe libuyiselwa umsebenzi - irowu emihlanu ngenhla.
Isibonelo Sokusebenza kwe-TRUNC: Qinisekisa Ukusetha Inombolo Yezindawo Ezidumile
Lesi sibonelo sihlanganisa izinyathelo ezisetshenziselwa ukungena umsebenzi we-TRUNC esitokisini B4 esithombeni esingenhla ukuze unciphise inani lembalo Pi esitokisini A4 kuya ezindaweni ezimbili zedesimali.
Izinketho zokufaka lo msebenzi zifaka ukuthayipha ngesandla kuwo wonke umsebenzi = TRUNC (A4,2) , noma usebenzisa ibhokisi lengxoxo lomsebenzi - njengoba kuchazwe ngezansi.
Ukufaka umsebenzi we-TRUNC
- Chofoza kuseli B4 ukuze wenze iseli esebenzayo .
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha i- Math & Trig kusuka kubhoni ukuze uvule uhlu lwehla lokusebenza.
- Chofoza ku- TRUNC ohlwini ukuze ulethe ibhokisi lengxoxo lomsebenzi.
- Ebhokisini lengxoxo, chofoza kulayini lombhalo .
- Chofoza ku- cell A4 ekhasini lokusebenzela ukuze ufake leyo reference yocingo ebhokisini lengxoxo.
- Ebhokisini lengxoxo, chofoza kumugqa we- Num_digit.
- Thayipha i- " 2 " (ayikho izingcaphuno) kulo mzila ukuze unciphise inani le-Pi kuya ezindaweni ezimbili zesimanje.
- Chofoza OK ukuqedela umsebenzi bese uvala ibhokisi lengxoxo.
- Impendulo 3.14 kufanele ibe khona esitokisini B4.
- Uma uchofoza ku-cell B4 umsebenzi ophelele = TRUNC (A4,2) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Ukusebenzisa Inombolo Enqunyiwe Kuzibalo
Njengeminye imisebenzi yokujikeleza, umsebenzi we-TRUNC wangempela uguqulela idatha kushidi lakho lokusebenzela futhi, ngakho-ke kuyothinta imiphumela yanoma yikuphi ukubalwa okusebenzisa amanani athile.
Ngakolunye uhlangothi, kukhona okukhethwa kukho ukufometha ku-Excel okuvumela ukuthi ushintshe inombolo yezindawo zamadesimali eziboniswa idatha yakho ngaphandle kokushintsha izinombolo ngokwabo.
Ukwenza ushintsho lokufometha kwedatha alinamthelela kubalo.