ROUNDUP
Rounds a number up, away from zero.
Math & TrigonometryMath BasicsMost Used
What it does
Rounds a number up (away from zero) to a specified number of digits.
Syntax
ROUNDUP(number, num_digits)
Arguments
number(number) — Number to round.
Examples
Round up to 0 decimals
Round A2 up to a whole number.
FORMULA
=ROUNDUP(A2,0)
RESULT
4
SAMPLE DATA
| A | |
|---|---|
| 1 | Number |
| 2 | 3.14 |
| 3 | 2.01 |