The TRUNC (or truncate) function is a handy way to chop off decimal places. This can be really useful when you want to clean up numbers and make them easier to work with. Let's take a look at how the truncate function works, and some examples of how to use it!

Learn More:- https://www.exceltutorial.net/

🧑‍🏫 Round Functions and Formulas Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimUVHkfM00wH0UjScw_A8J33

Lets see and understand the syntax of TRUNC Function in excel;

TRUNC(number, [num_digits])

The truncate function takes two arguments. The first is the number that you want to truncate and the second is the number of decimal places that you want to truncate to. So, for example, if you wanted to truncate 12.34567 to three decimal places, you would use the following formula:

=TRUNC(12.34567,0)

This would give you the result 12.000.

Table of Contents;

00:00 Introduction

00:30 TRUNC Function in Excel

05:50 Conclusion

Other Playlists:-

Financial Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimU1umiFNnQrVugsq_TJ6LDD

Cell References in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVC65nzr2BebSN9kPSdK6qH

Logical Functions in Excel :- https://youtube.com/playlist?list=PLhvn6aQRdimWBCKHNrLEqubXDMaHeINU1

Count and Sum Functions in Excel - https://youtube.com/playlist?list=PLhvn6aQRdimVHQA5zqrJ6XG6e5jP5hyQN

Learn Data Validation In Hindi: https://youtube.com/playlist?list=PLhvn6aQRdimXirM12gw1eijuiMYta-Oqf

Learn Excel Tutorials Online:- https://www.youtube.com/playlist?list=PLhvn6aQRdimWKL2jOmJxQBEBTeIzmx-zW

Excel Analysis Tutorial: https://youtube.com/playlist?list=PLhvn6aQRdimUhgO4q3gJWiz4QrbSVGmIz

🧑‍🏫 Statistical Functions Playlist:- https://youtube.com/playlist?list=PLhvn6aQRdimWkjAu5tBtC37DayKJ_mWg1 ... https://www.youtube.com/watch?v=iXij4sYVI9E