Math
Rounding a price up
Definition
Rounding a price up away from zero means giving ROUNDUP the price and how many digits to keep.
Syntax
=ROUNDUP(number, num_digits)
Arguments
| Argument | Meaning |
|---|---|
number |
The cell or value to round up. |
num_digits |
The digit count. Positive keeps that many places after the decimal; 0 rounds up to a whole number. |
Worked example
A cafe lists drink prices in B2:B4 that must round up to one decimal place.
| A: Drink | B: Price |
|---|---|
| Tea | 12.31 |
| Coffee | 9.02 |
| Cocoa | 11.80 |
Formula: =ROUNDUP(B2,1)
Result: 12.4. The second decimal of 12.31 is not 0, so the price rounds up to 12.4.
Practice
Cell A2 holds 6.01. In B2, write a formula that rounds that price up to a whole number.
- In B2, write a ROUNDUP formula that rounds A2 up to 0 decimal places.
- B2 should show A2 rounded up to 0 decimal places.
Step 1 of 2
Enter =ROUNDUP(A2,0) in B2.
A2 is 6.01, so rounding up to 0 decimal places gives 7.
Formulas here use English function names, such as SUM, and a period as the decimal separator, in every language.
Loading the sheet…
B2 uses ROUNDUP.
B2 now shows 7.
The next lesson is Rounding a price down.
Related functions
ROUNDUP is the function that pushes the price up to the next value at that digit count.
Common mistake
Putting the digit count first, as in =ROUNDUP(1,B2): that rounds the number 1 instead of the price in B2.