Number.RoundUp
Rounds up to the next whole number, or to the next step of a decimal place: toward plus infinity.
Group: Number. Power Query M has it too: a query that uses it is written as in Power BI.
Syntax
Number.RoundUp(number as nullable number, optional digits as nullable number) as nullable number| Parameter | Type | Description |
|---|---|---|
number | nullable number | The number to work on; null gives null. |
digits | nullable number optional | How many decimal places to keep; 0, a whole number, when left out. |
Returns
nullable number. The smallest whole number (or number with that many decimals) that is not below the number; null for null.
Remarks
- Negative numbers go toward zero: -12.5 rounds up to -12.
Examples
Boxes needed for 125 items, 12 to a box
Number.RoundUp(125 / 12)11Up to the next cent
Number.RoundUp(19.981, 2)19.99A negative number
Number.RoundUp(-12.5)-12