CFLib.org – Common Function Library Project

Description:
Returns the range for a set of numbers. The range is calculated by subtracting the smallest number in a set from the largest.

Return Values:
Returns a simple value.

Example:

<CFSET Values="1,2,3,4,5,6,7,8,9,10"> 

  <CFOUTPUT>
  Given <CFIF IsArray(Values)>{#ArrayToList(Values)#}<CFELSE>{#Values#}</CFIF>
  The range is #Range(values)#
  </CFOUTPUT>

Parameters:

Full UDF Source:

/**
 * Returns the range for a set of numbers.
 * 
 * @param values                 Comma delimited list or one dimensional array of numeric values 
 * @return Returns a simple value. 
 * @author Rob Brooks-Bilson (rbils@amkor.com) 
 * @version 1.0, July 18, 2001 
 */
function Range(values)
{
  Var MyArray = 0;
  if (IsArray(values)){
     MyArray = values;
    }
  else {
     MyArray = ListToArray(values);
    }  
  Return ArrayMax(MyArray) - ArrayMin(MyArray);
}