Learn how to use the multiplication (*) operator in Notion formulas.
The multiply (*) operator allows you to multiply two numbers together and get their product.
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().
Example Formulas
1
12*4// Output: 48
2
3
multiply(12,-4)// Output: -48
Working with 3 or More Operands
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?
Example Database
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.
View and Duplicate Database
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.