Range of data among cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)?
 
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)?
Click to expand...
 
Back
Top