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
Watch video The TRUNC (Truncate) Function | How to Chop Off Decimals in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel Tutorial 22 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,728 once and liked it 7 people.