## What is TRUNC function in Excel?

The **TRUNC** function is one of the math functions of Excel.

It **Truncates a number to an integer** by removing the decimal, or fractional, part of the number.

We can find this function in **Math & trig** category of insert function Tab.

## How to use TRUNC function in excel

- Click on
**an empty cell**(like F5 )

2. Click on **fx icon** (or press** shift+F3**)

3. In the **insert function tab **you will see all functions

4. Select **math and trig** category

5. Select **TRUNC** function

6. Then select **ok**

7. In the function arguments Tab you will see **TRUNC** function

8. Number section Is the** number you want to truncate**

9. Num_digits Is a number **specifying the precision of the truncation**, 0 (zero) if omitted

10. You will see **results **in the formula result section

## Examples of **TRUNC** function in Excel

**Example 1:**

**How to use TRUNC function in excel**

You can see examples of TRUNC function below:

**trunc**(A2,B2) ----->>>>answer is 123.45
**trunc**(A3,B3) ----->>>>answer is 123.4
**trunc**(A4,B4) ----->>>>answer is 123
**trunc**(A5,B5) ----->>>>answer is 120
**trunc**(A6,B6) ----->>>>answer is 100

## What is the purpose of **TRUNC** function?

**TRUNC**

It **Truncates a number to an integer** by removing the decimal, or fractional, part of the number.

## What is the Return value of **TRUNC** function?

**TRUNC**

It returns a number.

## How many arguments does **TRUNC** function have?

**TRUNC**

This function has just **2** Argument.

The **argument **of TRUNC function is **number**.

Number section Is the** number you want to truncate**.

Num_digits Is a number **specifying the precision of the truncation**, 0 (zero) if omitted.

The argument of TRUNC function is **required **and not optional.

```
TRUNC(number) = number
```

## Which version of excel supports **TRUNC** function?

**TRUNC**

This function is available for all excel **versions **(2003-2019)

## Errors in **TRUNC** function

**TRUNC**

## TRUNC** related functions :**

- INT function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- MROUND function
- CEILING function
- FLOOR function
- ODD function
- EVEN function