TRUNC Function in Excel: Syntax, Examples and Free Practice
TRUNC is an Excel Math & Trig function. Cuts off the decimal part of a number without rounding.
TRUNC syntax
Arguments
number: A number to use in the calculationnum_digits: How many decimal places to round to (optional)
When to use TRUNC
TRUNC is used in financial models and engineering-style calculations where precise numeric work is needed.
Practice TRUNC online, free
Open the live Excel-style spreadsheet and try TRUNC yourself. No Excel install or sign-up needed to start.
Practice TRUNC now →More Math & Trig functions
Frequently asked questions
What does the TRUNC function do in Excel?
Cuts off the decimal part of a number without rounding.
What is the syntax of TRUNC in Excel?
The syntax is =TRUNC(number, [num_digits]). number: A number to use in the calculation; num_digits: How many decimal places to round to (optional).
Where can I practice TRUNC online for free?
Open the free live spreadsheet on Cellgrids and try TRUNC yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Math and Trig functions · Excel case studies · Excel tutorials · Excel shortcuts