Truncate Bayanai a Excel da Shafukan Lissafin Google

Gaba ɗaya, don truncate yana nufin rage abin da ya rage ta hanyar yanke shi gaba ɗaya - irin su rassan da aka ƙaddamar a jikin itace. A cikin shirye-shiryen sassauki irin su Excel da Google Spreadsheets, lambar biyu da bayanan rubutu an ƙaddara. Dalili na yin haka sun hada da:

Zagaye vs. Truncation

Duk da yake ayyukan biyu yana haɗu da tsawon lambobi, waɗannan biyu sun bambanta a wannan zagaye na iya canja darajar lambar ƙarshe ta dogara da ka'idoji na al'ada don lambobi masu tasowa, yayin da truncation ba shi da wani zagaye ko da wane lambar karshe.

Pi

Misali na yau da kullum na lambar da take tasowa da kuma / ko truncated shi ne ƙwayar ilimin lissafi Pi. Tun da Pi yana da lamba marar kyau (ba ta ƙare ko maimaitawa), lokacin da aka rubuta shi a cikin nau'i-nau'i, shi ya ci gaba har abada. Duk da haka, rubutun lambar da ba ta ƙare ba amfani ba ne don haka adadin Pi yana ƙaddara ko ƙaddara idan an buƙata.

Mutane da yawa, idan suka tambayi Pi, duk da haka, ba da amsar 3.14 - wanda ya koya a cikin lissafin lissafi. A cikin Excel ko Shafukan Lissafin Google, wannan darajar za a iya samuwa ta yin amfani da aikin TRUNC - kamar yadda aka nuna a jere biyu na misalin a cikin hoton da ke sama.

Truncating Data Numeri a cikin Excel da kuma Google Lissafi

Kamar yadda aka ambata, wata hanya ta truncating bayanai a cikin Excel da Google Rubutun gaisu shine ta amfani da aikin TRUNC . Inda aka ƙayyade lambar ta ƙididdigin lamarin Num_digits (takaice don yawan lambobi). Alal misali, a cikin tantanin halitta B2 darajar Pi an ƙaddara shi zuwa ƙimar da ya dace na 3.14 ta hanyar saita lambobin Num_digits zuwa 3

Wani zaɓi don truncating lambobi masu mahimmanci zuwa mahaɗin shi ne aikin INT kullum yana zagaye lambobi zuwa mahaɗar lamba, wanda yake daidai da lambobi truncating zuwa lamba - kamar yadda aka nuna a layuka uku da hudu na misali.

Amfanin yin amfani da aikin INT shine cewa babu buƙatar saka adadin lambobi a matsayin aikin ko da yaushe yana kawar da duk dabi'un decimal.

Truncating Bayanan Rubutu a cikin Excel da Shafukan Lissafin Google

Bugu da ƙari, zuwa lambobi, suna yiwuwa a ƙaddara bayanan rubutu. Shawarwarin da za a iya ƙaddamar da bayanan rubutu ya dogara da halin da ake ciki.

A cikin yanayin da aka shigo da shi, kawai wani ɓangare na bayanai zai iya zama daidai ko, kamar yadda aka ambata a sama, ƙila za'a iya iyaka akan adadin haruffan da za a iya shiga cikin filin.

Kamar yadda aka nuna a cikin layuka biyar da shida na hoton da ke sama, bayanan rubutu da ya haɗa da abubuwan da ba'a so ko kayan sharaɗi an ƙaddara ta amfani da ayyukan LEFT da RIGHT .

Kuskuren Truncation

Kuskuren truncation shine kuskure da aka haifar ta amfani da lambar ƙaddara a lissafi. Dangane da adadin lambobin da suka shafi, don ƙididdigar lissafi wanda zai iya zama maras muhimmanci.

A game da ƙididdigar kwamfuta wanda ya haɗa da bayanai tare da yawan adadin ƙananan wurare kuskure ɗin zai iya zama mai mahimmanci.

Sifofin bakwai da takwas daga cikin misalai suna nuna sakamakon bambancin yayin da suke ninka lambar truncated da ba a ƙaddara ta 100 ba.