Excel What Function shows value between highest and lowest number

[Mike R.]

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

 

[Sheeloo]

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

 

[Joerg Mochikun]

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