What is the function displays the highest value in a range?

Answer 1

This would be the MAX function.

=MAX(A1:A12)

You can also use the LARGE function, with 1 specified as the position to find. 1 specifies the largest, 2 the second largest, 3 the third largest and so on. LARGE is best used when it is not the highest value you are looking for, but it still can be used to find the largest. It can be done like this:

=LARGE(A1:A12,1)

Answer 2

The MAX Function. If you wanted to find the largest value in the range from cell A2 to cell A20, the formula would be:

=MAX(A2:A20)

You can also use the LARGE function. It is designed to be able to find not just the highest but other positions, like the second or third largest. You do this by specifying a number to indicate which position you want. Using 1 would give you the largest, as follows:

=LARGE(A2:A20,1)

Answer 3

MAX is the answer