SharePoint Calculated Column Round Up [5 Examples]

The SharePoint calculated column ROUNDUP function rounds up a specific number with a specified number of decimals. In this SharePoint Online tutorial, I will explain the SharePoint Calculated Column Round Up. Then, we will discuss using a SharePoint Calculated Column Round Up with different examples.

Last, I will show you, how to add the ROUNDUP function in a Calculated column using another column.

SharePoint Calculated Column ROUNDUP function

The SharePont ROUNDUP function can round up the number always, and by default decimal place is zero. That means the ROUNDUP function will return the nearest integer.

ROUNDUP(Number,Number_digits)

Where,

1. Number: We can add a real number that we want to round up.
2. Number_digits: It is the number of digits to round the number.

Note:

In the ROUNDUP function:
1. If number_digits is greater than zero (0), then the number is round up to the specific number of decimal places.
2. If number_digits is zero (0), then the number is round up to the nearest integer.
3. If number_digits is less than zero (0), then the number is round up to the left of the decimal point.

SharePoint Calculated Column Round Up Examples

Here, we will see how to use the SharePoint Calculated Column Round Up with the following examples. Such as:

• SharePoint calculated column round up to zero decimal places
• SharePoint calculated column round up to one decimal place
• SharePoint calculated column round up to two decimal places
• SharePoint calculated column round up to three decimal places
• SharePoint calculated column round up to the left decimal places

SharePoint calculated column round up to zero decimal places

Let us discuss the SharePoint calculated column round up to zero decimal places. To achieve it, follow the below points.

• Open the SharePoint list where you want to add a calculated column by using the ROUNDUP function and click on the + Add column. Then, select the Number and click on the Next button.

• Then, provide the Name (Price), select Type (Number) or Currency, and the number of decimal places as Automatic. And, click on the Save button.

• Once, the number column is added then click on the + Add column and select See all column types. Then, click on the Next button like below.

• 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, 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.

• Once, the calculated column is added, then enter the price value. And you will get the round-up price value as shown below.

This is the SharePoint calculated column round up to zero decimal places.

SharePoint calculated column round up to one decimal place

Now, I will show you to the SharePoint calculated column round up to one decimal place. Follow the below-mentioned steps.

• Open the SharePoint Online list, click on the existing calculated column to edit, and remove the previous function. Then, enter the new function and click on the Ok button.

=ROUNDUP([Price],1)

• Once, the calculated column is modified or edited, you will get the round-up price value as shown below.

This is the SharePoint calculated column round up to one decimal place.

SharePoint calculated column round up to two decimal places

Similarly, if you want to the SharePoint calculated column round up to two decimal places, then follow the below steps. Such as:

• Open the SharePoint Online list, click on the existing calculated column to edit, and remove the previous function. Then, enter the new function and click on the Ok button.

=ROUNDUP([Price],2)

• Once, the calculated column is edited, you will get the round-up price value, as shown below.

This is the SharePoint calculated column round up to two decimal places.

SharePoint calculated column round up to three decimal places

Here, we will discuss the SharePoint calculated column round up to three decimal places. To do so, follow the below steps.

• Open the SharePoint list, click on the existing calculated column to edit or modify, and remove the previous function. Then, enter the new function and click on the Ok button.

=ROUNDUP([Price],3)

• Once, the calculated column is edited or modified, you will get the round-up price value as shown below.

This is the SharePoint calculated column round up to three decimal places.

SharePoint calculated column round up to the left decimal places

Let us discuss the SharePoint calculated column round up to the left decimal places. To achieve it, follow the below steps.

• Open the SharePoint list, click on the existing calculated column to edit, and remove the previous function. Then, enter the new function and click on the Ok button.

• Once, the calculated column is edited or modified, you will get the round-up price value as shown below.

This is the SharePoint calculated column round up to left decimal places.

Conclusion

Here, from this SharePoint Online tutorial, we learned all about the SharePoint Calculated Column Round Up. Then, we saw how to use a SharePoint Calculated Column Round Up with different examples. Last, I explained adding the ROUNDUP function in a Calculated column using another column.

You may also like:

• SharePoint Calculated Column Replace All Spaces
• SharePoint Calculated Column Get First Letter
• SharePoint calculated column split string
• How to add days to date in SharePoint calculated column?