ExcelBanter - Excel What Function shows value between highest and lowest number

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel What Function shows value between highest and lowest number (https://www.excelbanter.com/excel-worksheet-functions/209951-excel-what-function-shows-value-between-highest-lowest-number.html)

Mike R.[_2_]

Excel What Function shows value between highest and lowest number

I need to know the function that calculates the difference between the
highest number and teh lowest number in a set of numbers.

Sheeloo[_3_]

Excel What Function shows value between highest and lowest number

=Max(A1:A100)-Min(A1:A100)

"Mike R." wrote:

I need to know the function that calculates the difference between the
highest number and teh lowest number in a set of numbers.

Joerg Mochikun

Excel What Function shows value between highest and lowest number

=MAX(A1:A10)-MIN(A1:A10)

"Mike R." <Mike wrote in message
...
I need to know the function that calculates the difference between the
highest number and teh lowest number in a set of numbers.

All times are GMT +1. The time now is 09:55 PM.