MIN and MAX · Martinとコード

MIN and MAX are functions like SUM

You already know =SUM(B2:B6) and =AVERAGE(B2:B6). MIN finds the smallest number in a range. MAX the largest.

With grades in Czechia 1 is best, 5 is worst (in secondary school the other way — a teacher will tell you). For our course we count grades 1–5, where 1 is best. Then:

=MIN(B2:B6) = the best grade (the smallest number)
=MAX(B2:B6) = the worst grade (the largest number)

💡

English Sheets: =MIN(...), =MAX(...). The same names. If #NAME?, check the language and the range.

An example on paper

Grades 2, 1, 3, 1, 2:

MIN = 1 (two ones, the function returns the first smallest)
MAX = 3

Into the table

Sheet Grades. Under the Average row (or next to it) A Best, B formula =MIN(B3:B8) — a range by your data without the heading and without the average.
A next row Worst, B =MAX(B3:B8).
If you have grades 1,2,1,3,2 in B3:B7, MIN shows 1, MAX 3.
Click the MIN cell. In the formula bar a function, not a hard 1.

⚠️

The range must not reach the average. If MAX looks at a cell with average 1.8, the result is weird. Only clean grades.

Pocket money — the biggest spend

Pocket column C spends C2:C8.
A10 Biggest spend, B10 =MAX(C2:C8).
Change one spend to a bigger number. MAX must go up.

🏫 Grade average

One sheet, two columns: subject and grade. At the bottom a sum and an average.

💰 Pocket money

Rows = days, columns = income / spend / left.

📊 Class survey

One question, answers in one column, later a chart.

🏆 Mini dashboard

Three numbers at the top and one chart. Numbers as a link, not copied by hand.

Now you 💪

On Grades you have MIN and MAX under the data with labels in A.
The range points only at grades, not at the total/average.
Changing one grade changes MAX or MIN, when it beats the old one.
On Pocket MAX from spend works.
In the cell is a number, in the formula bar =MIN or =MAX.

✅

Check: MIN and MAX live in formulas. You know what they mean with grades 1–5.

What to take from this lesson

MIN = the smallest number in a range. MAX = the largest.
With grades 1–5 MIN is often the best grade.
A range only data, not results of other functions.
English names MIN/MAX are the same.
MAX from spend shows the most expensive day.