How to use excel max function

MAX function: =MAX().

MAX function syntax: MAX(number1,number2,...)number1, number2,...: are 1 to 255 numeric parameters from which the maximum value is to be found. Arguments can be numbers or names, arrays, or references containing numbers. Logical values ​​and text representing numbers typed directly into the argument list are counted. If the argument is an array or reference, only the numbers in that array or reference are used. Blank cells, logical values, or text in arrays or references are ignored. If the argument does not contain a number, the MAX function returns 0 (zero). An error will result if the argument is an incorrect value or is text that cannot be converted to a number. If you want the calculation to include logical values ​​and text representing numbers in references, use the MAXA function. The MAX function returns the maximum value in a set of values.

Example: Find the maximum number in cells B1:B4 when cells A1:A4 are greater than or equal to 60.

As shown below, enter =MAX(IF(A1:A4>=60,B1:b4)) in cell A6, press the "Ctrl Shift Enter" key combination to enter the array formula to calculate the conditions that are met the maximum value.

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to use excel max function. For more information, please follow other related articles on the PHP Chinese website!