min function and max function usage

min function and max function usage

MIN function

The MIN function is a formula in Microsoft Excel, which can be expressed as min(x,y)=0.5*(x y-|x-y|). Its function is to return the minimum value in the given parameter table. Function parameters can be numbers, blank cells, logical values, or text strings representing numerical values. If there are incorrect values ​​in the parameters or text that cannot be converted into numerical values, an error will occur.

Syntax

MIN(number1,number2, ...)
【A,B】=MIN(number1,number2,...)

Parameters

Number1, number2,... are 1 to 30 numeric parameters from which the minimum value is to be found.

The return value A is the minimum value in the given parameter table, and B is the position in the table below where the minimum value in the parameter table is located

MAX function syntax

MAX(number1, [number2], ...)

MAX function syntax has the following parameters:

number1, number2, ... Number1 is required, subsequent numbers are optional. 1 to 255 numbers from which to find the maximum value.

Remarks

The parameters can be numbers or names, arrays or references containing numbers.

Logical values ​​and text representing numbers typed directly into the parameter list are counted.

If the parameter is an array or reference, only the numbers in it are used. Blank cells, logical values, or text in arrays or references are ignored.

If the argument does not contain any numbers, MAX returns 0 (zero).

If the parameter is an incorrect value or is text that cannot be converted to a number, an error will result.

If you want the calculation to include logical values ​​in references and text that represents numbers, use the MAXA function.

The above is the detailed content of min function and max function usage. For more information, please follow other related articles on the PHP Chinese website!