Kawirikawiri, kuti truncate imatanthauza kufupikitsa chinthu mwa kuichotsa mwadzidzidzi - monga nthambi za truncated pamtengo.Mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets, nambala zonse ndi malemba ndi truncated. Zifukwa zochitira zimenezi zikuphatikizapo:
- kukhale kosavuta kumvetsa deta - monga kuchepetsa chiwerengero cha malo apamwamba omwe alipo kale;
- kupanga zinthu zoyenera - monga kuchepetsa kutalika kwa deta zomwe zingathe kulowa mu deta.
Kuzungulira motsutsana ndi Truncation
Pamene ntchito ziwirizi zikutanthauza kuchepetsa kutalika kwa manambala, zigawo ziwirizi zingasinthe kufunika kwa chiwerengero chomaliza pogwiritsa ntchito malamulo ovomerezeka owerengetsera manambala, pomwe thunthu silikuphatikizapo chiwerengero chomwe chiwerengerochi chili.
Pi
Chitsanzo chofala kwambiri cha nambala yomwe imakhala yozungulira ndi / kapena truncated ndi nthawi ya masamu Pi. Popeza Pi ndi nambala yopanda malire (siimathera kapena kubwereza), pamene inalembedwa mu mawonekedwe a decimal, ikupitirira kwamuyaya. Komabe, kulembera nambala yomwe siimatha sizothandiza kuti phindu la Pi likhale lopangidwa kapena lopangidwa ngati likufunikira.
Anthu ambiri, ngati afunsidwa kufunika kwa Pi, komabe, ayankhe yankho la 3.14 - lomwe adaphunzira m'kalasi la masamu. Mu Excel kapena Google Spreadsheets, mtengo uwu ukhoza kupangidwa pogwiritsa ntchito ntchito ya TRUNC - monga momwe tawonetsera mzere wachiwiri mu chitsanzochi pamwambapa.
Kutumizira Deta Zambiri pa Excel ndi Google Spreadsheets
Monga tanenera, njira imodzi yodulira deta ku Excel ndi Google Spreadsheets ikugwiritsa ntchito ntchito TRUNC . Kumene chiwerengerochi chimapangidwira ndi chiwerengero cha ndondomeko ya Num_digits (yochepa kwa chiwerengero cha ziwerengero). Mwachitsanzo, mu selo B2 kufunika kwa Pi kunayikidwira ku mtengo wake wa 3.14 poika mtengo wa Num_digits mpaka 3
Njira ina yokopera manambala abwino ku intela ndi INT int function INT nthawi zonse mawerengera mpaka ang'onoang'ono, omwe ndi ofanana ndi nambala yopita ku intekiti - monga momwe zikuwonetsera mzere ndime zitatu ndi zinai.
Ubwino wogwiritsira ntchito ntchito ya INT ndikuti palibe chifukwa chofotokozera chiwerengero cha ziwerengero monga ntchito nthawi zonse imachotsa zonse zamtengo wapatali.
Zosakaniza Zopangira Malemba mu Excel ndi Google Spreadsheets
Kuphatikiza pa manambala osakanikirana, ndizotheka kutumizira deta zamtundu. Chigamulo choyenera kulumikiza deta kumadalira momwe zinthu zilili.
Pankhani ya deta yochokera kunja, gawo limodzi la deta lingakhale lofunikira kapena, monga tafotokozera pamwambapa, pakhoza kukhala malire pa chiwerengero cha anthu omwe angalowe m'munda.
Monga momwe tawonetsera m'mizera zisanu ndi zisanu ndi chimodzi za chithunzi pamwambapa, deta yomwe imaphatikizapo zilembo zosafuna kapena zonyansa zagwiritsidwa ntchito pogwiritsa ntchito LEFT ndi RIGHT ntchito.
Zolakwa za Truncation
Cholakwika cha truncation ndi cholakwika chifukwa chogwiritsira ntchito chiwerengero cha truncated mu kuwerengera. Malinga ndi chiwerengero cha ziwerengero zomwe zikuphatikizidwa, kuwerengera komwe kulipo kungakhale kochepa.
Pankhani ya makompyuta ophatikizapo deta ndi malo ambiri osokoneza zolakwika zingakhale zofunikira kwambiri.
Lembera chitsanzo chachisanu ndi chiwiri ndi zisanu ndi zitatu (8) ndikuwonetsera zotsatira zosiyana poonjezera chiwerengero cha truncated ndi chosadulidwa ndi 100.