# trunc function

#### jkindhappy

##### Board Regular
Hi,

Can some body tell me how to use "trunc" worksheet function in vba or is there any function available in vba equivalent to "trunc".

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

#### Mike Blackman

##### Well-known Member
Hi,

TRUNC cuts the decimal places of a number down the the requested number as such;

=TRUNC(156441.154454,3)

Returns;

156441.154

What are you trying to achieve?

#### jkindhappy

##### Board Regular
Hi Mike,
I was using "trunc" function to split a given number in to thousands, hundreds, rupees and paise using trunc function.

For Example to split 263.25

hundreds=TRUNC(TRUNC(263.25,0)/100,0)
rupees=TRUNC(263.25,0)-TRUNC(TRUNC(263.25,0)/100,0)*100
paise=(263.25-TRUNC(263.25,0))*100

Now to write a code in vba I require this TRUNC function.

Thank you.

#### Andrew Poulsom

##### MrExcel MVP
You can use the Int function if you don't want any decimals.

#### jkindhappy

##### Board Regular
Hi Andrew ,

Its working.

Thank you.

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,675
Messages
5,838,718
Members
430,566
Latest member
ChanchalSingh

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back