0
In a range of cells it can find the highest value. So if you had numbers in all the cells from A2 to A20 and wanted to find the highest you could use the following formula:
=MAX(A2:A20)
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
The max function is an example of what function?
It is a Basic Statistical Function.
What is the difference between high and maxinum in Excel?
Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.Maximum is the highest value in a range of values and can be got using the MAX function. There is no function called High in Excel.
What is the difference between min and max function?
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)
What other functions can be used in conjunction with the SUM function to replace the sum range function argument?
Any function that generates a number, so there is a huge amount of them. You could for example use the MAX function to the get the highest of a range of values and put it in with several others and get something like this: =SUM(MAX(A1:A12),MAX(B1:B12),MAX(C1:C12)) However, such a calculation could be done without the SUM like this: =MAX(A1:A12)+MAX(B1:B12)+MAX(C1:C12) So a SUM function is best used with ranges, as that is its main purpose.
What does the SQL Max function do?
The "SQL Max function" is a computer programming term, which can be used in spreadsheets to give the highest value from the currently selected column.
Design a function named max that accepts two integer values as arguments and returns the value that is greater of the two For example if 7 and 12 are passed as arguments to the function the function?
The function already exists in PHP and is even called max(); Otherwise use: function max ($one, $two) { return $one > $two ? $one : $two; }
What function would you use to find the largest value in a range of cells?
In Excel, you can use the max() function. You can type a range (or several ranges) within the max() function. For a single range, just type: =max( and select the desired range, then type the closing parenthesis.
What function is used to locate the largest value in a group of records?
Use the MAX function.
What is the vertex of the quadratic function?
It if the max or minimum value.
How do you do a nested formula in Excel?
The short answer is that you can not, but there is a solution that will work for you. You are not able to automatically insert data into a cell from another cell; that would be a push of data, which Excel does not do. However, Excel can pull data from a cell.Put your formula in a cell. Use A1 for this example.Write another formula in the target cell to reference the value of A1. Use B1 for this example.In B1, put the formula, =A1 to show the value of A1 in B1.****this is not going to work for my prob dude.. check out discussion tab for more about my question, please. Please, please... please. :) need more help..
What is the function that returns the largest value in a set of values?
MAX
How do I get max to min serial or What function can I use to get max to min or min to max serial?
it will orbit the sun it self and the sun will keep it in the right spot for its temperature
