Power Query
Search…
published
Introduction
Accessing Data
Action
Binary
Binary Formats
Combiner
Comparer
Cube
Date
Date Time
Date Time Zone
Diagnostics
Duration
Error
Expression
Function
Lines
List
Logical
Metadata
Number
Byte.From
Currency.From
Decimal.From
Double.From
Int16.From
Int32.From
Int64.From
Int8.From
Number.Abs
Number.Acos
Number.Asin
Number.Atan
Number.Atan2
Number.BitwiseAnd
Number.BitwiseNot
Number.BitwiseOr
Number.BitwiseShiftLeft
Number.BitwiseShiftRight
Number.BitwiseXor
Number.Combinations
Number.Cos
Number.Cosh
Number.Exp
Number.Factorial
Number.From
Number.FromText
Number.IntegerDivide
Number.IsEven
Number.IsNaN
Number.IsOdd
Number.Ln
Number.Log
Number.Log10
Number.Mod
Number.Permutations
Number.Power
Number.Random
Number.RandomBetween
Number.Round
Number.RoundAwayFromZero
Number.RoundDown
Number.RoundTowardZero
Number.RoundUp
Number.Sign
Number.Sin
Number.Sinh
Number.Sqrt
Number.Tan
Number.Tanh
Number.ToText
Percentage.From
Single.From
Record
Replacer
Splitter
Table
Text
Time
Type
Uri
Values
Powered By GitBook
Number.RoundAwayFromZero

Number.RoundAwayFromZero

Returns the result of rounding positive numbers up and negative numbers down. 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 based on the sign of the number. This function will round positive numbers up and negative numbers down. If digits is specified, number is rounded to the digits number of decimal digits.

Category

Number.Rounding

Examples

Round the number -1.2 away from zero.
Number.RoundAwayFromZero(-1.2)
-2
Round the number 1.2 away from zero.
Number.RoundAwayFromZero(1.2)
2
Round the number -1.234 to two decimal places away from zero.
Number.RoundAwayFromZero(-1.234, 2)
-1.24
Previous
Number.Round
Next
Number.RoundDown
Last modified 3yr ago
Copy link
On this page
Number.RoundAwayFromZero
Description
Category
Examples