SharePoint Calculated Column Round Up to Decimal Places

In SharePoint, calculated columns allow you to perform mathematical operations and formatting on data. When you need to round up numbers to specific decimal places, SharePoint provides the ROUNDUP function. In this tutorial, I will explain how to use the ROUNDUP() function to round up values to decimal places using a SharePoint calculated column.

For example, if you are a task manager who manages the task sheet of employees, you can’t have 12.7 full-time resources working on a project. You need to round up this number to 13, which is the nearest integer.

There is a ROUNDUP() function that you can use in SharePoint to round up the values to the nearest integer.

How ROUNDUP() Works in SharePoint

The ROUNDUP function in SharePoint takes two arguments:

1. The number you want to round
2. The number of decimal places you want to round to

The syntax is: =ROUNDUP([ColumnName], num_digits)

For example, if you want to round up a value to one decimal place, you would use:

ROUNDUP([ColumnName], 1).

Check out SharePoint Calculated Column Date Examples

Rounding Options in SharePoint

SharePoint offers several rounding functions:

• ROUND: Rounds to the nearest value (up or down) based on standard rounding rules
• ROUNDUP: Always rounds up (away from zero)
• ROUNDDOWN: Always rounds down (toward zero)

For example, using =ROUND([Column1], 1) would round 1.25 to 1.3 because the portion to be rounded is 0.05 or greater, causing the number to be rounded up.

For more specific rounding needs, you can create custom calculations. For instance, if you need to round to the nearest 0.5 (which SharePoint doesn’t have a built-in function for), you can use:

=ROUNDUP([TheNumber]*2,0)/2

Read Add Leading Zeros to SharePoint List Column using Calculated Column

SharePoint Calculated Column Round Up

I will provide a real-time example to explain the use of a SharePoint calculated column that rounds up to decimal places.

Taking the example of Invoice Tracker, suppose you have a SharePoint list of data as shown below, where you want to find out the rounded up “Total Amount” for each item.

Note that the Total Amount column has values in decimals (calculated by multiplying Quantity & Unit price).

In this case, you may want to convert these values into the next integer value.

Here is the formula that will do this for you:

ROUNDUP([Total Amount],0)

ROUNDUP formula takes two arguments – the number to be rounded and the number of decimals to round it to.

Since in this case, we are looking for integers, we have used zero as the second argument.

Here are the steps to do:

1. Open your SharePoint list, where you want to add a calculated column. Click on the + Add column, and select See all column types. Then, click on the Next button like below.

2. Next, it will navigate to the “Create column” page, where you can add columns to the SharePoint list. Provide column name, select type as Calculated(calculation based on other columns).

3. Enter the formula below in the Formula box and choose the data type returned from this formula to “Number”. Click on Save at the bottom of the page.

=ROUNDUP([Total Amount],0)

Here, 0 represents the number of decimals to round the value.

4. You can see the output in the reference image below.

This is how to round up to the nearest integer in a SharePoint calculated column.

You can provide the number value to round up the integer to the desired number of decimal places.

Check the formulas below with the Output Returned:

Round Up to One Decimal

You can use the formula below to round up to one decimal place in a SharePoint calculated column.

=ROUNDUP([Total Amount],1)

Output:

Round Up to Two Decimals

In the SharePoint calculated column, you can use the following formula to round up to two decimal places.

=ROUNDUP([Total Amount],2)

Output:

Round Up to Three Decimals

You can use the formula below to round up to three decimal places in the calculated column in SharePoint.

=ROUNDUP([Total Amount],3)

Output:

I hope you found this SharePoint tutorial helpful. Here, you learnt how to round up decimal values in a SharePoint calculated column with some real examples.

You may also like the following tutorial:

• SharePoint Calculated Column With A Hyperlink
• LEN() Function in SharePoint Calculated Column

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.