Like theMAX function, MAXA ignores empty cells.
The MAXA 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 MAX functionignoresthe logical and text values completely, the MAXA functionincludesthese values when calculating a maximum value.
MAX ignores empty cells, the logical values TRUE and FALSE, and text values.
MINA Function
The Excel MINA function returns the smallest 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.
