Help between Notion users

It's free & easy

Receive points, vote and give the solution

# Does the round formula work with decimal?

For example:

round(3.6)=3

round(10.2)=10

But what if I want something like:

round(102)=100

round(109)=110

Anyone has an idea?

Thanks.

polle Points73210

You can do it with division and multiplication.

round(102/10)*10=100
round(109/10)*10=110

0vote

### nosy commented Nov 24, 2020

Thank you, that worked.

0vote

Saritanotion Points1020

Round to Any decimal
When a Formula property returns a number, it can contain numerous decimals. Here’s an easy way to specify the number of decimals.

Start with a database containing a Formula property with too many decimals.
Determine your modifying number. For your final output to contain one decimal, use 10; for two decimals, use 100. (Add a zero for each decimal place.)
Multiply the full formula by your modifying number. (You may need to wrap the existing formula in parenthesis. PEMDAS)
Surround the new formula with the round function.
Divide that new formula by your modifying number. :)

...