Today we are going to learn how to subtract 2 numbers in Notion.
Subtracting 2 numbers together in Notion is a really simple task. This can be accomplished with the use of subtract operator in Notion.
Let’s begin…
In order to find the difference of 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 difference between 2 numbers.
- Set up the database correctly.
- Put the desired formula that will help us find the difference 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:
- lists,
- galleries,
- 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 difference of 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. subtract(). 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 difference between 2 numbers in a database.
First, we need to add the following 4 properties to the database to find the difference between 2 numbers in a database:
| Property Name | Property Type |
| Operator | Title |
| No 1 | Number |
| No 2 | Number |
| 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 difference 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 difference now.
Finally, we will add another property that will have “Formula” as the type of property that will help us calculate the difference between 2 numbers.
Now, it’s time to implement the formula to find the difference between 2 numbers in Notion.
Read More: How to add 2 numbers in Notion
Formula to find the difference 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 difference between 2 numbers in Notion.
Use of subtract function to find the difference between 2 numbers in Notion (Formula: 1)
In this formula, we will find the difference between 2 numbers by using the subtract operator.
For finding the difference between 2 numbers, Notion has another built-in operator to help us find the difference of numbers, i.e. subtract().
Essentially, subtract operator helps to find the difference between 2 numbers, when we provide the input of 2 numbers inside an operator.
Eg:
subtract (5,3) = 2
Now in order to find the difference of 2 numbers, i.e. No 1 and No 2, we would use the following formula:
subtract(prop(“No 1”), prop(“No 2”))
You can copy + paste the following code (formula:1) onto your Notion workspace to find the difference between 2 numbers…
subtract(prop(“Number 1”), prop(“Number 2”))
Simply subtract 2 numbers together in Notion (Formula: 2)
This is a basic formula that essentially works on the following logic:
“Subtract all the numbers together with the use of the “-” sign ”
Here’s the formula we are going to use to find the difference of 2 numbers using Notion:
prop(“No 1”) – prop(“No 2”)
You can copy + paste the following code (formula:2) onto your Notion workspace to find the difference of 2 numbers…
prop(“Number 1”) – prop(“Number 2”)
Summary
Here’s what we learned about how to subtract 2 numbers in notion and find their difference.
We have used 2 formulas to find the difference between 2 numbers in a database.
- prop(“Number 1”) – prop(“Number 2”)
- subtract(prop(“Number 1”), prop(“Number 2”))