Home › Practice questions › AVERAGE › Question 9

Excel AVERAGE Practice Question: Using AVERAGE with MAX and MIN, find the midpoint between the highest and…

By Rinkesh Shah, founder of Cellgrids.

The question

Using AVERAGE with MAX and MIN, find the midpoint between the highest and lowest mark and put it in B8.

The data

	A	B
1	Student	Marks
2	Kiran	45
3	Lata	78
4	Manoj	62
5	Naina	90
6	Omar	55
7	Pooja	70
8	Midpoint	?

The yellow cell is where your answer goes.

Show answer

Answer in B8: 67.5

How it works

Explanation: AVERAGE can take other functions as its inputs. Here MAX and MIN supply the two values to average.
Syntax: =AVERAGE(MAX(B2:B7),MIN(B2:B7))
Highest = 90, lowest = 45. (90 + 45) / 2 = 67.5.

Try it yourself in the live sheet

Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.

Try this question in the live sheet →

AVERAGE syntax

=AVERAGE(number1, [number2], ...)

Finds the mean of a set of numbers. AVERAGE is used in financial models and engineering-style calculations where precise numeric work is needed. Full AVERAGE guide.