The RoundUp function rounds a number to a specific number of decimal places, always to the nearest higher number. The round is still up regardless of the last digit. For example, RoundUp(3.14159,4)
will return 1.1416 and RoundUp(3.14159,2)
will return 3.15.
Limitations
- Convert multi-column tables before being able to use the RoundUp function.
- You can also use RoundDown for the opposite effect or Round for rounding based on the “Half Round-Up” rule (>=5 rounds up otherwise rounds down)
Recommendations:
- You can round an entire table (single column). The RoundUp function will return a new table with the rounded values.
- Only use rounding when you want to present a lot of information in a compact view. For calculations ensure you’re using the original values.
- You can perform arithmetic operations within the function. An example could be
RoundUp((3.14159/4),2)
that returns 0.79. - Arithmetic operations can contain variables but, if the value is not a number, the result will be empty and not an error, so be careful when setting the variables.
- Use any of the round functions (Round, RoundDown or RoundUp) instead of Text when displaying the information. You can get the same result as above just by using,
Text((3.14159/4),"#,##0.00")
but you’d be losing clarity in the formula and not in control in the rounding direction. Use only if you want a strict display of the result like keeping the right-hand zeros, for example.
Localization
- Please note that formulas may have localization-based differences. For example, you should write
RoundUp("3.14",2)
with “,” separating each of the arguments, but if your localization is Portugal, you should use “;” instead.
Sources:
Round, RoundDown, and RoundUp functions in Power Apps
Back to the PowerApps Function Reference
Featured Image by Jake Hills on Unsplash