Wednesday 9 September 2015

Excel Tips - Tip 25 (How to Truncated the Value )


Hello,

Hope my excel tips are helping you out.

Here is Today’s tip for you. Hope this help you.


What Does It Do ?

If ever we want to remove the decimals but don’t want to round the value, then we can use Truncate function.


How to use it ?

=TRUNC(Number To Truncate, Precision)

For example, please check the images.




Hope the Tip is found interesting to you and the same is clear.

Looking forward for a feedback.

If any of your friend is also interested for the said excel Tips , then asked them to fill the form by clicking on the below mentioned link:



If you have something that you want to share with the group, please write to excelms.tips@gmail.com


Thanks & Regards,

CA Mohit Bansal
Excel Enthusiast

+91-9045773456





No comments:

Post a Comment