How to Truncate Amounts Below ?
In this article, we’ll explain how to use Excel to truncate amounts below $1. For example, if you have amounts like “$1.20” or “$2.99,” you can round them down to the nearest whole dollar, effectively displaying “$1” or “$2.”
Truncating Amounts Below Using ROUNDDOWN
In Excel, you can use the ROUNDDOWN function to truncate amounts below $1. This function removes fractional values without rounding up. Here’s the formula:
=ROUNDDOWN(number, digits)
Example: Truncating Amounts Below
For example, if cell A1 contains “$1.20” and cell A2 contains “$2.99,” you can use the ROUNDDOWN function to truncate these values to the nearest whole dollar as follows:
| A | B | |
|---|---|---|
| 1 | 1.20 | =ROUNDDOWN(A1, 0) |
| 2 | 2.99 | =ROUNDDOWN(A2, 0) |
Steps
- Enter “1.20” in cell A1 and “2.99” in cell A2.
- In cell B1, type =ROUNDDOWN(A1, 0).
- Cell B1 will display “1”.
- In cell B2, type =ROUNDDOWN(A2, 0).
- Cell B2 will display “2”.
Results
Using this formula, cell B1 displays “$1,” and cell B2 displays “$2,” as fractional values below $1 are truncated.
Alternative Example: Rounding Down to Nearest 10 Cents
If you want to truncate amounts below 10 cents, adjust the digits in the ROUNDDOWN function to “1” as follows:
| A | B | |
|---|---|---|
| 1 | 1.29 | =ROUNDDOWN(A1, 1) |
| 2 | 2.45 | =ROUNDDOWN(A2, 1) |
Results
In this case, cell B1 will display “$1.2,” and cell B2 will display “$2.4,” as both values are rounded down to the nearest 10 cents.