Fresh Excel Tips

This example finds the largest value in the range A3:D11 by using the MAX function. The function’s return value is the largest value in a set. Here is the syntax for using the MAX Function
MAX(number1, number2, …)
number1, number2, …: From 1 to 30 numbers for which you want to find the largest value. It is possible to use a cell reference; however, the cells must contain numbers or values that can be converted to numbers.

To determine the largest value in a range:

1. In cells A3:D11 type any values.
2. In cell B1 type the formula =MAX(A3:D11).
3. Press Enter.

This tip is compatible with Excel 97, 2000, 2003 and 2007.

1. Using the SUM function to Sum a Range of Values in Excel
2. Use the RANDBETWEEN function to generate random values in a specified range
3. How to Use the LARGE function to find the highest values in Excel
4. Use the SMALL function to find the smallest values in Excel
5. Use the MIN function to find the employee with the lowest sales