How do I compute the range of some data?
Excel does not have a built-in function for the
range, but it does have functions for the maximum and the minimum. So, if you want to compute the range of the numbers
in cells B31 to B35, then you can use the formula
=MAX(B31:B35)-MIN(B31:B35)