Function Math Complex Class

Neg

"Negate" or "Negative" Negate a real or complex number.

Signature (Visual Basic / VBA)

Public Function Neg( _
    ByVal vX As Variant _
    ) As Variant

Code Example

    Neg(3.4) = -3.4
    Neg(-3.4) = 3.4
    Neg("-2|-3") = "2|3"
    Neg("-2|3") = "2|-3"
    IsNull(Neg(Null)) = True

Parameters

Parameter Description
vX The number whose negative is returned. Function returns Null if vX is Null or cannot be fixed up to a real or complex number (as defined by the ComplexStringToReals function). Complex numbers are represented within strings as "R|I" where R is the real part and I is the imaginary part.