*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.**

**1. 12.34 required no decimal number.**

**2. 45.56 requires 1 decimal number.**

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 .

**3. -23.21 requires no decimal number.**

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.