Links

divide

Learn how to use the division (/) operator in Notion formulas.
The divide (/) operator allows you to divide two numbers and get their quotient.
1
number / number
2
divide(number, number)
The / operator follows the standard mathematical order of operations (PEMDAS). For more detail, see Operator Precedence.
You can also use the function version, divide().

Example Formulas

1
12 / 4 // Output: 3
2
3
divide(12,-4) // Output: -3

Working with 3 or More Operands

Since divide is a binary operator, it can only work on two operands - the objects which are being operated on (if - the ternary operator - is the only operator that works on three operands).
If you need to work with more than two operands, the shorthand / is by far the easiest way to do it.
1
40 / 2 / 5 // Output: 4
2
3
divide(divide(40,2),5) // Output: 4
No - unlike addition and multiplication, which are commutative, division won’t work if you switch around the numbers you’re working with. 8/2 = 4, but 2/8 = 0.25.
The same applies when working with 3 or more operands.
100/2/4/2 = 6.25, while (100/2)/(4/2) = 50/2 = 25.

Example Database

The example database below shows the per-person split for several heists carried out by a certain crew of classy thieves. The simple Split formula shows the / operator in action, and simply divides Total by Shares.

View and Duplicate Database

"Split" Property Formula

1
prop("Total") / prop("Shares")
Instead of using hard-coded numbers, I’ve called in each property using the prop() function.
Curious about how the Shares formula is able to get a count from the Members property? See that breakdown here: Count multi-select tags

About the Author

My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.
Last modified 4mo ago