Dhammaanteen waxaanu samaynay xisaabo aasaasi ah oo aanu ku soo gaabin jirnay tiro badan oo jajab tobanle ah. Haddii Truncate iyo Wareegga^(Round) dhawaaqyada la yaqaan, markaa waad saxday. Maqaalkan, waxaan ku tusi doonaa sida aad u isticmaali karto shaqada TRUNC ee Microsoft Excel .

Kahor intaanan horay u socon, aan ku cadayno farqiga aasaasiga ah ee u dhexeeya Trunc iyo Round . Haddii aad leedahay nambar jajab tobanle ah 5.678, ka dib isticmaalka Trunc wuxuu dhalin doonaa 5.67. Marka la barbardhigo shaqada Wareegga^(Round) ah waxay keeni doontaa 5.68. U fiirso^(Notice) farqiga u dhexeeya? Shaqada Wareega^(Round) ayaa dooran doonta lambarka ugu sarreeya ee xiga, halka Trunc uu samayn doono ka soo horjeeda saxda ah.

Shaqada TRUNC

Trunc wuxuu u shaqeeyaa sida shaqo kasta oo kale ama qaacido kasta oo ku jira Excel^{(any other function or formula in Excel)} , kaas oo qaadata cabbirrada^(parameters) . Mid ka mid ah halbeegyada ayaa ah tirada^(number) loo baahan yahay in la gooyo, halka tan labaadna ay tahay tirada meelaha jajab tobanlaha ah.  ^{(number of decimal places.  )}Erayada fudud, shaqada TRUNC waxay u jartaa lambar ilaa tiro go'an oo jajab tobanle ah.

Ereyga shaqada Trunc: ^{(The syntax for Trunc function: )}

TRUNC(number, [num_digits])

Tirooyinka, cabbirka labaad waa ikhtiyaari, qiimaha caadiga ahina waa 0. Waxay la macno tahay haddii aadan gudbin ama qeexin qiime, waxay meesha ka saaraysaa dhammaan lambarrada, waxayna hoos u dhigi doontaa lambarka lambarka hoose ee kuugu dhow.

Xusuusnow^(Remember) , natiijadu waxay noqon doontaa liddi ku ah tirooyinka taban.

Sida loo isticmaalo shaqada TRUNC gudaha Excel

Habka ugu fiican ee lagu fahmi karo sida aad u isticmaali karto shaqada TRUNC ee Excel waa tusaale ahaan. Ku saabsan adeegsiga, way fududahay.

• Faylka Excel , dooro meesha aad rabto in lambarka la gooyay uu ka muuqdo.
• Laba jeer^(Double) dhagsii unugga si aad wax uga beddesho, qiimaha, ka dibna ku qor = Trunc (C4, 2). C4 waa unug ku jira excel oo sita tirooyin.
• Isla markaad ku qorto Trunc^(Trunc) , waxaad awoodi doontaa inaad doorato unug kasta oo ku yaal excel. Xir garabka, oo ku dhufo furaha Gelida^(Enter)
• Haddii aysan jirin khaladaad, waa inaad aragto qiimaha la gooyay.

Tirooyinka ayaa muhiim ah

Ma dabaqi kartid halbeeg isku mid ah jajab tobanle markaad isticmaalayso shaqada Trunc . Haddii uu jiro nambar leh hal nambar oo keliya ka dib jajab tobanle, oo aad lambarka 3 u isticmaashid halbeeg nambar, markaa ma saameyn doonto. Tusaalaha kore, 51.4 ayaa la mid ah sidii aan u dooranay halbeeg nambar sare ah halka uu jiro hal nambar oo kaliya kadib tobaneeyaha. Sidoo kale, xitaa haddii aad kordhiso qiimaha lambarku, ma muujin doono wax badan.

la xiriira: ^(Related:) Office Excel Talooyin iyo tabaha^{(Office Excel Tips and Tricks)}

Halkee ka isticmaali kartaa Shaqada Trunc^{(Trunc Function)} ?

Waxaa jira dhowr meelood oo aad isticmaali karto shaqadan.

• DateTime Stamp: Markaad haysato labada taariikhood, iyo wakhtiga unugga, waxaad isticmaali kartaa Trunc si aad uga saarto wakhtiga oo aad u soo saarto xogta.
• Ka saarida jajab tobanle^(Decimal) : Haddii aad rabto oo kaliya tirooyinka dhan oo aadan rabin tobanlaha, Trunc aan lahayn cabbirka digits .
• Gudbitaanka lambar taban oo ah halbeegga nambarada ayaa nambarka gooyn doona ka hor jajab tobanle. 28.99 wuxuu u goyn doonaa 20.
• Waxa kale oo ay la macno tahay in aad ku gooyn karto tirooyinka oo dhan foomkooda ugu hooseeya. Sagaal iyo labaatan ayaa loo jari doonaa labaatan.

Si ka duwan xisaabta dugsiga, Roundoff ma qabto labada hawlood. Shaqada Wareega^(Round) ayaa si sax ah uga soo horjeeda Trunc .

Akhri soo socda^{(Read next)} : Sida loo isticmaalo Excel si loo naqshadeeyo Qorshayaasha Dabaqaha ee fudud^{(How to use Excel to design simple Floor Plans)} .

How to use the TRUNC function in Microsoft Excel with Examples

We all hаve done some basic maths where we used to shorten a number with a lot оf decimal digit. If Truncate and Round of sounds familiar, then you got it right. In this post, we will show how you can use the TRUNC function in Microsoft Excel.

Before we go ahead, let’s brush on the fundamental difference between Trunc and Round. If you have a decimal number of 5.678, then using Trunc will result in 5.67. Compared to this Round function will result in 5.68. Notice the difference? The Round function will choose the next highest number, while Trunc will do the exact opposite.

The TRUNC Function

The Trunc function like any other function or formula in Excel, which takes parameters. One of the parameters is the number which needs to be truncated, while the second is to the number of decimal places.  In simple words, the TRUNC function truncates a number to a specified number of decimal places.

The syntax for Trunc function: 

TRUNC(number, [num_digits])

Digits, the second parameter is optional, and the default value is 0. It means if you do not pass or specify a value, it will remove all digits, and reduce the number to the closest lower number.

Remember, the result will be the opposite in the case of negative numbers.

How to use TRUNC function in Excel

The best way to understand how you can use the TRUNC function in Excel is by example. About applying it, it is tad simple.

• In the Excel file, choose where you want the truncated number to appear.
• Double click on the cell to edit, the value, and then type = Trunc(C4, 2). C4 is a cell on excel which carries a numerical.
• As soon as you type Trunc, you will be able to choose any cell on the excel. Close the bracket, and hit the Enter key
• If there are no errors, you should see the truncated value.

Digits matter

You cannot apply the same digits parameter to all decimals when using the Trunc function. If there is a number that has only one digit place after the decimal, and you use number 3 as a digit parameter, then it will not affect. In the above example, 51.4 remains the same as we chose a higher digit parameter while there is only one digit after the decimal. Similarly, even if you increase the value of the digit, it will not show more.

Related: Office Excel Tips and Tricks

Where can you use the Trunc Function?

There are a couple of places you can use this function.

• DateTime Stamp: When you have both dates, and time in a cell, you can use Trunc to remove time and extract the data.
• Removing Decimal: If you just want whole numbers and not the decimal, Trunc without Digits parameter.
• Passing a negative number as the digits parameter will truncate the number before the decimal. 28.99 will truncate to 20.
• It also means you can Trunc whole numbers to their lowest form. Twenty-nine will truncate to twenty.

Unlike school maths, Roundoff doesn’t perform both functions. The Round function does precisely the opposite of the Trunc.

Read next: How to use Excel to design simple Floor Plans.

Related posts

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Sida loogu isticmaalo shaqada MID iyo MIDB gudaha Microsoft Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo hagaajiyo Microsoft Excel marka aysan ka jawaabin

• Dib u eegis buug - Microsoft Excel 2010 Talaabo Talaabo ah

• Sida loo Copy and paste value without formula in Excel

• Sida loo joojiyo ama loo damiyo Wadaagista Buuga Shaqada ee Excel

• Sideen u hagaajin karaa Runtime Error 1004 gudaha Microsoft Excel?

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Sida Looga Badalo Saafka ama Saafka Excel [Tallaabo Talaabo]

• Microsoft Excel waxay sababtaa isticmaalka CPU sare marka uu socdo Windows 10

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo abuuro Gantt Charts gudaha Microsoft Excel

• Si degdeg ah ugu beddelo Xaashiyaha shaqada ee Excel

• Google Sheets vs Microsoft Excel - Waa maxay faraqa u dhexeeya?