Find Highest number by using MAX Function

How to find the maximum or highest number in the Excel sheet ? 

For the Microsoft Excel. If you have many numbers or values and you must place the highest value in a cell, you will feel dizzy to find the highest value for that cell. Because of too many number, the Microsoft Excel supplies you the MAX Function for your convenience. The syntax of the MAX Function is

=MAX( argument1, argument2, … argument30)

Argument1, argument2, … can be numbers, arrays, cell references, or named ranges. the MAX Function allows you to enter limited arguments  at 30 values.

• to find the highest value in statistics.
• to find the highest score for a competition.
• to find the highest temperature each day.
• to find the largest country by finding the largest area.
• to find the highest value in a science experiment.

How to use the MAX Function?

Ok. I will show you how to use with this example below. Supposing that you wanted to find the largest number in the cells C1 to C10. Now follow the steps.

• Put the numbers in the cell, C1 to C10, see the picture below.
  

• Click on C11 cell or where you want to place the highest number.
• Type =max(c1:c10) and then press the Enter.
• Now the highest number appears in C11 cell.