Version

UltraCalcFunctionMin Class

Gives you the smallest numeric value out of a series.
Syntax
'Declaration
 
Public Class UltraCalcFunctionMin 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionMin : BuiltInFunctionBase 
Remarks

MIN(Value1, value2, ..., valueN)

Value1, value2, ... valueN are any number of numeric values or references to numeric values from which you want the minimum value found. Arguments may be numbers, boolean values, text values convertible into numbers, or empty. Error values and text values that are not convertible into numbers will produce an error.

The minimum value for a series of numbers can be it's largest magnitude negative number because larger magnitude negative numbers are less than smaller magnitude negative numbers. For example, given the expression MIN( -1500, -50, 5, 150), the return value is -1500 and not 5. To determine the numeric value with the smallest magnitude you would use the ABS() function on each argument. The following example would produce a minimum value of 5.

MIN( ABS(-1500), ABS(-50), ABS(5), ABS(150))

When the argument list is empty, MIN() returns zero.

MAX()
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also