Range
Calculates the difference between the (numerical) minimum and maximum out of all of the values in a list of values, ranges and/or lists.
Syntax
Range(param1, param2, ...)Etendue(param1, param2, ...)
param1 = first parameter in the value set (value, range, or list)
param2 = second parameter in the value set (value, range, or list)
... = nth parameter in the value set (value, range, or list)
Remarks
This function accepts an unlimited number of parameters.
Any non-numerical values are ignored.
Examples
Range(1, 2) = 1 (= 2 - 1)Range(A1:B3) = Max(A1:B3) - Min(A1:B3)