answersLogoWhite

0

You can use MAX to evaluate a list of thousands of sales transactions to determine quickly which day had the largest single transaction.

You can use the MIN function to compare hundreds of wholesale costs to determine the lowest cost for a particular item.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is the tabs in excel?

sum average max min count numbers


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)


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 are functions that may be displayed on the bottom toolbar in Excel when certain cells are selected?

Sum, Average, Max, Min and Count.


Give 5 functions of formulas in Excel?

Built-in formulas in Excel are known as functions. Here are five common ones: SUM AVERAGE COUNT MIN MAX


What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?

There is no single formula. MIN(range) and MAX(range) are the Excel formulae


What Functions may be entered for formulas in Excel?

Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.Any function can be used in a formula, depending on what the formula needs to do. There are well over 300 functions in Excel. Some of the most commonly used functions include SUM, AVERAGE, MIN, MAX, IF and COUNT, amongst many others.


In excel built in functions to determine the largest and smallest numbers contained in cells a1 through a22 would be what?

max() and min(). Provide the appropriate range, for example: =max(a1:a22).


Which function or value details may be displayed on the bottom toolbar in Excel when certain cells are selected?

Average Sum Count Max value Min Value


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 the meaning of maximum and minimum in Excel?

Maximum is the highest value from a set and minimum is the lowest number from a set. 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)


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)