answersLogoWhite

0

Using the cells A1 to A15, the following functions can be used for what you want:

To get the highest value you can use either of two functions, though we most commonly use the first of these:

=MAX(A1:A15)

=LARGE(A1:A15,1)

The LARGE function can not only get the highest value, but also the second highest or third highest etc., by changing the 1 at the end to 2 or 3 etc.


To get the lowest you can use either of these two functions, where SMALL works similar to LARGE:

=MIN(A1:A15)

=SMALL(A1:A15,1)

To get an average you use the AVERAGE function:

=AVERAGE(A1:A15)

You could also get an average in this way, by totalling the values and divided by the amount of values by counting them, but it would be rarely used:

=Sum(A1:A15)/Count(A1:A15)

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you add the lowest number and highest number to get an average?

you get the lowerst and add it to the highest and there is your average


What will be the resultant if third digit of the lowest number is multiplied with the second digit of the highest number?

The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!The answer will depend on what the highest and lowest numbers are!


What are the highest number and lowest number on the pH scale?

1 is the lowest 14 is the highest and 7 is the middle


How many multiples of 3 in 10000?

To find the number of multiples of 3 in 10,000, we can use the formula for calculating the number of multiples of a number within a range. The formula is (Highest Number - Lowest Number) / Number + 1. In this case, the highest multiple of 3 less than or equal to 10,000 is 9999, and the lowest is 3. Plugging these values into the formula, we get (9999 - 3) / 3 + 1 = 3333. Therefore, there are 3333 multiples of 3 in 10,000.


What does average mean in math form?

Average - the central tendency of a data set is a measure of the "middle" or "expected" value of the data set (mean, median, mode) Layman's terms - the average of a math problem is the middle number, usually found by taking the highest number and subtracting the lowest number, or taking the highest and lowest numbers and finding the middle number.


Is a range the highest number and the lowest number divided by two?

no, it is the highest number subtracted by the lowest number ex: 4,5,8,10,17 the range would be 13


What is the highest and lowest factor?

Of any given positive number, the highest factor is the number itself, and the lowest factor is 1.


What is the highest and the lowest four-digit numbers?

Lowest four-digit number: 1000 Highest four-digit number: 9999


Is the mean an the average the same thing?

no, the mean is the number that appears in the middle when placed from lowest to highest, the average is the sum of the numbers divided by the amount of numbers.


Does range mean the highest number subtracted by the lowest number?

Yes. Range is when you subtract the lowest number by the highest.


How do you find the median when theres four numbers?

When sorted lowest to highest (or highest to lowest) the median is (2nd number + 3rd number)/2


What are the lowest prime number and the highest prime number between 1 and 100?

The lowest prime number is 2. The highest prime number less than 100 is 97.