SharePoint Calculated Column Round Up to Decimal Places

Do you need to round up to decimal places in SharePoint? In this tutorial, I will explain how to use the roundup() function to round up to decimal places by using a calculated column in SharePoint.

ROUNDUP function in SharePoint Calculated Column

The ROUNDUP function takes two arguments: the number you want to round and the number of decimal places you want to round to. If the num_digits argument is greater than 0, the function rounds the number up to the specified number of decimal places. If num_digits is 0, the number is rounded up to the nearest whole number.

For example, if you have a column named ‘Total’ and you want to round up the values in this column to the nearest whole number in a new calculated column, your formula would look something like this:

=ROUNDUP([Total], 0)

This would take the value in the ‘Total’ column and round it up to the nearest whole number, regardless of whether the fractional part is more or less than 0.5.

Now, let me show you how to use the roundup() function in a calculated column in SharePoint.

I will show here, how to use a calculated to round to zero decimal places in SharePoint.

Here, I have a SharePoint list with a Price column, which is of number type, and there I choose “Number of decimal places as Automatic” like the screenshot below:

Create a SharePoint Online Calculated Column Round Up

Now, I will add a calculated column to round up the above Price column. To add a calculated column:

  • Open the SharePoint list, click on the + Add column, and select See all column types. Then, click on the Next button like below.
SharePoint Calculated Column Round Up
  • Then, provide the Column name (Price Roundup) and select the Data type (Calculated). Next, enter the ROUNDUP function and select the data type as a Number and the number of decimal places as Automatic.
  • Also, click on the OK button.
ROUNDUP([Price],0)

Where,

  1. Price = It is a number column to use in the calculated column.
  2. 0 = It is the number of digits to round the number or number of decimal places.
SharePoint Online calculated column round up to zero decimal places
  • After you add the formula, Save it. You can see the output in the screenshot below:
SharePoint calculated column to round a number

This is how to round up to zero decimal places in a calculated column in SharePoint.

Similarly, if you want to round up to one decimal place, write the below formula in the calculated column.

=ROUNDUP([Price],1)
SharePoint Online calculated column to round a number

Round up to two decimal places:

=ROUNDUP([Price],2)
SharePoint Online calculated column round up to two decimal places

Round up to 3 decimal places:

=ROUNDUP([Price],3)
SharePoint calculated column round up to three decimal places

Conclusion

In this SharePoint tutorial, I have explained how to use the roundup() function in the SharePoint calculated column.

You may also like: