Range of data among cells

[graph]

Is there a function that will display the range of data from selected cells?
i.e. if i have 3 cells containing the numbers 2, 9 & 13 the range would be 11
(13-2)?

 

[Edward]

=MAX(array)-(MIN(array))

 

[Dave Peterson]

Maybe something like:

=max(a1:a3)-min(a1:a3)

Is there a function that will display the range of data from selected cells?
i.e. if i have 3 cells containing the numbers 2, 9 & 13 the range would be 11
(13-2)?

 

[graph]

Thanks much

Maybe something like:

=max(a1:a3)-min(a1:a3)

 

[graph]

thanks

=MAX(array)-(MIN(array))