Function Math Reals Class

Min3Real

" Minimum Of Three Real Numbers" Return the minimum of three numeric arguments. Returns the leftmost of the minimum arguments.

Signature (Visual Basic / VBA)

Public Function Min3Real( _
      ByVal vNum1 As Variant _
    , ByVal vNum2 As Variant _
    , ByVal vNum3 As Variant _
    ) As Variant

Code Example

    Min3Real(23, 45, 56) = 23
    Min3Real(-12, 12, 4) = -12
    Min3Real(2%, 2#, 2!) = 2%
    Min3Real("SA", "RO", "EN") = "EN"

Parameters

Parameter Description
vNum1 First of three numeric arguments, the minimum of which will be returned.
vNum2 Second of three numeric arguments, the minimum of which will be returned.
vNum3 Third of three numeric arguments, the minimum of which will be returned.

Notes & Version History

Note If all three arguments happen to be strings, they will be compared using Binary comparisons.
Note This function will generate an error if any of the arguments are not compatible, such as if one is a string and the other is numeric; see also the Min3Variant function.
Note This function does not support three-valued logic. The behavior of this function is undefined if any of the arguments are Null.