Function Math Reals Class

StepFn

"Step Function" Returns 0 if X < 0; .5 if X = 0; 1 if X > 0.

Signature (Visual Basic / VBA)

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

Code Examples

    StepFn(-1) = 0
    StepFn(0) = 0.5
    StepFn(1) = 1
    StepFn(23) = 1
    If X < 0: Return 0.
    If X = 0: Return .5
    If X > 0: Return 1.
    Sgn(vX) / 2 + 1 / 2

Parameters

Parameter Description
vX Number whose step (as defined above) is returned. Function returns Null if vX is Null or cannot be fixed up to a number.

Notes & Version History

v1.5 BugFix Corrected this function to return 0 (zero) instead of -1 when vX is a negative number.