How to Round Numbers in Notion to Any Decimal Place - With Formula

Table of contents

• 1. Open Notion database with a ‘Number’ property type column containing values you want to round
• 2. Create a column with ‘Formula’ property type for rounding
• 3. Access the formula window
• 4. Round numbers to required decimal place with formula
• Round to nearest whole number - without decimals
• Round number to one decimal place
• Round number to two decimal places
• FAQs
• How to round percentages in Notion?
• What is the Round() function in Notion?

Let’s discuss the process in detail.

1. Open Notion database with a ‘Number’ property type column containing values you want to round

…Or create a new one from scratch.

For this guide, we'll use a sample database tracking Q2 stock market returns.

The title column contains the month and the ‘Amount’ column is set to the ‘Number’ property type and contains values with three decimal places. We will demonstrate rounding these to 0,1, and 2 decimal places.

2. Create a column with ‘Formula’ property type for rounding

This formula entered in this column will round values in the column with the ‘Number’ property type.

Start by clicking the ➕ icon next to the rightmost column of the database. This will open the ‘Options’ menu. Scroll down and select ‘Formula’.

Name the column - ‘Round to 0 decimal places’ in our example.

3. Access the formula window

Click ‘Edit’ to open the window where you can enter the formula.

Here’s what Notion’s formula interface looks like:

4. Round numbers to required decimal place with formula

The Round() formula allows rounding off numbers in Notion to desired decimal places. We'll demonstrate rounding the 'Amount ($)' column to 0, 1, and 2 decimal places.

Here’s how to use it:

Round to nearest whole number - without decimals

Use the formula - Round(property_name) to remove all decimal places from a number column in Notion.

In our example, the formula we would enter is - Round(Amount ($))). Let’s type it into the formula space.

Here’s what we get as result:

Notion has removed all decimal places for numbers under the ‘Round to 0 decimal places’ column.

Round number to one decimal place

Let’s create another Notion column for rounding numbers to the first decimal place. We’ll call it ‘Round to 1 decimal place’

Use the formula - Round(property_name*10)/10 to retain only one decimal place in Notion. In our example, the formula we use is - Round(Amount ($)*10)/10

As visible in the below image, the numbers are rounded off to the first decimal place under the ‘Round to 1 decimal place’ column.

Round number to two decimal places

Use the formula - Round(property_name*100)/100 to round numbers to two decimal places. The formula that we will use in our example is - Round(Amount ($)*100)/100

As visible in the below image, the numbers are rounded off to two decimal places under the ‘Round to 2 decimal places’ column.

FAQs

How to round percentages in Notion?

Round percentages in Notion by using the formula - Round(property_name*10^(n+2))/10^(n+2). Where ‘n’ is the number of decimal places you want to display.

Percentage in Notion a sub-property type under the ‘Number’ property type and Notion records it in plain decimal format. So, 92.543% is stored as 0.92543 - a denominator of 100 is added by default. Using the plain Round() function for this percentage value will return 0%. To get the percentage value up to one decimal point, for example, you need to multiply and divide the value by 1000, accounting for the denominator of 100.

In summary, what Round(property_name*10)/10 does for a playing ‘Number’ property type, Round(property_name*1000)/1000 does for a percentage value.

We created a new column ‘Percentage’ with the ‘Percentage Number’ property type. Another column ‘Round Percentage’ with the ‘Formula’ property rounds the percentage value to one decimal place.

What is the Round() function in Notion?

Round() function allows users to round numbers to any decimal place. It's entered into the ‘Formula’ property type column within a Notion database and accepts only ‘Number’ property type columns within parenthesis.