Ntchito ya TRUNC ndi imodzi mwa gulu la Excel lomwe likugwirizanitsa ntchito ngakhale likhoza kapena silikuzungulira nambala yodziwika.
Monga momwe dzina lake limasonyezera, ilo lingagwiritsidwe ntchito kuwombera kapena kufupikitsa chiwerengero chachindunji ku chiwerengero cha malo a decimal popanda kuzungulira chiwerengero chotsalira kapena nambala yonse.
Makhalidwe Abwino Kuti Akhazikitse Mitengo Yapamwamba
Ntchitoyi ndi nambala zokhazokha pamene Num_digits mkangano ndiwopindulitsa - mizera 7 mpaka 9 pamwamba.
Muzochitika izi, ntchitoyo imachotsa zonse zamtengo wapatali ndipo, malingana ndi mtengo wa Num_digits , ikuzungulira nambala mpaka mawerengero ambiri.
Mwachitsanzo, pamene Num_digits ali:
- Mofanana ndi -1, chiwerengerocho chaphatikizidwa ku mtengo wapatali wa 10 - mzere seveni;
- Mofanana ndi -10, chiwerengerocho chaphatikizidwa ku mtengo wapatali wa 100 - mzere eyiti;
- Mofanana ndi -100, chiwerengerocho chaphatikizidwa ku mtengo wapatali wa 1,000 - mzere waini.
Syntax ndi Ntchito Zogwira Ntchito
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa.
Chidule cha ntchito ya TRUNC ndi:
= TRUNC (Namba, Num_digits)
Chiwerengero - mtengo wopitilizidwa. Mtsutso uwu ukhoza kukhala:
- Deta lenileni kuti ikhale truncated - mzere awiri ndi atatu pamwambapa;
- Zotsatira za mzere - mzere wachitatu pamwambapa pamene TRUNC imagwiritsidwa ntchito kuchepetsera phindu lobwezeredwa ndi PI ntchito.
- Selo lofotokozera malo a deta mu worksheet - mzere wa anayi mpaka asanu ndi anayi pamwambapa.
- Bukuli lingatanthauzenso selo lokhala ndi phindu lobwezeredwa ndi ndondomeko - mtengo mu selo A4 umapangidwa ndi PI ntchito.
Num_digits (Mwachidziwikire): Chiwerengero cha malo apamwamba omwe angatsalidwe ndi ntchitoyo.
- ngati Num_digits yasiya mtengo wosasintha wa zero wagwiritsidwa ntchito pazitsutsano izi ndipo malo onse osungidwa amachotsedwa ndipo mtengo wosakwanira wokwanira ukubwezeredwa ndi ntchito - mzere wachisanu pamwambapa.
Chitsanzo cha ntchito ya TRUNC: Makhalidwe Okhazikitsa Kuyika Malo Amtengo Wapatali
Chitsanzo ichi chikuphatikizapo njira zomwe zimagwiritsidwa ntchito kulowa TRUNC ntchito mu selo B4 mu chithunzi pamwambapa kuti muyang'ane mtengo wa masamu Pi mu selo A4 mpaka malo awiri.
Zosankha zolowera polojekitiyi zikuphatikizapo kujambula pamanja pa ntchito yonse = TRUNC (A4,2) , kapena kugwiritsa ntchito bokosi lazokambirana - monga momwe tafotokozera pansipa.
Kulowa ntchito ya TRUNC
- Dinani pa selo B4 kuti mupange selo yogwira ntchito .
- Dinani pa Fomu tab ya menyu yowonjezera.
- Sankhani Math & Trig kuchokera ku riboni kuti mutsegule ntchito yolemba pansi.
- Dinani pa TRUNC mndandanda kuti mubweretse bokosi lazokambirana.
- Mu bokosi la bokosi, dinani pa Nambala.
- Dinani pa selo A4 mu tsamba lothandizira kuti mulowetse selololo mu bokosi la dialog.
- Mu bokosi la bokosi, dinani pa Num_digit mzere.
- Lembani " 2 " (palibe ndemanga) pamzerewu kuti muchepetse phindu la Pi ku malo awiri osungirako.
- Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi.
- Yankho 3.14 liyenera kupezeka mu selo B4.
- Mukasindikiza pa selo B4 lathunthu = TRUNC (A4,2) ikuwoneka mu barra ya fomula pamwamba pa tsamba.
Kugwiritsa ntchito Nambala Yoyendetsedwa mu Kuwerengera
Monga ntchito zina zozungulira, ntchito ya TRUNC yeniyeni imasintha deta yanu pazomwe mukuchita ndipo izi zimakhudza zotsatira za mawerengedwe omwe amagwiritsira ntchito miyezo ya truncated.
Pali, pambali ina, zosankha zojambula mu Excel zomwe zimakulolani kusintha chiwerengero cha malo osungidwa omwe akuwonetsedwa ndi deta yanu osasintha manambala okha.
Kupanga kusintha kwa mapangidwe kwa deta sikukhala ndi zotsatira pa mawerengedwe.