Today we are going to learn how to find the remainder of numbers in Notion.
Finding the remainder of numbers in Notion is a really simple task. This can be accomplished with the use of a mod operator in Notion.
In order to find the remainder of the numbers in 1 database, we will follow a 3-step approach as follows:
- We need to create a database to hold the data to find the remainder of the numbers.
- Set up the database correctly.
- Put the desired formula that will help us find the remainder between 2 numbers.
How to create a database in Notion? (Step 1)
Before creating a database, let’s first understand what is a database.
What is a database?
In Notion, a database is a collection of data that can be structured and organized in a variety of ways. It’s a powerful feature that allows users to create custom databases to store, manage, and track information in a structured and organized manner.
A Notion database is made up of a collection of properties that define the different types of data that can be stored within it.
These properties can include text, numbers, dates, formulas, attachments, checkboxes, and more.
Databases in Notion can be customized to suit a variety of needs, including:
- project management,
- task tracking,
- inventory management,
- customer relationship management, and more.
They can be organized into tables and viewed in a variety of formats, including:
- calendars, and
- Kanban boards.
Overall, databases in Notion provide a flexible and powerful way to organize and manage information, making it a popular tool for individuals and teams across a wide range of industries and use cases.
Simply said, a database will help to hold the values of data inside it through which we can perform any operation.
How to create a database in Notion?
In order to add a database in Notion, simply type “/database” and you will get a list of options for adding a database in Notion.
Select “Database – Inline” and you can add a database to your Notion page quickly.
Next, we will set up the database correctly to find the remainder of the 2 numbers.
Setting up the database correctly (Step:2)
In any database that you ever create, there will always be a default property which is the first column of the database.
This property will always have the “Type” as “Title” which can’t be changed.
In this example, we are writing the Operator name in use in the first column, i.e. mod(). Thus we will name the first property as Operator which is shown below.
Here’s what we will require in our database to find the remainder between 2 numbers in the database.
First, we need to add the following 4 properties to the database to find the remainder between 2 numbers in a database:
|Property Name||Property Type|
|No 1 % No 2 [mod()]||Formula|
|No 1 % No 2 [/]||Formula|
We will talk about each property in the following section.
How to add properties in a database in Notion to find the remainder between 2 numbers?
In order to add a new property, we need to click on the “+” sign at the top right corner of a database.
Once selected, you will get a list of options to choose from to select the property type.
Select the “Number” property and name it “No 1”. We will be able to create a No 1 property as shown below.
Next up, we will add No 2 as another property similar to above and keep its property type as Number as well.
Adding these 2 properties has helped in adding 2 numbers to find the remainder now.
Finally, we will add another property that will have “Formula” as the type of property that will help us calculate the remainder between 2 numbers.
Now, it’s time to implement the formula to find the remainder between 2 numbers in Notion.
Formula to find the remainder between 2 numbers in Notion (Step: 3)
Once our database is set up, we need to figure out which formula to use to find the remainder between 2 numbers in Notion.
Use of mod function to find the remainder between 2 numbers in Notion (Formula: 1)
In this formula, we will find the remainder between 2 numbers by using the mod operator.
For finding the remainder between 2 numbers, Notion has another built-in operator to help us find the sum of numbers, i.e. mod().
Essentially, the mod operator helps to find the remainder between 2 numbers, when we provide the input of 2 numbers inside an operator.
mod (5,3) = 2
Now in order to find the remainder of 2 numbers, i.e. No 1 and No 2, we would use the following formula:
mod(prop(“No 1”), prop(“No 2”))
You can copy + paste the following code (formula:1) onto your Notion workspace to find the remainder between 2 numbers…
mod(prop(“Number 1”), prop(“Number 2”))
Simply divide 2 numbers together in Notion (Formula: 2)
This formula doesn’t work in calculating the remainder of numbers but instead gives the quotient of the numbers in Notion.
Here’s the formula that we may use to get the quotient of numbers in Notion while dividing the numbers:
prop(“No 1”) / prop(“No 2”)
You can copy + paste the following code (formula:2) onto your Notion workspace to find the quotient of 2 numbers…
prop(“Number 1”) / prop(“Number 2”)
Note: We may note that the above formula doesn’t return the remainder of the numbers but instead gives the quotient of both.
Here’s what we learned about finding the remainder of 2 numbers in Notion. We have used 1 formula to find the remainder between 2 numbers in a database.
- mod(prop(“Number 1”), prop(“Number 2”))