Notion formulas let you perform calculations on numbers stored in database properties. The round, floor, and ceil functions control how decimal numbers are converted to integers. Each function uses a different rule for rounding. This article explains how each function works, how to write the formula syntax, and where to apply them in a Notion database.
You will learn the exact syntax for round, floor, and ceil, see examples for each function, and understand which function to choose for your specific calculation. The instructions cover property creation, formula writing, and common pitfalls.
Key Takeaways: Using round, floor, and ceil in Notion Formulas
- round(x): Rounds x to the nearest integer; values at .5 round up
- floor(x): Rounds x down to the nearest integer, regardless of decimal value
- ceil(x): Rounds x up to the nearest integer, regardless of decimal value
What round, floor, and ceil Do in Notion Formulas
Notion uses a formula property type to calculate values from other database properties. The round, floor, and ceil functions are part of the Notion formula language. They accept a single number argument and return an integer.
round(x) returns the integer closest to x. If the decimal portion is 0.5 or higher, the function rounds up. If the decimal portion is less than 0.5, the function rounds down. For example, round(3.4) returns 3, and round(3.5) returns 4.
floor(x) always rounds down. It returns the largest integer that is less than or equal to x. For example, floor(3.9) returns 3, and floor(-3.1) returns -4 because -4 is less than -3.1.
ceil(x) always rounds up. It returns the smallest integer that is greater than or equal to x. For example, ceil(3.1) returns 4, and ceil(-3.9) returns -3 because -3 is greater than -3.9.
These functions are useful for pricing calculations, inventory counts, time tracking, and any scenario where you need a whole number. You must create a Formula property in a Notion database before writing the function.
Steps to Create a Formula Property and Use round, floor, or ceil
- Add a Number property to your database
Open your Notion database. Click the + button in the last column header. Select Number from the property type list. Name the property, for example, “Price” or “Hours”. Enter numeric values for each row. - Create a new Formula property
Click the + button again in the column header. Select Formula from the property type list. Name the property, for example, “Rounded Price” or “Floor Hours”. - Open the formula editor
Click inside the Formula property cell for any row. The formula editor panel opens on the right side of the window. This panel contains a text box where you type the formula. - Type the round function
In the formula editor, typeround(prop("Price")). Replace “Price” with the name of your Number property. The function wraps the property reference. Notion displays the rounded result immediately in the cell. - Type the floor function
To use floor, typefloor(prop("Price")). The result shows the value rounded down. Test with a decimal like 4.99 to confirm it returns 4. - Type the ceil function
To use ceil, typeceil(prop("Price")). The result shows the value rounded up. Test with a decimal like 4.01 to confirm it returns 5. - Apply the formula to all rows
Once you type the formula in one cell, Notion automatically applies it to every row in the database. No additional action is needed.
Common Mistakes and Limitations When Using Math Functions
Using the wrong property type as input
The round, floor, and ceil functions require a number as input. If you reference a property that contains text, the formula returns an error. Ensure the source property is set to Number or is a formula that outputs a number.
Forgetting the prop() wrapper
Notion formulas require the prop() function to reference other properties. Writing round(Price) without prop() returns an error. Always use the correct syntax: round(prop("Property Name")).
Negative numbers produce unexpected results with floor and ceil
floor(-2.1) returns -3, not -2. Many users expect floor to always move toward zero. Notion’s floor moves toward negative infinity. Similarly, ceil(-2.9) returns -2, not -3. Test with negative values to confirm the output matches your business logic.
round does not accept a decimal place argument
Unlike Excel or Google Sheets, Notion’s round function does not let you specify the number of decimal places. It always rounds to the nearest integer. To round to a specific number of decimals, multiply the number, apply round, then divide. For example, to round to two decimal places, use round(prop("Price") 100) / 100.
Formula editor does not show autocomplete for functions
Notion’s formula editor does not provide a dropdown list of available functions. You must type the function name exactly. Misspelling the function name causes an error. Double-check the spelling: round, floor, ceil.
round vs floor vs ceil: Behavior Comparison
| Input Value | round(x) | floor(x) | ceil(x) |
|---|---|---|---|
| 2.3 | 2 | 2 | 3 |
| 2.5 | 3 | 2 | 3 |
| 2.7 | 3 | 2 | 3 |
| -2.3 | -2 | -3 | -2 |
| -2.5 | -2 | -3 | -2 |
| -2.7 | -3 | -3 | -2 |
Now you can choose the correct rounding function for your Notion database. Use round for standard arithmetic rounding. Use floor to cap values downward, such as for billing partial hours. Use ceil to force values upward, such as for minimum order quantities. Test each function with sample data before applying it to production records. For advanced rounding to a specific decimal place, combine round with multiplication and division.