Function Math Reals Class

DivideOnErrRtnZero

"Divide; On Error Return Zero" Divide two real numbers. Return 0 (zero) in case of division by zero and other errors.

Signature (Visual Basic / VBA)

Public Function DivideOnErrRtnZero( _
      ByVal vDividend As Variant _
    , ByVal vDivisor As Variant _
    ) As Variant

Code Example

    DivideOnErrRtnZero(3, 10) = .3
    DivideOnErrRtnZero(3, 0) = 0

Parameters

Parameter Description
vDividend Real number which is to be divided by the other number.
vDivisor Number of times that vDividend is to be divided.

Notes & Version History

Note Function returns 0 (zero) if errors occur during the division, such as when vDivisor is 0 (zero).