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

I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com