answersLogoWhite

0

If you had a list of numbers in the cells from A2 to A20, you could find the highest and lowest values using the MAX and MIN functions as follows:

=MAX(A2:A20)

=MIN(A2:A20)

You could also use the LARGE and SMALL functions in the ways shown below, though they are generally used for getting values like second largest or third smallest. In those cases you would change the 1 in the below examples to the appropriate values.

=LARGE(A2:A20,1)

=SMALL(A2:A20,1)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is a minimum value of a polynomial?

There is no minimum (nor maximum) value.


How would you describe the spread for a dot plot?

The spread is the minimum value (not count) to the maximum value. The range is the maximum value minus the minimum value. Spread does not consider the frequency of the values, only the minimum and maximum.


'How do you do formulas on Excel and continue to work with answer as a numerical value and not a formula '?

'How do you do formulas on excel and continue to work with answer as a numerical value and not a formula '


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

It is max(z1,...,z10)/min(z1,...,z10).


What is maximum value and minimum value?

pi value= 1


In Excel a button that inserts Excel functions to sum average or count all the values in a column or row or display the minimum or maximum value in a column or row is called the?

The Autosum button can do all of those things.


What is value seek in Excel?

You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.You are probably referring to Goal Seek. This is a facility where you can put in a formula and a result and then get Excel to generate a value that the formula would use to get that result.


Can standard deviation value be bigger than maximum and minimum value?

No standard deviation can not be bigger than maximum and minimum values.


What is the formula for PVIFA in Excel?

The PVIFA formula in excel refers to Present Value Interest Factor of Annuity. This is able to be calculated in an excel document.


Which is less a maximum or a minimum?

A minimum refers to the smallest possible value or quantity in a set or range, while a maximum refers to the largest possible value or quantity in a set or range. So, a minimum is less or smaller than a maximum.


How do you find minimum and maximum value of calculus?

In Calculus, to find the maximum and minimum value, you first take the derivative of the function then find the zeroes or the roots of it. Once you have the roots, you can just simply plug in the x value to the original function where y is the maximum or minimum value. To know if its a maximum or minimum value, simply do your number line to check. the x and y are now your max/min points/ coordinates.


What is the RGB to HSV formula for converting colors?

The RGB to HSV formula for converting colors is as follows: To convert RGB to HSV: Find the maximum and minimum values of R, G, and B. Calculate the value (V) by dividing the maximum value by 255 and multiplying by 100. Calculate the saturation (S) by subtracting the minimum value from the maximum value, dividing by the maximum value, and multiplying by 100. Calculate the hue (H) based on the maximum color component: If the maximum is R, then H 60 ((G - B) / (max - min)) (mod 360) If the maximum is G, then H 60 ((B - R) / (max - min)) 120 If the maximum is B, then H 60 ((R - G) / (max - min)) 240 This formula allows you to convert RGB values to HSV values, which represent colors in terms of hue, saturation, and value.

Trending Questions
What was the pair of jeans in 1998? What are the differents input devices of a computer? How is working with offline files different from simply making a second copy of the files you need to access? What is the difference between spyware and free ware? How many cubic feet of gravel do you need for a project that's 8 feet by 8 feet by 2 inches deep? You have set up your bank account with PayPal but when you tried to buy something after you log in to it on eBay it goes to a page asking for what looks like credit card details-what's going wrong? What does this mean Entry point except handler4 common could not be located in the dynamic link library msvcrtdll? How is the USB port called that stays on You can still charge something through it even if the computer is turned off? What does a computer Port do? Do you have to have your id for moneygram? What do DDR SDRAM for laptops comes in? If your computer will hold 1GB of memory and it only has 128 MB of memory how much can you add? Where is the location of the crankshaft position sensor for a infiniti 2006 m45? How do you convert a doc file into HTML using aspnet? Do you need a laptop for middle school? How can object oriented programming help maintain complex computer system? Does target sell Kindles? How do you attach the wireless adapter on gba emulator? Protocols at the blank layer accept frames from the Data Link layer and generate voltage so as to transmit signals? What are the inputs and outputs of preference?