# max

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

## Example Formulas

1
max(3,5,4) // Output: 5
2
3
// Assume prop("Num") contains 20
4
max(prop("Num"),13,5) // Output: 20
5
6
// Other data types must be converted to number
7
max(1,+true,+"3",9) // Output: 9
8
// Here, the + operator (unaryPlus) is used to convert
9
// true and "3" to numbers.
Good to know: `max()` and min 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 Max property displays the dollar amount from the best quarter, while the Best Quarter property displays which quarter had the best performance.

### “Max” Property Formula

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

### “Best Quarter” Property Formula

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