Numbers function
ROUNDUP
Round away from zero.
Purpose
Round away from zero whatever the digits say
Use it when
A figure always has to go up to the next step and never down, like days charged or units that can't be split.
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.