Numbers function
ROUNDUP
Round away from zero.
Purpose
Round away from zero whatever the digits say
Returns
The number rounded up to the places you asked for
Syntax
=ROUNDUP(number, [places])
| Argument | Required | What goes here |
|---|---|---|
number | Required | The figure to round, or the cell holding it. |
places | Optional | 2 for cents, 0 for whole pounds. None means 0. |
How to use ROUNDUP
ROUNDUP ignores what the next digit is and always rounds away from zero. 1.1 to nought places is 2.
It is the right answer whenever a part period counts as a whole one: months of ageing, days chargeable, boxes needed.
For a negative number, away from zero means further negative, so -1.1 becomes -2.
Examples
Every result below is worked out by the same evaluator that marks your answers, on the sheet shown here.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Invoice | Supplier | Status | Days overdue | Amount | Supplier | Terms (days) | |
| 2 | INV-8801 | Brightwell Paper | Overdue | 12 | 940 | Ashgrove Catering | 30 | |
| 3 | INV-8802 | Calder Utilities | Queried | 47 | 1180 | Brightwell Paper | 30 | |
| 4 | INV-8803 | Meridian Freight | Overdue | 63 | 2450 | Calder Utilities | 14 | |
| 5 | INV-8804 | Ashgrove Catering | On terms | 0 | 405 | Meridian Freight | 45 | |
| 6 | INV-8805 | Brightwell Paper | Overdue | 38 | 760 | Thornbury Print | 60 | |
| 7 | INV-8806 | Thornbury Print | Overdue | 91 | 1320 | |||
| 8 | INV-8807 | Meridian Freight | On terms | 0 | 580 | |||
| 9 | INV-8808 | Calder Utilities | Overdue | 24 | 215 |
| Formula | Result |
|---|---|
=ROUNDUP(D3/30,0)Forty-seven days is into a second month, so the answer is two months overdue. | 2 |
=ROUNDUP(E2/100,0)Nine hundred and forty pounds needs ten hundred-pound units to cover it. | 10 |
=ROUNDUP(D9/30,0)Twenty-four days is a part month, and a part month counts as one. | 1 |
Notes
- ROUNDUP on a figure that is already whole leaves it alone. It rounds up, not to the next one up.
Related
Practise ROUNDUP in Unit 18
A reference tells you what it does. A unit makes you use it.