← Back to Number functions

Number.RoundAwayFromZero

This function returns the rounded result of a number based on its sign. Positive numbers are rounded up, while negative numbers are rounded down. If a specific number of decimal digits is specified, t...

Syntax

Number.RoundAwayFromZero(number as nullable number, optional digits as nullable number) as nullable number

About

This function returns the rounded result of a number based on its sign. Positive numbers are rounded up, while negative numbers are rounded down. If a specific number of decimal digits is specified, the number will be rounded to that amount.

Explanation

Example 1 - Technical Tone: Proceed to round the number -1.2 away from zero. - Simple English: Round off the number -1.2 in the direction away from zero. - Technical Tone: Usage of Power Query MNumber.RoundAwayFromZero(-1.2) will yield an output of -2. Example 2 - Technical Tone: Proceed to round the number 1.2 away from zero. - Simple English: Round off the number 1.2 in the direction away from zero. - Technical Tone: Usage of Power Query MNumber.RoundAwayFromZero(1.2) will result in an output of 2. Example 3 - Technical Tone: Proceed to round the number -1.234 to two decimal places away from zero. - Simple English: Round off the number -1.234 to two decimal places in the direction away from zero. - Technical Tone: Usage of Power Query MNumber.RoundAwayFromZero(-1.234, 2) will generate an output of -1.24.