Like theMIN function, MINA ignores empty cells.
The MINA function takes multipleargumentsin the formnumber1,number2,number3, etc.
up to 255 total.
Arguments can be a hardcoded constant, a cell reference, or a range, in any combination.
While the MIN functionignoresthe logical and text values completely, the MINA functionincludesthese values when calculating a minimum value.
The MIN function ignores empty cells, the logical values TRUE and FALSE, and text values.
MAX Function
The Excel MAX function returns the largest numeric value in the data provided.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
MAXA Function
The Excel MAXA function returns the largest numeric value in a range of values.
from a set of numeric data.
RANK can rank values from largest to smallest (i.e.
top sales) as well as smallest to largest (i.e.
