Issue

In Google Sheets:

I find the average using =ROUND(AVERAGE(A1:B2),1) and
the maximum using =MAX(A1:B2) and
the median using =ROUND(MEDIAN(A1:B2),1).

I looked through the list of functions Google provides, but I could not find a way to calculate the statistical range of a range of data cells.

How can I find the statistical range of A1:B2?

Solution

Is this what you are looking for?

=round(max(A1:B2),1)-round(min(A1:B2),1)

Answered By - Ed Nelson

Answer Checked By - David Goodson (PHPFixing Volunteer)