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?
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 :
- INT function
- ROUND function
- ROUNDDOWN function
- ROUNDUP function
- MROUND function
- CEILING function
- FLOOR function
- ODD function
- EVEN function