Excel TRUNC Function

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

  1. Click on an empty cell (like F5 )
an empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select math and trig category

5. Select TRUNC function

6. Then select ok

excel TRUNC function

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

How to use TRUNC function in excel

Examples of TRUNC function in Excel

Example 1:

How to use TRUNC function in excel

You can see examples of TRUNC function below:

Examples of TRUNC function in Excel
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?

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?

It returns a number.

How many arguments does TRUNC function have?

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?

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

Errors in TRUNC function

TRUNC related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *