RangeRatio
Calculates the ratio between the last parameter and the range defined by all of the values in a list of values, ranges and/or lists, i.e. (last-Min)/(Max-Min).
Syntax
RangeRatio(param1, param2, ..., last)
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)
last = last 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
RangeRatio(1, 2) = 1 (= (2-1)/(2-1))RangeRatio(2, 1) = 0 (= (1-1)/(2-1))RangeRatio(1, 3, 2) = 0.5 (= (2-1)/(3-1))RangeRatio(A1:B3, B2) = (B2-Min((A1:B3, B2))/Range((A1:B3, B2)