Range: Maximum - Minimum Value

[carson]

Does anyone know how to set excel to identify a sample of values and work out the Maximum value from the minimum value.
eg:
2
4
6
8
10
=8

 

[Aladin Akyurek]

On 2002-03-20 12:32, carson wrote:
Does anyone know how to set excel to identify a sample of values and work out the Maximum value from the minimum value.
eg:
2
4
6
8
10
=8

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

where A1:A10 houses the values of interest.

 

[abe]

=MAX(A2:A6)-MIN(A2:A6)

 

[carson]

Thanks for the quick answer.