Formulas and Databases

Reference

Formula Examples

e

Learn how to use the mathematical constant e in Notion formulas.

The mathematical constant

$e$

is known as Eulerβs Number, and approximately equals `2.718281828459045`

.1

e

In simple terms, the mathematical constant **base value** for calculating **continuous growth.**

$e$

is a β

$e$

is used to calculate compound interest, rates of radioactive decay, and many other things.More detail about

$e$

ββ*,* check out this guide on BetterExplained:

$e$

takes a while to fully grok, and my explanation here is purposefully simplified. If you want to learn more about $e$

An Intuitive Guide To Exponential Functions & e β BetterExplained

1

e ^ (.3 * 10)

Here is an example formula which could be used to model continuous growth of 30% per year over a period of 10 years.

We can express this as

$e^{(rate \ of \ growth \ * \ number \ of \ time \ periods)}$

.Note that we could multiply these exponents without making any change to the output, so

`e ^ 3`

would work as well.$e$

to a higher power β e.g. `e^n`

is equivalent to `exp(n)`

(where To make this useful, we can multiply it by a **starting number**. For example:

1

500 * e ^ (.3 * 10)

This equation would output a final value if we start with 500 and grow it by 30%/year over 10 years. See the answer in the example database below!

Using

$e$

, we can write a Notion formula that models continuous growth of a starting population by a certain percentage each year over a certain number of years.e

College Info Geek on Notion

1

prop("Starting Num") * e ^ (prop("Growth Rate") * prop("Periods"))

Here weβve just modified the **Starting Num, Growth Rate,** and **Periods.**

`500 * e ^ (.3 * 10)`

example above with variables, which are set by the properties Note that Iβve also changed the **number formatting** on Starting Num, Periods, Formula, and Pretty to **βNumber with commasβ** in order to make them more readable.

Iβve changed the number formatting on **Growth Rate** to **βPercentβ,** which actually changes its numeric value. With this formatting, I was able to type **Formula** interprets it as

`30`

in the first row, but `.30`

(the decimal value of 30%).1

round(prop("Formula") * 100) / 100

The **Pretty** formula simply intakes **Formula,** then applies the

`round()`

function. I use the decimal-place rounding trick to round to two decimal places.β 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 21d ago

Copy link

On this page

Example Formula

Example Database

View and Duplicate Database

"Formula" Property Formula

"Pretty" Property Formula