Ayyukan TRUNC yana ɗaya daga cikin ƙungiyar Excel na ayyuka masu tasowa ko da yake yana iya ko ba a zagaye da lambar da aka gano ba.
Kamar yadda sunansa ya nuna, za'a iya amfani da shi don truncate ko rage gajerun lambar da aka saita a wurare masu yawa ba tare da yin la'akari da lambobin da suka rage ba ko lambar yawan.
Truncate Ƙididdiga zuwa Set Set Number of Dimits Places
Ayyukan kawai sune lambobi ne lokacin da hujjar Num_digits ta zama mummunan darajar - layuka bakwai zuwa tara a sama.
A cikin waɗannan lokuta, aikin yana kawar da duk ƙimar adadi da kuma, dangane da ƙimar Num_digits , yana ƙidayar lambar zuwa wannan lambar da yawa.
Alal misali, idan Num_digits shine:
- Daidaita zuwa -1, lambar ta ƙaddara zuwa mafi kusanci mafi kusa na 10 - jere bakwai;
- Daidaita zuwa -10, lambar da aka ƙaddara zuwa ƙimar mafi kusa na 100 - jere takwas;
- Daidaita zuwa -100, lambar ta ƙaddara zuwa ƙimar mafiya kusan 1,000 - jere tara.
Ƙungiyar TRUNC Function da Arguments
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara.
Haɗin aikin TRUNC shine:
= TRUNC (Lamba, Lambobi)
Lambar - darajar da za a ƙaddara. Wannan hujja zata iya ƙunsar:
- Gaskiyar bayanan da za a ƙaddara - layuka biyu da uku a sama;
- Sakamakon dabarar - layi uku a sama inda aka amfani da TRUNC don rage girman da aikin PI ya dawo.
- Tsarin tantanin halitta game da wurin da aka sanya bayanai a cikin takardun aiki - ya tsara hudu zuwa tara a sama.
- Hakanan zai iya nunawa a cikin tantanin halitta wanda ya ƙunshi darajar da aka samo ta hanyar dabara - darajar tantanin halitta A4 ta samo shi ne ta hanyar PI.
Num_digits (Zabin): Yawan wuraren wurare masu yawa don barin aikin.
- idan An cire Num_digits wani nau'i na nau'i na sifilin da ake amfani dashi don wannan hujja kuma an cire dukkan wuraren adimalimita kuma an mayar da lambar adadin ba tare da kewaye ba ta wurin aiki - layi biyar a sama.
TRUNC Function Misali: Truncate zuwa Set Set Number of Dimmar Places
Wannan misali yana rufe matakan da ake amfani dashi don shigar da aikin TRUNC a cikin cell B4 a cikin hoton da ke sama don ƙaddamar da ƙimar lissafi Pi a cikin cell A4 zuwa wurare biyu na decimal.
Zaɓuɓɓuka don shigar da aikin sun haɗa da bugawa hannu a cikin aikin duka = TRUNC (A4,2) , ko yin amfani da akwatin maganganun - kamar yadda aka tsara a kasa.
Shigar da aikin TRUNC
- Danna kan tantanin halitta B4 don sa shi tantanin halitta mai aiki .
- Danna maɓallin Formulas na shafin rubutun .
- Zabi Math & Trig daga ribbon don buɗe jerin aikin da aka sauke.
- Danna kan TRUNC cikin jerin don kawo akwatin maganganu na aikin.
- A cikin akwatin maganganu, danna kan Lambar.
- Danna kan A4 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu.
- A cikin maganganun, danna kan Num_digit line.
- Rubuta " 2 " (babu zance) akan wannan layin don rage darajar Pi zuwa wurare guda biyu.
- Danna Ya yi don kammala aikin kuma rufe akwatin maganganu.
- Amsar 3.14 ya kamata a kasance a cell B4.
- Lokacin da ka danna kan tantanin B4 na cikakke = TRUNC (A4,2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
Amfani da Lambar Truncated a Daidai
Kamar sauran ayyuka masu tasowa, aikin TRUNC yana canza ainihin bayanai a cikin takardunku ɗinku kuma yana so, sabili da haka rinjayar sakamakon kowane lissafi da suke amfani da dabi'un truncated.
Akwai, a daya bangaren, zaɓuɓɓukan tsarawa a cikin Excel da ke ba ka damar canja yawan adadin ƙananan wurare da aka nuna ta bayananka ba tare da canza lambobin da kansu ba.
Yin gyaran canje-canje zuwa bayanai ba shi da tasiri akan lissafi.