The formula for Ms. Excel MAX, MAXA, MIN, MINA along with examples

Excel MAX and MIN formulas are functions (functions) that are used to calculate the maximum data value (MAX) and the minimum data value (MIN). In addition to the MAX and MIN functions, there are MAXA and MINA formulas. The suffix A stands for argument. Unlike MAX and MIN which only calculate numeric data, the Excel MAXA and MINA formulas calculate the maximum and minimum values for both numeric and non-numeric data. Non-numeric data in the form of text (0) and boolean, namely TRUE (1) FALSE (0). Boolean data types are generally generated by logical operations.

FormulaFunction
MAXCalculates the maximum value of numeric data in a range
MAXACalculates the maximum value for numeric and non-numeric data
MINCalculates the minimum value of numeric data for a range
MINACalculates the minimum value for numeric and non-numeric data

URGENT: The use of commas (,) or semicolon (;) in FORMULA is adjusted to the version of Microsoft Excel and the language configuration on your computer.

1. Excel MAX formulas

The Excel MAX formula is a function that is used to calculate the maximum value of numeric data. The following is the systematics of the Excel MAX formula

=MAX(range1, range2, sel1,...)
=MAX(E1:E6)

2. Excel MAXA formula

The Excel MAXA formula is a function that is used to calculate the maximum value of numeric and non-numeric data in a range. The following is the systematics of the MAXA formula

=MAXA(range1, range2, sel1,...)
=MAXA(E2:E5)

3. Excel MIN formula

The Excel MIN formula is a function used to calculate the minimum value for numeric data. The following is the systematics of the Excel MIN formula

IMPORTANT: The use of commas (,) or semicolon (;) in the FORMULA is adjusted to the Microsoft Excel version and language configuration on your computer.

=MIN(range1, range2, sel1,...)
=MIN(E1:E3)

4. Excel MINA formula

Excel MINA formula is a function that is used to calculate the minimum value of numeric and non-numeric data for a range. The following is the systematics of the MINA formula.

=MINA(range1, range2, sel1,...)
=MINA(E2:E5)

URGENT: The use of commas (,) or semicolon (;) in FORMULA is adjusted to the version of Microsoft Excel and the language configuration on your computer.

Leave a Reply

Your email address will not be published. Required fields are marked *