How Excel Max functions use

The Max function is a function that asks for the maximum value. It is a commonly used function in Excel functions, for example, to calculate student's highest score, employee's maximum salary, and maximum integral.

Max function Syntax: Max (Number1,number2,...)

Max function Application considerations:

1, the parameter number1, the number2 and so on can be the number, the cell name, the contiguous cell region, the logical value;

2, if the cell name, continuous cell range and other data references, usually only calculate the value or through the formula calculation of the numerical part, do not calculate the logical value and other content;

3, if the parameter after the Max function does not have a number, will return 0 (example 2);

Max Function Example:

Sample Table	A
1	5
2	15
3	True
4	3g
5	0

A is the column number in the table above, and the left 1-5 is the line number.

Enter the result of the following formula in a cell:

Example 1, =max (a1:a2,a5,true) result is 15, in this example, a continuous cell reference a1:a2 is used, with the logical value TRUE (the value here True is considered as 1);

The result of Example 2, =max (A3:A5) is 0, the logical value in this example is true, and the string 3g is not computed;

The above is to find the maximum function of the example, hope that the triple Small series Ehoy provide these examples of information for everyone to help Oh!

        Note : more Wonderful tutorials please focus on the Triple computer Tutorials section, triple Computer office group: 189034526 Welcome to join