
PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
CONTENTS
EXCEL FUNCTIONS-TRUNC
INTRODUCTION
Many times , while performing the mathematical calculations we can come across a particular situation when we need to remove the decimal part of the number and just keep the integer part of the number. For such situations, we have a function called TRUNC FUNCTION in Excel.
This function can further be applied as an outer function if we divide two numbers and the result is in decimals but we need only the integer part as the result.
We can use this function at many more places which we’ll discuss later on in examples.
In this article we’d see the syntax formula of the TRUNC FUNCTION and check how we can use it.
PURPOSE OF TRUNC FUNCTION IN EXCEL
TRUNC FUNCTION RETURNS THE INTEGER PART OF THE NUMBER.
If we have a number such as 56.64 , 56 is the integer part of the number whereas 64 is the decimal part of the number.
TRUNC FUNCTION removes the .64 and gives the 56 as the result.
PREREQUISITES TO LEARN AND
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Some information about the BINARY MATHEMATICS is an advantage for the use of such formulas.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
SYNTAX: TRUNC FUNCTION
The Syntax for the function is
=TRUNC( NUMBER, NUMBER OF PRECISION)
NUMBER is the number which we want to truncate.
NUMBER OF PRECISION[optional; default value is 0] is the number of digits we want to keep after the truncation.
EXAMPLE:TRUNC FUNCTION IN EXCEL
DATA SAMPLE
STEPS TO USE TRUNC
THREE sample cases have been discussed.
- Put the data in a cell.
- Put the formula in another cell as per the requirement discussed below.
- The result will appear.
The first argument contains the cell where
the number to be truncated is present. Second argument is given as 1 as
we want 1 decimal number.
The result reflects as 45.5 .
The first argument contains the cell where
the number to be truncated is present. Second argument is given as 0 as
we don’t want any decimal number.
The result reflects as -23 .
KNOWLEDGE BYTES
DIFFERENCE BETWEEN INT FUNCTION AND TRUNC FUNCTION
OTHER WAYS TO REACH THIS ARTICLE
WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL
YOU MAY LIKE
- HOW TO TROUBLESHOOT A FORMULA IN EXCEL?
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- how to insert table in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.