Links

e

Learn how to use the mathematical constant e in Notion formulas.
The mathematical constant
ee
is known as Euler’s Number, and approximately equals 2.718281828459045.
1
e
In simple terms, the mathematical constant
ee
is a base value for calculating continuous growth.
ee
is used to calculate compound interest, rates of radioactive decay, and many other things.
Many of these types of growth happen continuously. In other words, the growth doesn’t simply happen instantly, at the end of a certain period.
If growth worked that way, then a 100% rate of growth (i.e. a doubling) applied to a value of 1 would result in a total value of 2 at the end of the first period. You’d have no growth at all until the very end, and then… poof! 1 doubles to 2.
But many types of growth - including things like compound interest - happen continuously.
If you have $1 that is earning interest, then the interest it earns can start earning interest itself.
Therefore, by the end of the first period, you won’t have just $2 - you’ll have more. How much more? It depends on how quickly each bit of interest can start earning its own interest.
If it can do it instantly, then you’ll end up with around $2.71 at the end of the first period - in other words, you’ll end up with
ee
.
ee
takes a while to fully grok, and my explanation here is purposefully simplified. If you want to learn more about
ee
, check out this guide on BetterExplained:

Example Formula

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)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.
Good to know: You can also use the exp function to raise
ee
to a higher power – e.g. e^n is equivalent to exp(n) (where n is a number).
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!

Example Database

Using
ee
, 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.

View and Duplicate Database

"Formula" Property Formula

1
prop("Starting Num") * e ^ (prop("Growth Rate") * prop("Periods"))
Here we’ve just modified the 500 * e ^ (.3 * 10) example above with variables, which are set by the properties Starting Num, Growth Rate, and Periods.
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 30 in the first row, but Formula interprets it as .30 (the decimal value of 30%).
Other formula components used in this example:

"Pretty" Property Formula

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.
Other formula components used in this example:

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.