Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
TRUNC
TRUNC removes the fractional part of a number, keeping only as many decimal places as specified (default 0). Unlike INT, it always truncates toward zero, so TRUNC(-2.9) = -2. Use it to strip cents from a dollar amount or to extract the integer part of any number.
Excel
=TRUNC(A2,2)Google Sheets
=TRUNC(A2,2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Amount | Truncated |
| 12.3789 | |
| 5.999 | |
| 100.1 | |
| 0.555 |
=TRUNC(A2,2)→12.37
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1A2 is the number to truncate (e.g. 12.3789).
- 22 is the number of decimal places to keep — digits beyond this are dropped, not rounded.
- 3TRUNC(12.3789,2) returns 12.37, not 12.38.