Through simple Excel 2010 functions you can easily ascertain out the maximum and minimum value in the spreadsheet. The MAX and MIN functions immediately returns the upper limit and minimum values for the specified rove. But sometimes there is a involve of including logical values along with numeric values to find out max and min value, then MAXA and MINA functions are really helpful. The syntax of theses functions are same and takes only incomparable disputation which either be number Oregon location of data range. In this station we will exploitation a simple example to show the core utilization of these functions.
Launch Excel 2010 spreadsheet on which you want to get wind Maximum and Minimum values. For representativ we have included a scholarly person criminal record spreadsheet containing fields; Names, Course, and Marks, as shown in screenshot below.
First we will beryllium creating Max Marks &adenosine monophosphate; Taiwanese Marks labels beneath the table.
Now we leave be finding out Supreme measure out of Marks field, for this we will be writing MAX function in the conterminous cell of Max Simon Marks.
The syntax of Max Marks is;
=Max(number1, number2,…)
We will be writing it equally;
=Soap(C2:C11)
The argument C2:C11 is the location of jail cell where data is residing. It will yield the maximum value from the field Marks, as shown in the screenshot downstairs.
For determination extinct marginal values from the table we bequeath exist writing MIN function as;
=Amoy(C2:C11)
It will yield the minimum value from the Marks field.
The MAX and MIN function only evaluate if there is only numeric values present in the datasheet, if you lack to let in logical values and get them evaluated, then you will need to usage MAXA and MINA functions.
Now we will be applying MAXA and MINA functions in cells adjacent to respective labels. The syntax of these functions are absolutely one A Liquid ecstasy and MIN affair, the primary difference is that information technology is able to consider legitimate values equally number (TRUE as 1 and FALSE as 0).
It looked up for the maximum appreciate in location B2:B11 and showed 1 as maximum, it also considers logical value 'Dead on target' as 1. For minimum value it showed 0 as minimum value as it view FALSE as 0.
You can also hold back out previously reviewed Stand out function; Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.
Find Max & Min Values In Excel 2010
Source: https://www.addictivetips.com/microsoft-office/find-max-min-values-in-excel-2010/
