Find the maximum value
BeginnerWhen you’re reviewing sales performance, one of the quickest checks is finding the biggest number in a list, like the best month so far.
The MAX function returns the highest value in a set of numbers.
Example:
=MAX(A2:A10)
What you need to do
- Look at the monthly sales amounts in cells B2:B9.
- Click cell B10 (the result cell next to “Highest monthly sales:”).
- Enter a formula that returns the highest sales value from range B2:B9.
- Press Enter. Cell B10 should show the largest monthly sales amount.
Need some help?
Answer
Exercise
Find the maximum value
BeginnerWhen you’re reviewing sales performance, one of the quickest checks is finding the biggest number in a list, like the best month so far.
The MAX function returns the highest value in a set of numbers.
Example:
=MAX(A2:A10)
What you need to do
- Look at the monthly sales amounts in cells B2:B9.
- Click cell B10 (the result cell next to “Highest monthly sales:”).
- Enter a formula that returns the highest sales value from range B2:B9.
- Press Enter. Cell B10 should show the largest monthly sales amount.