Question

How is MIN, MAX, COUNT, functions diffrrent from MINA, MAXA AND COUNTA.Plz explain.

Answer 1

MIN: Mobile Identification Number
MAX: Maximum

Answer 2

MAX Function. This function returns the largest or maximum value, of a set of values.

The MIN Function returns the smallest or minimum value of a set of values

We have a list of numbers in cell range and we would like to see the values which one is the largest or the maximum value of the data set. So, for this simple evaluation, we can use the MAX Function.

We have a mixed list of values (numbers and a logical value) in cell range and we would like to see the values, which one is the largest or the maximum value of the data set. So, for this evaluation, we can use the MAXA Function.