Max

Updated: 10/02/2017 by Computer Hope
max

Max may refer to any of the following:

1. Max is short for maximize.

2. Short for maximum, max is a Microsoft Excel and spreadsheet formula to find the maximum value in a range of cells. For example, the formula below finds the maximum value in cells A1 through A10. If these cells had the values 1,2,3,4,5,6,7,8,9, and 10 the result would return "10" since it is the largest or maximum value in all of the cells.

=max(a1:a10)
Tip

If you wanted to get the minimum instead of the maximum, you would use the min function and getting an average would use the average function.

Computer abbreviations, Excel formula, Software terms, Spreadsheet terms