Learn how to use the subtract (-) operator in Notion formulas.
number - number
You can also use the function version,
12 - 5 // Output: 7
subtract(5,12) // Output: -7
If you need to work with more than two operands, the shorthand
-is by far the easiest way to do it.
40 - 10 - 5 // Output: 25
subtract(subtract(40,10),5) // Output: 25
The example database below tracks a weekend of treasure-spending by three pirates. Each starts with a Start Budget of $3,000, and the Leftover formula shows how much each has left after the weekend.
Note how I’ve set the number format of each column to U.S. Dollar. I’ve also set each column’s Calculate value to Sum, allowing me to see the total of all rows put together.
prop("Start Budget") - prop("Saturday") - prop("Sunday")
Instead of using hard-coded numbers, I’ve called in each property using the
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.