CFLib.org – Common Function Library Project

Description:
Returns the midrange value for a set of numbers. The midrange value is found by adding the min value in a set to the max value, then dividing by 2.

Return Values:
Returns a simple value.

Example:

<CFSET Values="1,3,5,7,9,99"> 

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

Parameters:

Full UDF Source:

/**
 * Returns the midrange value 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 Midrange(values)
{
  Var MyArray = 0;
  if (IsArray(values)){
     MyArray = values;
    }
  else {
     MyArray = ListToArray(values);
    }
  Return ((ArrayMax(MyArray) + ArrayMin(MyArray))/2);
}