Formula Components

Formulas and Databases

Reference

Formula Examples

multiply

Learn how to use the multiplication (*) operator in Notion formulas.

1

number * number

2

multiply(number, number)

The

`*`

operator follows the standard mathematical order of operations (PEMDAS). For more detail, see Operator Precedence.You can also use the function version,

`multiply()`

.1

12 * 4 // Output: 48

2

β

3

multiply(12,-4) // Output: -48

Since **multiply** is a binary operator, it can only work on two *operands -* the objects which are being operated on (if - the *ternary operator -* is the only operator that works on three operands).

If you need to work with more than two operands, the shorthand

`*`

is by far the easiest way to do it.1

4 * 5 * 5 // Output: 100

2

β

3

multiply(multiply(4,5),5) // Output: 100

Can I switch the order of the numbers in a multiplication statement?

The example database below shows the interest owned by three pirates who smartly invest some of their savings.

The **Interest Earnings** formula shows the total amount of interest that their investment generates over a number of years, given a specific interest rate.

multiply

College Info Geek on Notion

This example uses the simple interest formula

$Prt$

, where:- β$P$is the principal
- β$r$is the rate of interest converted to a decimal (e.g. 7% is converted to 0.07)
- β$t$is the number of period (in this case, years)

Note: This formula only returns the total interest earned.

1

prop("Investment") * prop("Interest Rate") * prop("Years")

Instead of using hard-coded numbers, Iβve called in each property using the

`prop()`

function.β 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 20d ago

Copy link

On this page

Example Formulas

Working with 3 or More Operands

Example Database

View and Duplicate Database

"Interest Earnings" Property Formula