How to Convert a Number to Rounding UP or Down in Power Automate?

Do you want to convert a number to rounding up or down in Power Automate? In this Power Automate tutorial, we will see how to convert a number to rounding up or rounding down value in Power Automate.

Here, we will cover the topics below:

• How to convert a number to rounding up in Power Automate
• How to convert a number to rounding down in Power Automate.

How to convert a number to rounding up in Power Automate

Here, we will see how to round up a number in Power Automate.

Let’s first understand what the rounding-up number is in Power Automate. The process of increasing a number to the nearest higher value according to a stated rule or convention is known as rounding up.

The general rule for rounding up is that if the digit being rounded is 5 or greater; we round up to the next higher number.

For example:

Rounding to the nearest whole number

• Rounding up the 3.6-> 4

Rounding to a specific decimal place, like tenths

• Rounding up to 3.62 -> 3.7

Now, let’s see how we can round up a number in Power Automate.

Example 1:

For example, we have a number like 45.863, but we want to format this number to round up i.e., 46. To implement this, follow these steps:

1. Open Power Automate Cloud, click on Create, and select Instant Cloud Flow.

2. Then, provide the flow name and select the “Manually triggered a flow” action. Then click on Create.

Now, you can see the “Manually trigger a flow” action is added to the flow page.

3. Next, we will initialize a variable and provide a float number; for this, click on +New step -> select Initialize variable action. Then provide the below information:

• Name: Provide the name of the variable.
• Type: Select the type as float
• Value: Then provide the value to convert.

4. Now, we will round up the number; for this, click on the +New step -> select Compose action. Then provide the below information:

• Inputs: Provide the below expression

formatNumber(variables('Num'),'#0')

or

formatNumber(variables('Num'), 'N0')

5. Run the flow manually, and you can see the result: the number is rounded up.

Example 2:

For example, we have a number like 45.863, but we want to format this number to round up i.e., 46.9.

To do this in the above flow, we need to change the expression in the compose action, so provide the below expression.

formatNumber(variables('Num'),'#0.0')

or

formatNumber(variables('Num'), 'N1')

Now save the flow and run the flow; you can see the result: the number is rounded up.

This is how to convert a number to rounding up on Power Automate.

Convert a number to rounding down in Power Automate

Here, we will see how to convert a number to rounding down in Power Automate.

Let’s first understand what is rounding down a number. The process of lowering a number to the nearest lower value according to a specific rule or convention is known as rounding down.

The general rule for rounding down is that if the digit being rounded is less than 5; you round down to the next lower number

For example:

Rounding to the nearest whole number

• Rounding up the 3.23 ->3

Rounding to a specific decimal place, like tenths

• Rounding up to 3.24 -> 3.2

Example 1

For example, we have the number 45.23, and we will round down the number, i.e. 45. For this, follow the below steps:

1. Open Power Automate Cloud, click on Create, and select Instant Cloud Flow.

2. Then, provide the flow name and select the “Manually triggered a flow” action. Then click on Create.

Now, you can see the “Manually trigger a flow” action is added to the flow page.

2. Next, we will initialize a variable and provide a float number; for this, click on +New step -> select Initialize variable action. Then provide the below information:

• Name: Provide the name of the variable.
• Type: Select the type as float
• Value: Then provide the value to convert.

3. Now, we will round down the number; for this, click on the +New step -> select Compose action. Then provide the below information:

• Inputs: Provide the below expression

formatNumber(variables('Num'),'#0')

or

formatNumber(variables('Num'), 'N0')

4. Now, run the flow manually, and you can see the number is rounded down.

Example 2

For example, we have a number like 45.23, but we want to format this number to round down i.e., 45.2.

To do this in the above flow, we need to change the expression in the compose action, so provide the below expression.

formatNumber(variables('Num'),'#0.0')

or

formatNumber(variables('Num'), 'N1')

Now save and run the flow; you can see the result: the number is rounded down.

This is how to convert a number to rounding down on Power Automate.

Conclusion

In this Power Automate tutorial, we saw how to convert a number to rounding up or down in Power Automate.

You may like the following tutorials:

• format number in Power Automate
• How to Format Number to Percentage in Power Automate?
• Convert String to Float in Power Automate