The TRUNC (Truncate) Function | How to Chop Off Decimals in Excel
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:- • Round Functions & Formulas In Excel
============================================================
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 - • Financial Function in Excel
Cell References in Excel - • Cell References In Excel
Logical Functions in Excel :- • Logical Functions
Count and Sum Functions in Excel - • Count And Sum Function
Learn Data Validation In Hindi: • Learn Data Validation In Hindi
Learn Excel Tutorials Online:- • Learn Excel Tutorials In Hindi
Excel Analysis Tutorial: • Excel Analysis Tutorials
🧑🏫 Statistical Functions Playlist:- • Statistical Formulas in Excel
Смотрите видео The TRUNC (Truncate) Function | How to Chop Off Decimals in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel Tutorial 22 Июнь 2022, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,728 раз и оно понравилось 7 людям.