# min

Learn how to use the min function in Notion formulas.
The `min()` function returns the smallest of one or more numbers. `min()` accepts only numbers or properties that output numbers (it will not auto-convert Booleans).
1
min(number)
2
min(number, number)
3
min(number, number, ...)

## Example Formulas

1
min(4,1,9,-3) // Output: -3
2
3
// Assume prop("Num") contains 3
4
max(prop("Num"),13,5) // Output: 3
5
6
// Other data types must be converted to number
7
min(3,8,+false) // Output: 0
8
// Here, the + operator (unaryPlus) is used to convert
9
// false to a number (0)
Good to know: `min()` and max are useful for finding maximum and minimum values across multiple properties. They're not useful for finding max/min values across multiple database rows.
For that, you'll want to associate the rows to another common row via a Relation, then use a Rollup to calculate the max value among them. Here's a small example database.
This approach still has limitations, but since Notion hasn't provided a true query language for its database feature, it's the best we can currently do (unless you create an external tool via the official API).

## Example Database

The example database below contains quarterly sales data for a fictional company. The Min property displays the dollar amount from the worst quarter, while the Worst Quarter property displays which quarter had the worst performance.

### “Min” Property Formula

1
min(prop("Q1"), prop("Q2"), prop("Q3"), prop("Q4"))
`min()` accepts numbers or number properties.
Here, we simply pass each quarter’s property to the `min()` function in order to find the minimum quarterly sales value.

### “Worst Quarter” Property Formula

1
// Compressed
2
if(prop("Q1") == prop("Min"), "Q1", if(prop("Q2") == prop("Min"), "Q2", if(prop("Q3") == prop("Min"), "Q3", "Q4")))
3
4
// Expanded
5
if(
6
prop("Q1") == prop("Min"),
7
"Q1",
8
if(
9
prop("Q2") == prop("Min"),
10
"Q2",
11
if(
12
prop("Q3") == prop("Min"),
13
"Q3",
14
"Q4"
15
)
16
)
17
)
Here’s an example of how we can make `min()` more useful.
Using a nested if statement, we compare the numeric value of each quarter property to that of the Min property.
If a quarter’s value matches that of the Min property, we output that quarter’s name.