answersLogoWhite

0

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

The MIN function returns the lowest value from a set of values. The MAX function returns the highest value from a set of values.

=MIN(A2:A20)

=MAX(A2:A20)

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How do you calculate range in maths in Excel?

The range is the difference between the highest and the lowest values. You can find the highest using the MAX function less the value found by the MIN function. So if you wanted to get the mathematical range for the cell range A2 to A30, you would do this: =MAX(A2:A30) - MIN(A2:A30)


What is the variation interval?

It's called "range" in English and it is a difference between min. and max. value.


What is the difference between min and max on the oil dip stick?

The difference between min and max is, the min means the minimum amount of oil you can have in your engine, max means the max amount of oil you can have without causing overflow of the oil. You want it in between so when your engine gets hot and your oil expands a little bit it won't over flow your oil filter or dipstick, plus too much over the max level and you could cause oil filter problems, which then in turn can ruin your engine.


How do I get max to min serial or What function can I use to get max to min or min to max serial?

You can use the SEQUENCE function in Excel to create a series of numbers from max to min or min to max. For example, to create a series from 10 to 1 in descending order, you could use =SEQUENCE(10,1,-1). This formula generates a range of numbers from 10 to 1 in descending order.


What do the Max and Min functions do?

The MAX function gets the highest value in a range and the MIN function gets the lowest. If there were values in all the cells from A2 to A20, you could use the two functions to get the highest and lowest values in the range:=MAX(A2:A20)=MIN(A2:A20)


Write a c program to find the sum of numbers between given limits?

int sum (int min, int max) {return (max-min+1)*(max+min)/2;}


Why do you measure effective diameter of a screw thread?

the difference between the min and max effective of your two threads will tell you if there going to clash on assembly


What is the usefulness of the second derivative in finding the absolute extrema of a function?

it tells you if it is a min or max


How do you find sum of sin series?

You take the integral of the sin function, -cos, and plug in the highest and lowest values. Then subtract the latter from the former. so if "min" is the low end of the series, and "max" is the high end of the series, the answer is -cos(max) - (-cos(min)), or cos(min) - cos(max).


What formula with functions in Excel can you enter to calculate the ratio of the maximum value in the range Z1 to Z10 to the minimum value?

=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)=MAX(Z1:Z10)/MIN(Z1:Z10)


Trace out the algorithm Max Min on a data set containing atleast 8 elements?

Steps to perform MaxMin on a data set (2,4,6,3,8,1,9,7) are:(2,4,6,3) (8,1,9,7)((2,4)(6,3)) ((8,1)(9,7))In sublist (4,6), max is 6 and min is 4. In sublist (8,9), max is 9 and min is 8.Comparing max and min values of sublist (2,4) and sublist (6,3), value of max is 6 and min is 2.Therefore, for sublist (2,4,6,3) max is 6 and min is 2.Similarly, comparing max and min values of sublist (8,1) and sublist (9,7), value of max is 9 and min is 1.Therefore, for sublist (8,1,9,7) max is 9 and min is 1.Finally, comparing max and min values of sublist (2,4,6,3) and sublist (8,1,9,7), value of max is 9 and min is 1. Steps to perform MaxMin on a data set (2,4,6,3,8,1,9,7) are:(2,4,6,3) (8,1,9,7)((2,4)(6,3)) ((8,1)(9,7))In sublist (4,6), max is 6 and min is 4. In sublist (8,9), max is 9 and min is 8.Comparing max and min values of sublist (2,4) and sublist (6,3), value of max is 6 and min is 2.Therefore, for sublist (2,4,6,3) max is 6 and min is 2.Similarly, comparing max and min values of sublist (8,1) and sublist (9,7), value of max is 9 and min is 1.Therefore, for sublist (8,1,9,7) max is 9 and min is 1.Finally, comparing max and min values of sublist (2,4,6,3) and sublist (8,1,9,7), value of max is 9 and min is 1. Steps to perform MaxMin on a data set (2,4,6,3,8,1,9,7) are:(2,4,6,3) (8,1,9,7)((2,4)(6,3)) ((8,1)(9,7))In sublist (4,6), max is 6 and min is 4. In sublist (8,9), max is 9 and min is 8.Comparing max and min values of sublist (2,4) and sublist (6,3), value of max is 6 and min is 2.Therefore, for sublist (2,4,6,3) max is 6 and min is 2.Similarly, comparing max and min values of sublist (8,1) and sublist (9,7), value of max is 9 and min is 1.Therefore, for sublist (8,1,9,7) max is 9 and min is 1.Finally, comparing max and min values of sublist (2,4,6,3) and sublist (8,1,9,7), value of max is 9 and min is 1. sonika aggarwal GNIIT


What is Excel formula for range?

If you mean to find the difference between the highest and lowest number in a set, then you could use the MAX and MIN forumulas to find the two values and take the lowest from the highest. So if your values were in cells A2 to A20 then the formula would be: =MAX(A2:A20)-MIN(A2:A20) Your welcome