106. Calculating maximum values with MAX

Calculating Maximum Values with the MAX Function

The **MAX** function in Excel is used to find the largest number in a range of values. It is useful for identifying the highest value in datasets such as grades, sales figures, or measurements.

Syntax of the MAX Function

=MAX(number1, [number2], ...)
    
  • number1: The first number, cell reference, or range.
  • [number2]: (Optional) Additional numbers, cell references, or ranges.

Steps to Use the MAX Function

  1. Select the cell where you want the result to appear.
  2. Type =MAX( followed by the range or numbers to evaluate.
  3. Close the parentheses ) and press Enter to see the result.

Interactive Example: MAX Function

Item Value
Score 1 85
Score 2 90
Score 3 78
Maximum Value Click Calculate

Edit the values in the table above and click "Calculate Maximum" to see the MAX function in action.

This example demonstrates how the MAX function calculates the largest value in a range of numbers in Excel.

Comments