ROUNDUP
ROUNDUP(number, [digits])
Rounds a number away from zero, such as the whole weeks a task still needs. Away from zero means negative numbers go further below zero: -2.1 becomes -3. It rounds numbers only, so a duration is turned into days or hours first with INDAYS or INHOURS.
Arguments
| Argument | What to give it |
|---|---|
| number | A number. A blank gives a blank. |
| digits | Optional, 0 when left out. The decimal places to keep; a negative count rounds to tens, hundreds and so on. |
Examples
Formula=ROUNDUP(INDAYS([Remaining duration]) / 5, 0)
The whole five-day weeks the task still needs: any part of a week counts as one.
Formula on assignments=ROUNDUP([Budgeted units] / 8, 0)
On an assignment: the eight-hour shifts its planned hours need.
Reach for something else when
Common questions
What does "ROUNDUP rounds numbers; for a duration use ROUNDUP(INDAYS(…))" mean?
A duration has to be counted in days or hours before it can be rounded: use INDAYS or INHOURS.
The editor refuses this=ROUNDUP([Duration], 0)