Use Of Max, MaxA And Min, MinA Formulas In Microsoft Excel.
MS Excel formulas: Easiest way to understand Syntax and usage:
Max Function:
Max function is used to get the minimum value from the table or data or Max formula returns the maximum value form the data. Let suppose we have a list of different amount and we want to check the maximum value within the data, so we can use this formula Max ( ).
Microsoft Excel two very useful and simple functions are “MIN”
and “MAX”. Both function has the reverse function to each other, finding the smallest
and largest value in the cell or from range of cell. We can also use it to find
values in huge database.
SyntaxMax (Number1, Number2, ......)
Min Function:
Min function is use to get the minimum value from the data base. With the help of this function you can get minimum values from the data easily.
Syntax
Min (Number1, Number2, ......)
Max and Min formula is defined in the below example. Now we have the maximum and minimum value of the data.
Example 1 : Max and Min Function In Microsoft Excel.
MaxA Function :
MaxA unction is same like max function and same syntax but it also consider True and False also. It consider True is 1 and False is 0.
Syntax
MaxA (Number1, Number2, ......)
MinA Function:
MinAfunction is also same like Min function and same syntax but it also consider True and False text. True considers as 1 and False considers as 0.
Syntax
MinA (Number1, Number2, ......)
Example 2 - MaxA and MinA Functions in MS Excel.
The above example has clearly defined the use of MaxA and MinA and the output.
For more clarification prepare the same table or data and start practicing until clear your doubts.
Please comment for more excel query or any suggestions.
Thanks for your time...
Comments
Post a Comment