Math
Rounding a price down
Definition
Rounding a price down toward zero means giving ROUNDDOWN the price and how many digits to keep.
Syntax
=ROUNDDOWN(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The cell or value to round down. |
num_digits |
The digit count. Positive keeps that many places after the decimal; 0 rounds down to a whole number. |
Worked example
A timber yard lists lengths in B2:B4 that must round down to one decimal place.
| A: Board | B: Length |
|---|---|
| Oak | 12.39 |
| Pine | 8.91 |
| Ash | 10.05 |
Formula: =ROUNDDOWN(B2,1)
Result: 12.3. The second decimal of 12.39 is dropped, so the length rounds down to 12.3.
Practice
Cell A2 holds 6.99. In B2, write a formula that rounds that price down to a whole number.
- In B2, write a ROUNDDOWN formula that rounds A2 down to 0 decimal places.
- B2 should show A2 rounded down to 0 decimal places.
Step 1 of 2
Enter =ROUNDDOWN(A2,0) in B2.
A2 is 6.99, so rounding down to 0 decimal places gives 6.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses ROUNDDOWN.
B2 now shows 6.
The next lesson is Joining cells into one list.
Related functions
ROUNDDOWN is the function that drops the price down to the value at that digit count.
Common mistake
Putting the digit count first, as in =ROUNDDOWN(1,B2): that rounds the number 1 instead of the length in B2.