=TRUNC(number, [num_digits])One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward.
Need more than a single TRUNC formula? Try our free AI for Excel — it reads your entire spreadsheet, answers questions in plain English, and builds charts and analysis in the same chat.
number:
The numeric value that you want to truncate. This can be a number, a cell reference, or a formula that returns a number.
num_digits:
The number of digits to which you want to truncate the number. If omitted, it defaults to 0, which means the number will be truncated to an integer.
The TRUNC function in Excel is a useful tool that allows you to truncate a number to a specified number of decimal places. It effectively removes the fractional part of a number without rounding, making it easier to work with whole numbers or to limit the precision of numerical data.
In simpler terms, the TRUNC function helps you simplify numbers by cutting off the decimal portion, which can be particularly useful in financial calculations or when you need to present data in a more digestible format.
Imagine you are working on a financial report for a project, and you have the following data in an Excel spreadsheet:
| Item | Cost |
|---|---|
| Project A | 123.456 |
| Project B | 78.910 |
| Project C | 45.6789 |
| Project D | 12.34567 |
You want to truncate the costs to two decimal places for a cleaner presentation.
To truncate the costs to two decimal places, you would use the TRUNC formula as follows:
=TRUNC(B2, 2)When you apply the formula to each cost, it truncates the values as follows:
| Item | Original Cost | Truncated Cost |
|---|---|---|
| Project A | 123.456 | 123.45 |
| Project B | 78.910 | 78.91 |
| Project C | 45.6789 | 45.67 |
| Project D | 12.34567 | 12.34 |
Here, the costs are truncated to two decimal places without rounding.
The TRUNC function is particularly useful when you need to present numerical data in a specific format without altering the underlying value through rounding. It allows you to maintain consistency in your data presentation, especially in financial reports or when preparing data for analysis.
Understanding how to use the TRUNC function can significantly enhance your data presentation capabilities in Excel, enabling you to present numerical data in a clear and concise manner.
Happy truncating!
You have a table where Column A contains product prices and Column B contains the quantity sold for each product. You can use the TRUNC function to round down the total revenue generated from each product to the nearest whole number. This helps in simplifying financial reports and ensuring that pricing strategies are based on whole number figures, making it easier to analyze overall sales performance without the distraction of decimal values.
Beyond the TRUNC function: Better Analyst is a full Excel AI that goes well past individual formulas. Upload any spreadsheet and ask questions in plain English — you'll get formulas, data analysis, and charts back in seconds. It's a free AI Excel assistant that works with any .xlsx, .xls, or .csv file — no plugins, no Microsoft 365 required.
Don't have a spreadsheet yet? Use our free AI spreadsheet generator to turn a text prompt into a downloadable Excel file — a full AI Excel sheet maker that builds headers, columns, and formulas from your description.
Create a free account for formula help, explanations, and spreadsheet analysis. Usage limits depend on your plan.
Browse our complete library of Excel formula guides
Compare your options
Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose.
AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.