Maybe something like:

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


graph wrote:

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)?

--

Dave Peterson