Power Query
published
Search
⌃K

Number.RoundUp

Number.RoundUp

Returns the next highest number. The number of digits can be specified.
function (optional number as nullable any, optional digits as nullable any) as nullable any

Description

Returns the result of rounding number down to the previous highest integer. If number is null, Number.RoundDown returns null. If digits is specified, number is rounded to the digits number of decimal digits.

Category

Number.Rounding

Examples

Round up 1.234 to integer.
Number.RoundUp(1.234)
2
Round up 1.999 to integer.
Number.RoundUp(1.999)
2
Round up 1.234 to two decimal places.
Number.RoundUp(1.234, 2)
1.24