answersLogoWhite

0

Say your values were in the cells A2 to A30, then you could do a formula like this:

=SUM(A2:A30)-MIN(A2:A30)-MAX(A2:A30)

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

Which company has the highest revenue?

Microsoft


What is the worlds highest paying career?

Ceo of microsoft


What companies have highest profit margin?

probably Microsoft


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 Microsoft stock's all-time highest price?

$58.34


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 function is used to determine highest number in a range?

The "maximum" function.


What is the highest exponent of linear function?

1.


What is the highest function of a human being?

advanced intelligence


What is The highest point on a graph in the domain of the function.?

mad


Who is the highest software company?

Microsoft. Ran by Bill Gates, The Richest Person in The World with $54B.


What position does Bill Gates hold in Microsoft?

He is the co-founder of it, so he has like the highest position.